Setting Up Dremio’s ODBC Driver for Windows
To set up Dremio’s ODBC driver on Windows operating systems:
Download the driver from www.dremio.com/drivers/odbc.
Follow these steps to install the driver:
a. Run the installation wizard.
b. Accept the license.
c. Click Install on the Choose Components screen.
d. To use the ODBC driver with Power BI Gateway or with a release of Power BI Desktop earlier than the August 2021 release, select the Microsoft Power BI Extension option.
e. Click Next when the installation is complete.
f. Click Finish to close the installation wizard.
What to Do Next
If you are using ZooKeeper for connections to Dremio, create a system DSN:
Do not follow these steps if you are using Microsoft Power BI to connect to Dremio. You do not need to create a system DSN.
Run the ODBC Data Source Administrator application.
Select the System DSN tab.
Select Dremio Connector and click Configure.
In the Connection Type section, follow the substep that suits your environment:
If your Dremio cluster is configured with secondary coordinator nodes, you can distribute query planning across those nodes and the main coordinator node. Select the ZooKeeper Quorum option. Then, in the Quorum field, specify the hostname or IP address of the ZooKeeper quorum’s host and the port in this format:
<ZK_QUORUM_HOST>:<ZK_PORT>. The default port is 2181.
If there a multiple Dremio clusters in the ZooKeeper quorum, in the Cluster ID field specify the path to one of the clusters, like this:
/path/to/ClusterA/coordinator. Include the keyword
coordinatorat the end of the path.
To plan queries on the single coordinator node for a Dremio cluster, specify the hostname or IP address for the coordinator node in the Direct to server field.
Change the authentication type to Plain, then specify your username and password for connecting to the Dremio cluster.
(Optional) Test the connection by clicking Test.
If you want to use an SSL-encrypted connection to your Dremio cluster through ODBC and use a client other than Microsoft Power BI Desktop, follow the additional instructions in the section ODBC Parameters for Dremio wire encryption" in “ODBC” for setting up communication encrypted by SSL.