Thank you for contacting to Microsoft QA.
I see you’re trying to establish a connection between your Azure Databricks Unity Catalog and an Oracle Autonomous Database, but you're hitting a snag with the wallet-based authentication requirement. Let's break it down.
Currently, Unity Catalog in Azure Databricks does not support wallet-based connections directly from the UI when creating an Oracle connection. The "Create Connection → Oracle" option primarily focuses on hostname/port/service name configurations, which do not facilitate the wallet-based approach required by Oracle ADB.
Options You Can Consider:
JDBC Connection: You might want to use a JDBC Unity Catalog connection, which allows for more flexibility in connecting to external databases. You would need to set this up in a way that accommodates wallet-based authentication.
Contact Support: Since the wallet-based authentication is a specific Oracle requirement not currently handled through the UI, it would be prudent to contact Azure support to confirm if there is a workaround or if this feature is on the roadmap for future releases.
Follow-Up Questions:
To assist you better, here are a few follow-up questions:
- Have you explored using JDBC connections with any custom configurations to see if that suits your requirements?
- Are you aware of any existing API or CLI methods in Databricks that might allow you to set up wallet-based authentication indirectly?
- Would you need help with specific configurations for setting up JDBC, or are you looking for guidance on a different aspect?