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
More About This Author
Array
- Finance & Operations15 April 2024New pricing for Microsoft Dynamics 365 effective October 2024
- Finance & Operations7 April 2024Virtual entity in Data Management – 10.0.39
- Finance & Operations5 April 2024One Dynamics One Platform – D365FO – LCS – PowerPlatform
- Finance & Operations24 March 2024D365FO Service updates