Parameterizing linked service

Question

Currently in my work environment we are having 3 linked services ( All 3for seperate databases) for 3 different pipelines in the same adf without key vault.. So we planned to implement azure key vault and paramaterize the linked service so that a single linked service can be used to connect all db in that adf

So I have created key vault first and created three seperate secrets to store connection string values

Now coming back to linked service in adf when i chose the azure key vault option, it is asking to enter key vault name ( that i have entered which i created now) Next for secret name i want to parameterize and pass values dynamically from corresponding pipeline... Is that possible or how i can pass values to the secret name

tomfox · Answer

Hi&nbsp;Murugeswari_Muthurajan,&nbsp;This answer comes probably a bit late, but there might be others who are interested in this in the future as well.&nbsp;You can parameterize the secret name by adding a new parameter in the "Edit linked service" section for your database (i.e. "KeyVaultSecretName"):&nbsp;After that, you can reference the parameter in the secret section by clicking on "add dynamic content" with the syntax:&nbsp;&nbsp;@linkedService().KeyVaultSecretName&nbsp;&nbsp;1.&nbsp;&nbsp;2.&nbsp;&nbsp;It should look like this in the end:&nbsp;Hope this helps!&nbsp;/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/&nbsp;

Forum Discussion

Parameterizing linked service

1 Reply

Resources