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?
This design is not the better if you know the Accounts always exist on Salesforce side.
As soon as you have an external ID, I suggest you to use the UPSERT operation on tSalesforceOutput component. Don't need to read the Account object first to retrieve the Salesforce Id and proceed with an UPDATE.
