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

Shreyash Choudhary 126 Reputation points
2023-01-06T09:06:54.677+00:00

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

276851-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,471 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2023-01-12T22:11:11.6966667+00:00

    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.

    277234-image.png

    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.

    Thanks

    0 comments