how to insert/update the data from FTP server (CSV File) to

Using some of the few ways its possible:

1) Using salesforce API  ( e.g. Java, PHP, .Net APIs )
Using program (JAVA, PHP, .Net) can connect with and FTP server and read the csv data and insert/update it into salesforce (respective object) based on your requirement.

and then generate jar file and schedule job and its execute based on the scheduled time, if you use php then use it in cronjobs for the schedule purpose.

2) We can also use Dataloader command line interface ( CLI ) and can schedule .bat on windows or .sh and cron job on Linux / unix.

3) We can use the as well for read the data from FTP to Salesforce

4) using Jitterbit ( tool aslo possible

Written by 

3x Salesforce MVP | Platform Champion | 18x Salesforce Certified | MuleSoft Certified | 8x Trailhead Ranger | TechForce Services | Sydney | Australia

Leave a Reply

Your email address will not be published.