Not able to access data registered in Unity Catalog using Simba ODBC driver

Get Started Discussions

Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.

Hi folks,

I'm working on a project with Databricks using Unity Catalog and a connection to SSIS (SQL Server Integration Services).

My team is trying to access data registered in Unity Catalog using Simba ODBC driver version 2.8.0.1002. They mentioned they can connect but catalog and metadata does not appear.

They mentioned Unity Catalog doesn't allow DSN connection and that this is the type of connection being used currently. Follows documentation used from Alteryx Databricks Unity Catalog.

I'm looking for alternatives and possible cause of this problem.

It follows print with configurations used: