Connecting from non-validated BI tools
There are plenty of popular SQL database tools that are not (yet) validated – that is, they do not have a named Databricks connector. In this section, we will learn how to connect these non-validated BI tools to Databricks SQL using Databricks JDBC and ODBC drivers.
Non-validated BI tools do not come with bundled driver connectors and may or may not support all three authentication mechanisms supported by validated BI tools. However, Databricks SQL Warehouses support JDBC and ODBC connections. We can leverage these connections to connect from non-validated tools. Full documentation on JDBC and ODBC connections is available at https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html. They are straightforward and do not warrant detailed unpacking.
There are three steps:
- Download the JDBC or ODBC driver as applicable.
- Install the driver in the BI/SQL database tool.
- Configure the SQL Warehouse connection.
