Salesforce : Using Jitterbit Data Loader to Sync Data

Recently, we have completed a project using Jitterbit Data Loader.

Customers usually ask us when they should use the free tool like Jitterbit Data Loader and when they should use commercial integration platform like Boomi. You can use the following table to compare:

 

  Use Data Loader
Use Integration Platform
Price
Free Has license cost
Integration logic
Straightforward, can handle minor transformation Can handle simple/complex transformation/logic
Hosting
A machine is needed to host the software Can choose to deploy in cloud or on a machine
Execution sequence
Free version does not support execution sequence Can handle execution sequence
Data Model
Should use to handle simple data model Can handle simple/complex data model
End Point Most Data Loaders support flat file (CSV) only. Data loader like Jitterbit can also support Database Can handle various application/endpoints