keyvault - oracle jdbc connection string

Question

hi all,
i trying to access oracle DB from Purview with SQL Authentication.
Oracle JDBC Connection string should be defined in Azure keyvault.
Anyone successfully configure Azure Secret key vault to access oracle DB over JDBC ? if yes could you please share JDBC url sample ?
thank you
regards,
Fouad

Answer 1

Hello @Boulbellout, Fouad ,

Thanks for the question and using MS Q&A platform.

This can either be:

A host name used by JDBC to connect to the database server. For for example, MyDatabaseServer.com or

• IP address. For for example,192.169.1.2 or
• Its fully qualified JDBC connection string. For for example,
• jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=oracleserver1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=oracleserver2)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=oracleserver3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))

For more details, refer to Register an Oracle source and a video on how to Register and scan Oracle database in Azure Purview.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote 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