topic Re: Salesforce Import Really Slow! in Talend Studio

Salesforce Import Really Slow!

Anonymous — Sat, 16 Nov 2024 07:31:01 GMT

Background

I am importing CSV data into Salesforce:

Users
Accounts
Contacts
Opportunities
Notes

With each step, there are lookups so that the data is related correctly when in Salesforce.

I've increased the memory to both Talend application and in the job advanced settings.

Yet it's really slow importing, for example, when importing Opportunities I get 0.5 rows per second.

Question

How do I speed optimise the jobs to be faster?

Re: Salesforce Import Really Slow!

TRF — Fri, 05 Oct 2018 15:33:01 GMT

At least:

1- use tSalesforceOutputBulkExec instead of tSalesforceOutput component

2- deactivate or bypass any Validation Rules, Triggers, Workflow, Businesss Process and so on which may cause salesforce to slow down during mass import operations

Re: Salesforce Import Really Slow!

TRF — Mon, 08 Oct 2018 08:38:16 GMT

I forget a tip:

- set Concurrency Mode to Parallel for tSalesforceOutputBulkExec Advnced Settings (not always possible)

Have a look to this link for explainations https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_planning_guidelines.htm