Salesforce : Using Jitterbit Data Loader to Sync Data
November 7, 2012 /
Posted in Integration Corner, Salesforce Corner
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 |
