How to Parameterize PostgreSQL linked service?

Subham Kedia 1 Reputation point

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.


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,174 questions
Azure Database for PostgreSQL
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,196 Reputation points Microsoft Employee

    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 :

    Please do let me if you have any queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png 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
    0 comments No comments