Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
How to load data to lookup table in dynamics
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sushmitha
1
Reputation point
-2
I have two entities person and location which has many to many relationship between them in dynamics there is bridge table /intersection table called person_location that has unique id of both person and location table(person id and location id column-guid). As it is not possible to define alternate key column in dynamics for bridge table(it can't be modified).. I cannot do this using adf copy activity as it supports only upsert operation and a key column to be defined in dynamics..can you please tell me how to load data to this bridge table using dataflow task in adf
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,386 Reputation points Microsoft Employee2022-03-16T04:55:01.89+00:00 Hello @Sushmitha ,
Thanks for the question and using MS Q&A platform.As we understand the ask here is how to populate in the date in the bridge table with the correct data from from person and location table , please do let us know if its not accurate.
have you tried to use the copy activity by building queries using fetchXML . Since it has the capablity to join entities , so it help you . I have the sharing the link below just in case https://learn.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/dn531006(v=crm.8)Please do let me if you have any queries.
Thanks
Himanshu -
HimanshuSinha-msft 19,386 Reputation points Microsoft Employee
2022-03-23T19:08:43.77+00:00 Hello @Sushmitha ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu -
HimanshuSinha-msft 19,386 Reputation points Microsoft Employee
2022-03-24T18:54:13.793+00:00 Hello @Sushmitha ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .
Thanks
Himanshu
Sign in to comment