Data loading time issue - Salesforce

Anonymous — Sat, 16 Nov 2024 06:10:36 GMT

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.

Re: Data loading time issue - Salesforce

TRF — Wed, 03 Apr 2019 09:26:47 GMT

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.