function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Christos KolonisChristos Kolonis 

Jitterbit Dataloader API question

Hello,

I would like to ask a question regarding the use of APIs and jitterbit performance. From what I understand, in order to retrieve data from a database and import them within Salesforce, jitterbit uses salesforce standard API and not the Bulk API. Can jitterbit used to retrieve a big amount of data from database and import it to Salesforce. If yes, what is the performance difference between using the Bulk API and the Salesforce standard API. Anyone able to answer to this question?

Thank you.
SwethaSwetha (Salesforce Developers) 
HI Christos,
Salesforce Standard API processes up to 200 records in one API call. However, SFDC BULK API processes about 10,000 records in one API call.

If the SFDC object contains large data sets, then it is advisable to use SFDC Bulk API. The performance would be much faster when loading large data sets using Bulk API when compared to the same job run on Standard API.

Using Standard API may cause an organization to use more of their allotted API requests per day than is necessary when processing large volumes of data.

Refer the following link for more information on BULK API:
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/

Ref:https://knowledge.informatica.com/s/article/497359?language=en_US

If this information helps, please mark the answer as best. Thank you