How to paremeterize the Azure Data Factory Linked Service for Dynamics 365 for CI/CD Deployment through azure devops

Question

Hi,

I have a requirement to Insert/Update data into dynamics 365 as part of my pipeline which is all working good. Now, I need to parametrize this Linked Service, But as "Dynamic content" was not enabled for this particular connection and I have seen some recommendations mentioning to use advance editor.

Can someone help me on how to edit the JSON there and use it under "parameters" for azure devops CI/CD?

Any suggestions would be greatly appreciated.

Thanks!

Answer 1

Hi @Santhosh Reddy Masireddy ,
Welcome to Microsoft Q&A platform and thanks for posting your query.
I understand you want to parameterize the linked service for Dynamic 365 connector which doesn't have dynamic content option in the UI.

Not all connector linked services are supported parameterization using UI. Click here to see list of connectors which supports parameterization in UI . You can do the parameterization using Advanced section Specify dynamic contents in JSON format.

For more details, please check out this video: Parameterize Linked Services using Advanced section in Azure Data Factory

Hope this will help. Please let us know if any further queries.

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

• Please don't forget to click on button and take the satisfaction survey whenever the information provided helps you.
  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
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators