topic Re: Need help to update record between two Salesforce orgs in Talend Studio

Need help to update record between two Salesforce orgs

Anonymous — Sat, 16 Nov 2024 04:24:54 GMT

Hi, I am new to Talend. I have to update Contact records of one Salesforce org based on the update action performed on same records in other org.

How to achieve this as I am getting error in job: Id value of incorrect type.

Please let me know the steps. I would really appreciate.

Thanks in advance.

Re: Need help to update record between two Salesforce orgs

TRF — Sat, 12 Oct 2019 08:34:39 GMT

Are you trying to reuse ids from your source org into the target org? This is not possible as they are attaches to one org.
Create a custom field on target org declared as an external id.
Populate this field with the source id and use it as the search key for the upsert operation.

Re: Need help to update record between two Salesforce orgs

Anonymous — Sat, 12 Oct 2019 11:30:01 GMT

Yes, I do have external id's in target org with legacy id's.
I want to know the steps on what components and how will I create a job for
this scenario.

Regards,
Akash

Re: Need help to update record between two Salesforce orgs

TRF — Sat, 12 Oct 2019 11:35:21 GMT

tSalesforceInput + tSalesforceOutput at least + tMap if mapping or transformation needed.
tSalesforceOutputBulkExec if huge volume.