question

SubhamKedia-9785 avatar image
0 Votes"
SubhamKedia-9785 asked HimanshuSinha-MSFT commented

How to Parameterize PostgreSQL linked service?

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

195114-image.png

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

195107-image.png

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

195136-image.png

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

195145-image.png

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.

195181-image.png




azure-data-factoryazure-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

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

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 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered

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


5 |1600 characters needed characters left characters exceeded

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