function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
OcoBriOcoBri 

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
Balaji Chowdary GarapatiBalaji Chowdary Garapati
@OcoBri:

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
  
Robert ZentgrafRobert Zentgraf
Hi OcoBri,

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
Fjolla DafinaFjolla Dafina
Hi there,

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