Update from MySql to Salesforce?

Highlighted
Four Stars

Update from MySql to Salesforce?

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?

 
 
Highlighted
Moderator

Re: Update from MySql to Salesforce?

@TheodoreMateo , your job design should be as shown below.Untitled.png

Manohar B
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Sixteen Stars
Sixteen Stars

Re: Update from MySql to Salesforce?

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.


TRF

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog