Update from MySql to Salesforce

[meta-carl]

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?

[manodwhb]

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

[meta-carl]

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

[manodwhb]

@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.

[meta-carl]

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

[meta-carl]

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

[meta-carl]

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: