How to create Alternate key in dynamics 365 ,when i am runing ADF pipeline for upsert its failing

Question

Hi,
my source is Azure synapse SQL DB and target is Dynamics 365 country tables with two columns, i need to populate and update, but when i am running pipeline i am getting this alternate key error, how to create alternate key now in target which is dynamics CRM ??

please provide help/suggestions

Answer 1

Hello @Shreyash Choudhary ,

Thanks for the question and using MS Q&A platform.

The above error is because your Dynamics entity is missing alternate key defined which is required when you do an upsert.

To overcome this issue, you will have to define an alternate key for your entity. To do so, please follow this documentation for detailed steps:

• Dynamics 365 - Define alternate keys for an entity

Hope this info helps. Do let us know how it goes.

Thanks