About the Simba Databricks ODBC Connector

The Simba Databricks ODBC Connector is used for direct SQL access to Databricks data sources, enabling Business Intelligence (BI), analytics, and reporting on Databricks Spark-based data. The connector efficiently transforms an application’s SQL query into the equivalent form in HiveQL, which is a subset of SQL-92. If an application is Databricks-aware, then the connector is configurable to pass the query through to the database for processing. The connector interrogates Databricks to obtain schema information to present to a SQL-based application. Queries, including joins, are translated from SQL to HiveQL. For more information about the differences between HiveQL and SQL, see SQL Connector for HiveQL.

The Simba Databricks ODBC Connector complies with the ODBC 3.80 data standard and adds important functionality such as Unicode and 32- and 64-bit support for high-performance computing environments.

ODBC is one of the most established and widely supported APIs for connecting to and working with databases. At the heart of the technology is the ODBC connector, which connects an application to the database. For more information about ODBC, see Data Access Standards on the Simba Technologies website: https://www.simba.com/resources/data-access-standards-glossary. For complete information about the ODBC specification, see the ODBC API Reference from the Microsoft documentation: https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/odbc-api-reference.

The Simba Databricks ODBC Connector is available for Microsoft® Windows®, Linux, and macOS platforms.

The Installation and Configuration Guide is suitable for users who are looking to access data residing within Hadoop from their desktop environment. Application developers might also find the information helpful. Refer to your application for details on connecting via ODBC.