You need to sign in to do that
Don't have an account?
OcoBri
Is it possible to export data such as a report using FTP to a particular location automatically?
I understand this is not possible using the standard data export tool, but can it be easily accomplished with Visualforce or Apex?
Thank you
Thank you
You could choose one of these : (To The Best of my knowledge :) )
1) You can write apex to send a report out or do a callout to an external system to send the data you are looking where your application might need be able to handle the request and create those files for you! (Your external system could be also an Email Service, you can schedule the reports to be emailed from salesforce).
2)You can also choose an ETL tool to do that! (Multiple Options like Informatica,dbSync,etc.,)
3)You also can use Dataloader. By using the instructions from below link you can have the data loader configured to automate the export save it to your desired location!
https://code.google.com/p/dataloadercliq/
Hope it helps:
Thanks,
balaji
you can use the new possibility Salesforce Microsoft Power Query for Excel. Here, you can find some additonal information: http://mind-force.de/2015/01/07/salesforce-objekte-in-excel-exportieren-mit-salesforce-microsoft-power-query-for-excel/.
If you want to install this free Add-On, you can find it here: http://www.microsoft.com/en-us/download/details.aspx?id=39379
Regards
Robert
You can perform an automatical export of reports from SFDC to FTP with the help of this 3rd partiy no-coding tool - https://skyvia.com/data-integration/integrate-salesforce-ftp