Oracle Communities

Oracle Analytics and AI

Child Item

Connection to Databricks from Oracle Analytics Server - Fails to load catalog

Trying to connect to data bricks from OAS using SIMBA Spark ODBC driver. In the DSN setup the connection is successful, but when try to refer it from OBIEE admin tool to import metadata, not able to see any catalog folders. Is there any listed steps to achieve this connectivity ?

Find more posts tagged with

Oracle Analytics Server

Accepted answers

Brendan T

These links might be of help

https://community.databricks.com/t5/data-engineering/odbc-data-source-to-connect-to-a-databricks-catalog-database-via/td-p/96354

https://community.databricks.com/t5/get-started-discussions/how-to-connect-to-databricks-from-oracle-analytics-cloud/td-p/37165

also ensure you are using a supported versions of the Simba driver

All comments

Brendan T

These links might be of help

https://community.databricks.com/t5/data-engineering/odbc-data-source-to-connect-to-a-databricks-catalog-database-via/td-p/96354

https://community.databricks.com/t5/get-started-discussions/how-to-connect-to-databricks-from-oracle-analytics-cloud/td-p/37165

also ensure you are using a supported versions of the Simba driver

SNanda

Hi @Brendan T, this link "https://community.databricks.com/t5/data-engineering/odbc-data-source-to-connect-to-a-databricks-catalog-database-via/td-p/96354" helped to resolve the issue locally.

Facing problem now in the Server where OAS is installed and updating the Simba ODBC config there. Not successful yet, but will keep updated. Thanks for the assist.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/75302#Comment_75302

Very helpful information.

Thanks for sharing @Brendan T!

Brendan T

https://community.oracle.com/products/oracleanalytics/discussion/comment/75400#Comment_75400

Thanks for updated this post with what worked for you. They will be useful for others who might encounter a similar issue.

SNanda

Confirming that I am now able to access the data-bricks tables locally as well as from OAS server.