About keyvault used for linking services

NishimuraChinatsu-9854 756 Reputation points
2022-08-29T08:28:38.847+00:00

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?

235668-microsoftteams-image-4.png

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,098 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,328 questions
0 comments No comments
{count} votes

Accepted answer
  1. Suba Balaji 11,186 Reputation points
    2022-08-29T09:41:39.677+00:00

    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.

    235646-screenshot-2022-08-29-at-25554-pm.png

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

    235689-screenshot-2022-08-29-at-30530-pm.png
    235728-screenshot-2022-08-29-at-30729-pm.png

    Finally upon mentioning the name and default value of the parameter, you will be able to use the created parameter as below
    235751-screenshot-2022-08-29-at-30748-pm.png

    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.


0 additional answers

Sort by: Most helpful