Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Background
I am importing CSV data into Salesforce:
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?
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
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_gui...