Salesforce to Salesforce Transfer Records

Highlighted
One Star

Salesforce to Salesforce Transfer Records

Hi Community,

I am working on a process in Talend Open Studio for Big Data that will transfer a set of records into another Salesforce org. I then want it to go back to the original Salesforce org and update the successful records statuses to "transmitted". 

The problem is when there are errors. If one of the records fails to insert into Delphi, the job stops and won't update anything. If I turn off "cease on error" it will update all the record's statuses (even failed ones). 

Any ideas on how I can have the process only update the successfully inserted records status? Thanks in advance! 

2017-06-07_13-21-33.png

Highlighted
Sixteen Stars
Sixteen Stars

Re: Salesforce to Salesforce Transfer Records

Right click on tSalesforceOutput component to catch Main flow (inserted records) and memorize inserted records into a tHashOutput.

After the tFileInputExcel, add a tMap with a lookup with inner join based on the inserted records (using tHashInput associated to the previous tHashOutput).

This will give you the list of source records to be updated.


TRF
Highlighted
One Star

Re: Salesforce to Salesforce Transfer Records

Thank you for your reply!

I added what you recommended, but it appears to be sending all records (both inserted success and fails) to the tHashOutput. 

 

Any ideas? 

Highlighted
Sixteen Stars
Sixteen Stars

Re: Salesforce to Salesforce Transfer Records

Well, I didn't try...

Use Reject link instead of main then reverse the logic in tMap (set "Catch lookup inner join reject" to true for tMap output flow).


TRF
Highlighted
Four Stars

Re: Salesforce to Salesforce Transfer Records

Hello @sflknight

 

A record owner, or any user above the owner in the role or territory hierarchy, can transfer a salesforce single record to another user.

 

  1. Transfer multiple records by selecting the records from a list view and clicking Change Owner
  2. Transfer multiple records using the Mass Transfer tool

Users with the “Modify All Data” permission, or users with the “Modify All” permission for the given object, can transfer any record, regardless of who owns the record.

 

Hope it helps you.

Thanks.

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

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog