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.
How do I speed optimise the jobs to be faster?
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...
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables