Summary:
Dremio allow users to connect to Dremio Server from Tableau either through JDBC or ODBC. In this article we focus on Tableau connects to Dremio through ODBC.
Reported Issue
Trying to connect to Dremio with Tableau via ODBC
Overview
Instructions on Tableau connecting to Dremio through ODBC.
Relevant Versions, Tools & Integrations
Prerequisite:
- Assure you have Tableau installed on your computer and have a valid license to access Tableau.
- Assure your you have installed the ODBC Manager
Download the Arrow Flight SQL ODBC Driver from https://www.dremio.com/drivers/odbc/ then install the ODBC driver into the ODBC Manager in your computer.
Steps to Resolve
Install and configure ODBC driver:
After downloaded the ODBC driver from Dremio’s website then installed into your computer. In this example, I installed ODBC driver into the Mac OS computer.
Launch the ODBC Manager on your computer then click on the Drivers tab then you will see the Arrow Flight SQL ODBC Driver.
Create DSN
- Click on the System DSN tab
- Click on the Add… button on the right
- In the Choose a driver windows, click on the Arrow Flight SQL ODBC Driver
- Click on the OK button
Click Add button to enter information under Keyword and Value then click OK button:
After you have entered Dremio's server information then clicked OK button, the DSN will be created as below:
Startup Dremio server
- Login to Dremio UI
- Run the sample query to make sure Dremio server is up and running
Startup Tableau
- Click on More…
- Click on Other Database (ODBC)
In the Other Database (ODBC) popup windows:
- Click on the DSN check box
- Click on the dropdown
- the Arrow Flight SQL ODBC DSN
The Dremio server information that entered in the ODBC Manager will display the click to Sign In button:
Retrieve data from Dremio Samples."samples.dremio.com"."zips.json"
Query the same data source (zips.json) to see if is the same schema that shows in Tableau:
Both shows the same schema. Therefore, Tableau connects and retrieve data from Dremio Server success.
Next Steps
n/a
Additional Resources
https://docs.dremio.com/current/sonar/client-applications/drivers/arrow-flight-sql-odbc-driver/