Accessing Azure KeyVault

Arun
Arun Member
edited December 2023 in General

I have stored my Azure SQL's connection string as a secret in the Azure KeyVault. I wanted to access this secret value while trying to create an External System.

Best Answer

  • Henry Simms
    Henry Simms Administrator
    Answer ✓

    Hi @Arun , I don't think it's currently possible to reference a secret in a Key Vault from Data Studio's external system configuration. This sounds like a useful security feature, and something that might be supported in future.

Answers

  • Arun
    Arun Member

    @Henry Simms Thanks for your clarification.

  • Henry Simms
    Henry Simms Administrator
    edited September 5

    Update on this: v2.14.13 includes a new set of API endpoints that can be used to create and update credentials used by JDBC connections (External Systems) like Azure SQL. When called, the endpoints will allow you to update or create credentials, which makes it possible to script / automate accessing and using things like passwords from a secrets manager of your choice.

  • Arun
    Arun Member

    Thank you, Henry. This will be very helpful. We’ll upgrade to the latest Studio version and attempt to retrieve the key vault’s secret to establish connectivity. We’ll let you know if we encounter any challenges.