I am upserting to salesforce, but the data is upserting at a very less pace around 5000 records get upserted in 45 min, Is there any way to do it faster.
Are you using bulk component or not? Did you compare response time with DataLoader? Standard or custom object? Do you have many process builder/workflow/validation rules/triggers on salesforce side?
I am using tSalesforceOutput component of talend not custom one, can we make upsert fast in this component or these are for very small number of data and have to use bulk component.
I have checked Retrieve Id in the advance setting, that might be the reason, but I need salesforce id for further operation and Die on Error and Ignore Null is unchecked
Retrieving salesforce Ids is an usual use case and this is not the root cause of poor performances.
Once again, compare with DL and if your job is really slower than DL then you probably have something wrong somewhere in your job but I can't guess where/what as soon as you don't share your design.
I am not getting what design are you looking, there is an input file which is upserting the data in a salesforce object on the basis of key. Data loader, I need to check because I am new to this and not a salesforce developer.
