Linked Service Dynamics CRM Online : How to set up organization

Question

HI,
I'm trying to use Dynamics CRM Service as Linked Service in Azure Data Factory.
The system ask

• url
• principal id

And we can choose the secret un key vault.

But for url and principal id, we can not set up values from settings ou key vault.
The fact is : we use a CRM organization per environment (dev or prod).

How can we set up connection (maybe directly in pipeline or dataset) to do what we want.

Thanks for your reply

Answer 1

Hi @THYOT Vital ,

Welcome to Microsoft Q&A Platform. Thank you for posting your query here.

In Dynamic CRM linked service "Service Uri" & "Service Principle ID" has to be hard coded. We can't make it dynamic using parameters or Key vault secrets.

Please check below link to know more details about Dynamic CRM Connector.
https://learn.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365

For your dev and prod if you have different service Uri then you should create two linked services each for one.

Hope this will help. Thank you.

----------------------------------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.