question

arkiboys avatar image
0 Votes"
arkiboys asked NandanHegde-7720 answered

dynamic key vault

Hello,
I have created a linkedservice to sql server where database and server names are passed into it via a parameter.
For the sql authentication part, I have manually entered the generic user account and typed the password manually.
This allows connection to sql server using the same login but (different server and database as they get passed as parameters)
Question:
I would like to put the login details into AKV.
How do I put the login details into AKV and yet be able to use the linkedservice with the parameters for the server and database name?
Thank you

azure-data-factory
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.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered

Hey,
You can parameterize the values and have those values in key vault and either get them directly via LS key vault integration wherever possible or use web activity to get those values.

https://www.delorabradish.com/azure/azure-data-factory-adfv2-parameterizing-linked-services-that-do-not-have-built-in-dynamic-content

https://github.com/NandanHegde15/Azure-DataFactory-Generic-Pipelines/blob/main/Get%20Secret%20From%20KeyVault/Pipeline/GetSecretFromKeyVault.json

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.