'How to use KeyVault secret for Logic App SQL Connection String

I have a Azure Logic App, which is connecting to the SQL Server Database. Currently I am saving the connection string in configurations section of the logic app. I am planning to use the azure keyvault and get the connection string from there. I have gone through the online articles which tells about the keyvault connector. but I am not looking for that. I want to use the Keyvault secret for my sql server connections in the Azure Logic App.

enter image description here

I have also tried with the SQL GetRows as you can see below but I don't see any connection string textbox, where I can use the GetSecret Action Result enter image description here

sql-serverazureazure-logic-apps


Solution 1:[1]

As @Skin mentioned You can use Azure Key Vault's Get Secret action in your case. For this search for Azure Key Vault Connector and select Get secret action.

enter image description here

Now you need to establish a connection to your Key Vault by providing your Vault name and Tenant.

enter image description here

Then select the secret that you want to retrieve

enter image description here

After you run the logic app you can see the value that got stored in your key vault.

enter image description here

In Vault:-

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 SwethaKandikonda-MT

Related Questions