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

Shreyash Choudhary 41 Reputation points

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


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,304 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 33,136 Reputation points Microsoft Employee

    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:

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


    No comments