function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Hiep LeeHiep Lee 

Best solution for daily schedule export data from Salesfore to Windowns local server(CSV files)?

My customers want to export special data from Salesforce to local windows server daily. They are using Dataloader in the manual way to export data every day. But they want to save human resource by creating a tool which auto export data every day without any extra actions. I am doing the Dataloader Windows command line but I have some question: 
- Can I do many actions in one process-conf.xml file? The system will be extended and many data from many objects need to be backup every day.
- Is it good to run with many users and many servers?
- There is any better coding solution?
 
Raj VakatiRaj Vakati
Use salesforce dataload CLI to extract the data 
and Configure using the windowns task scheduler 
Hiep LeeHiep Lee
Raj V, I am did using it guy. And I looking for some better advice.
Dano van CapelleveenDano van Capelleveen
Yeap, there are better solutions for daily scheduled data export from Salesforce to your PC, but you suppose to use some 3rd party solutions like Dataloader.io (https://dataloader.io/) and Skyvia Salesforce Dataloader (https://skyvia.com/data-integration/salesforce-data-loader). They are totally no-coding and have flexible scheduling features.
Michael TomarMichael Tomar
Well, we tried many solutions for this purpose. Eventually we sticked to Skyvia tool, which allows us to export and Import CSV files to Salesforce: https://skyvia.com/data-integration/salesforce-csv-file-import-and-export
It's a cloud-based platform, that doesn't require configuration and coding knowledge (as it was already mentioned). Also provides a free version.