AnsweredAssumed Answered

I'm looking for the best way to update a SQL database

Question asked by btcrenshaw832419 on May 31, 2016
Latest reply on Jun 20, 2016 by Adam Arrowsmith

I'm looking for the best way to update a SQL database and insert if the record is not found. I'm thinking a SQL script on the database profile would do it. However, my connector is to Inntos (XML data) and I'm not sure how to do tell Boomi to update the record if the record ID exists and insert if it doesn't. Any suggestions?

 

Thanks,

 

Todd

Outcomes