Using credentials from Azure key vault to connect to sql server in azure vm using JDBC

alexis 101 Reputation points
2022-11-16T12:13:32.59+00:00

Hi,

I am trying to connect to my sql server located in azure vm with Databricks using JDBC. I am not sure if it is common to put credentials in the code but in order to avoid that, I was wondering if it is possible to fetch the credentials from Azure key vault instead?
Any other suggestions/recommendations regarding how to do it are also welcome

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,305 questions
{count} vote

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
    2022-11-17T03:41:37.68+00:00

    Hello @alexis ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is how to use the AKV to retreive the secrets in Azure databricks , please do let us know if its not accurate.
    We do have a good document whicj you can follow to set it us .

    https://learn.microsoft.com/en-us/azure/databricks/security/secrets/secret-scopes

    261196-image.png

    Please do let me if you have any queries.
    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.