I need realize this simple flow:
1) I must read records from a mysql table
2) I must insert this data (i can use tMap) in Salesforce object
3) I must update the opriginally record in mysql table with salesforce record ID
What I can do? how can I get the salesforce id and update table column of originally record?
Can you help me?
Benny
Hi,
From you description, you can design your job as:
tMySqlInput(read records from a mysql table)-->tMap(further processing)-->tSalesforceOutput(insert this data in Salesforce).
3) I must update the opriginally record in mysql table with salesforce record ID
Could you please set an example with input and expected output for us?
Best regards
Sabrina
Clear Extend Insert checkbox From Advanced Settings then tick Retrieve Insert Id option.
This will have you salesforce ids after Insert operation. Then you can update original records.