Data loading time issue - Salesforce

[Anonymous]

Hi Talends,

I am facing a problem regarding long record loading times.

Roughly described, I am upserting records via tSalesforceOutputBulkExec into a salesforce org.

One load consists of about 160K records, 5 columns each (appr. 6MB).

It is devided into batches of 10000 records. In total the process of loading the data into the salesforce standard object lasts about 6 hours.

Most of the batches facing timeouts, so they need 1-2 trials to get loaded into SF.

Do you have an idea what could be the problem or any suggestions for improvement?

Do you need futher information?

Thank you very much!

Best regards.

[TRF · Accepted solution]

In most cases poor performances are due to salesforce components such as process builder, triggers, workflow and so on...

You should consider to deactivate or bypass them to run your jobs.