Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m stuck

Is there a way I can update my table in SQL with the newly created record ids after they are inserted into Salesforce.

I want to insert records from our SQL database into Salesforce. This is going to be a nightly process since we will get new records coming in every night. I need to update this table with the Salesforce ID after it's been inserted into Salesforce so I can do a match and merge/update in another process. Since every column will have a potential to be changed from the user, there isn't any combination of values that will be able to get me a match every time.

Thanks in advance

P.S. I'm still little new to SQL and integrations, so please be easy in your explanations.
1 person has
this question