How to Parameterize PostgreSQL linked service?

Question

question

SubhamKedia-9785 asked Apr 21, '22 HimanshuSinha-MSFT commented Apr 27, '22

How to Parameterize PostgreSQL linked service?

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-database-postgresql

image.png (195.1 KiB)

image.png (212.9 KiB)

image.png (188.9 KiB)

image.png (192.1 KiB)

image.png (209.6 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT · Apr 27 at 07:28 PM

Hello @SubhamKedia-9785,
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

0 ·

Answer 1 · 2022-04-22T18:37:37.357Z

HimanshuSinha-MSFT answered Apr 22, '22

Hello @SubhamKedia-9785,
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://docs.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

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question