Data loading time to Salesforce

Anonymous — Sat, 16 Nov 2024 06:10:40 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 to Salesforce

Anonymous — Mon, 20 May 2019 04:14:33 GMT

Hello,

Could you please let us know on which talend build version you got this issue? Screenshots of job setting will be preferred.

Best regards

Sabrina