Salesforce : Using Jitterbit Data Loader to Sync Data

By Tony | November 7, 2012

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