About keyvault used for linking services

Question

It's about the keyvault secret key used in the link service.

We recognize the following settings in keyvaults for the connection string in MySQL's link service.
Specify the name of the Azure Key Vault secret that stores the destined MySQL linked service's connection string (e.g. Server=<server>;Port=<port>;Database=<database>;User=<username>;Password=<password>

I wanted to set the database name in the parameters, so I used the secret key [Server=<server>;Port=<port>;Database=@{linkedService().prm_dbname};User=<username>;Password=< password>].

Is it possible to set parameters in the secret key?

Answer 1

Hi,

Thanks for your question, on MS Q&A portal.

You can parameterize the database name. While creating linked service, you have the option to mention the server name, database name dynamically. Please check the below screenshot, when you click on the add dynamic content, you will get option to create a parameter.

Click on the + icon to create a new parameter by giving name and default value of parameter

Finally upon mentioning the name and default value of the parameter, you will be able to use the created parameter as below

Once we have parameterized the database name, whenever this linked service is used in any data set, you will be prompted to provide the value of dbname during run time. The value can then be passed on from pipeline to dataset through data set parameter.

Please let us know if it works. Please note that, you cannot parameterize part of the secret key. You can opt to store the credential alone in the secrets if need be, not the connection string, if it has to be parameterized.