Upsert the records using Copy Data tool – Data Factory

In one of my previous blog, I explained on copying the data from D365 to azure DB using ADF`s Copy Data tool.

In that example, The tool copies/appends the data as such if there are no indices defined in the target table and throws error in presence of index.

Most of our requirements would expect update if the record exists or insert if it doesnt. I am using the same tool but tweaked…

Continue Reading AnithaEswaran’s Article on their blog

Upsert the records using Copy Data tool – Data Factory

In one of my previous blog, I explained on copying the data from D365 to azure DB using ADF`s Copy Data tool. In that example, The tool copies/appends the data as such if there are no indices defined in the target table and throws error in presence of index.

Blog Syndicated with AnithaEswaran’s Permission