I need some help please. Here is my current process:
1. Receive a file from a 3rd party
2. Stage the file in a MS SQL Server database table (Table A)
3. Read the records from Table A and insert the data into Salesforce (which auto-generates an Id value)
4. Update Table A with the newly created SF Id value
I am stuck on step 4. I cannot figure out how to get Talend to make the update in Table A. Pics attached.
If I can provide further clarification, please let me know and thanks in advance for your help.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema