https://community.qlik.com/t5/Talend-Studio/Update-from-MySql-to-Salesforce/m-p/2274918#M51452 <P><A href="https://community.qlik.com/s/profile/0053p000007LRBIAA4">@TheodoreMateo</A>&nbsp;, your job design should be as shown below.<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaGR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130874i2C10817742A794EE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaGR.png" alt="0683p000009MaGR.png" /></span></SPAN></P> Tue, 26 May 2020 14:06:25 GMT manodwhb 2020-05-26T14:06:25Z https://community.qlik.com/t5/Talend-Studio/Update-from-MySql-to-Salesforce/m-p/2274917#M51451 <DIV class="lia-quilt-column lia-quilt-column-18 lia-quilt-column-left lia-quilt-column-main-left"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"> <DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <P>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?</P> </DIV> </DIV> <DIV class="lia-rating-metoo lia-component-me-too lia-component-message-view-widget-me-too"> &nbsp; </DIV> </DIV> </DIV> <DIV class="lia-quilt-column lia-quilt-column-06 lia-quilt-column-right lia-quilt-column-main-right"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"> <DIV class="LabelsForArticle lia-component-labels lia-component-message-view-widget-labels-with-event"> <DIV class="LabelsList"> &nbsp; </DIV> </DIV> </DIV> </DIV> Sat, 16 Nov 2024 02:19:40 GMT https://community.qlik.com/t5/Talend-Studio/Update-from-MySql-to-Salesforce/m-p/2274917#M51451 Anonymous 2024-11-16T02:19:40Z https://community.qlik.com/t5/Talend-Studio/Update-from-MySql-to-Salesforce/m-p/2274918#M51452 <P><A href="https://community.qlik.com/s/profile/0053p000007LRBIAA4">@TheodoreMateo</A>&nbsp;, your job design should be as shown below.<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaGR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130874i2C10817742A794EE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaGR.png" alt="0683p000009MaGR.png" /></span></SPAN></P> Tue, 26 May 2020 14:06:25 GMT https://community.qlik.com/t5/Talend-Studio/Update-from-MySql-to-Salesforce/m-p/2274918#M51452 manodwhb 2020-05-26T14:06:25Z https://community.qlik.com/t5/Talend-Studio/Update-from-MySql-to-Salesforce/m-p/2274919#M51453 <P>This design is not the better if you know the Accounts always exist on Salesforce side.</P> <P>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.</P> Tue, 26 May 2020 16:03:10 GMT https://community.qlik.com/t5/Talend-Studio/Update-from-MySql-to-Salesforce/m-p/2274919#M51453 TRF 2020-05-26T16:03:10Z