Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Update local MS SQL Server table with Salesforce Id

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.

Labels (3)
2 Replies
Anonymous
Not applicable
Author

Anyone?

Anonymous
Not applicable
Author

Bueller?