We currently have a scheduled batch process that sends out a nightly email that uses a visualforce email template that exports and attaches 4 CSV files.
We are now wanting to create a new process that will export the data directly, rather than send the 4 attachments in an email. The size of the attachments is unwieldy and clogging up the recipients email boxes. So, we are looking to change the process. Is it possible to create an Apex web service that can be called externally by a third party that could generate the 4 CSV files? Basically, an on demand call to query, retrieve, export to CSV and deliver the response to the requestor? Is this possible?
I don't believe writing an Apex batch process to export the data will work because it can't send the data to an ftp site to be picked up, correct?
I was looking into Jitterbit as an option. Can that be scheduled to run an export nightly or weekly and then deliver the exported CSV files to a ftp site? Some middleware tools are not allowed due to corporate policies, so I'm wondering if the web service option is viable?
Thanks for any suggestions.