question

BoulbelloutFouad-7310 avatar image
0 Votes"
BoulbelloutFouad-7310 asked PRADEEPCHEEKATLA-MSFT commented

keyvault - oracle jdbc connection string

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

azure-key-vaultazure-purview
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @BoulbelloutFouad-7310,

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 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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thanks for your response. In fact what i disovered is that in the secret key vault we only need to specify oracle user password. We should enter the full connection string.
This is true at least when connect to Oracle from Azure Purview.
Regards,
Fouad

0 Votes 0 ·

Hello @BoulbelloutFouad-7310,

Yes, that's true you can user name and user password to store in Azure Key Vault - secret key.

0 Votes 0 ·