topic Update from MySql to Salesforce in Talend Studio

Update from MySql to Salesforce

meta-carl — Sat, 16 Nov 2024 02:26:46 GMT

I have a Mysql-Table and want to update Salesforce Account. I have an externalId in Mysql matching an externalId in Salesforce Account. I want to update 5 fields in SF with Values from MySql. Which components do I need on my way?

Re: Update from MySql to Salesforce

manodwhb — Thu, 14 May 2020 11:06:48 GMT

@meta-carl ,you need to use tSalesforceOutput component to update.

Re: Update from MySql to Salesforce

meta-carl — Thu, 14 May 2020 11:24:19 GMT

I need tDBInput and tSalesforceOutput. Where do i specify the conditions for my update? Update where msyql.externalId = Salesforce.Account.externalId ?

Re: Update from MySql to Salesforce

manodwhb — Thu, 14 May 2020 11:56:13 GMT

@meta-carl , you need to get the data from mysql and do join with salesforce object and get external id and update salesforce object.

your job should be like below.

Re: Update from MySql to Salesforce

meta-carl — Mon, 25 May 2020 06:37:58 GMT

tLogRow shows the data I want to update.

I get an Error-Message:

Exception in component tSalesforceOutput_1 (ContactDetail_Account_InvoiceAddress_innerjoin_tMap)
java.io.IOException: Account ID: id value of incorrect type:

tmap_join_account.png

Re: Update from MySql to Salesforce

meta-carl — Mon, 25 May 2020 09:18:34 GMT

What can I do regarding this error?

Exception in component tSalesforceOutput_1 (ContactDetail_Account_InvoiceAddress_innerjoin_tMap)
java.io.IOException: Account ID: id value of incorrect type:

tmap_join_account.png

Re: Update from MySql to Salesforce

meta-carl — Mon, 25 May 2020 09:21:04 GMT

I created a tmap as told above.
What can i do regarding this error?
Exception in component tSalesforceOutput_1 (ContactDetail_Account_InvoiceAddress_innerjoin_tMap)
java.io.IOException: Account ID: id value of incorrect type: