How to Parameterize PostgreSQL linked service?

Question

I have created a pipeline for copying data from one PostgreSQL table to another Postgresql table.

I have two linked services - one for PostgreSQL which is source and one for Azure Database for Postgresql which is sink.

I have two ADF - cicd123 is my Dev ADF and cicd1234 is my UAT ADF.

I want to transfer my pipeline from Dev ADF to UAT ADF for which I have used an Azure Devops pipeline.

I want to parameterize my linked service both for PostgreSQL and Azure Database for Postgresql.

I have tried to use JSON to make it dynamic but its not working.

Answer 1

Hello @Subham Kedia ,
Thanks for the question and using MS Q&A platform.

As we understand the ask here is how to paramterized the linked service , please do let us know if its not accurate.
In your case I see that you are using the @parameterXXXXX in the expression . I just wanted to point out that you should use @{linkedService().paramName}
I request you to please look into the doc here : https://learn.microsoft.com/en-us/azure/data-factory/parameterize-linked-services?tabs=data-factory#supported-linked-service-types

Please do let me if you have any queries.
Thanks
Himanshu

---

• Please don't forget to click on or upvote button 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