Connect Client Applications to Dremio
You can connect to Dremio from several popular applications to query and visualize the data in Dremio. The applications and the compatible driver are listed in the table below.
| Client Application | Required Driver | Legacy Driver (Unsupported) |
|---|---|---|
| Alteryx Designer | Arrow Flight SQL ODBC | Legacy ODBC |
| Apache Superset | N/A | N/A |
| DataGrip | Arrow Flight SQL JDBC | Dremio JDBC (Legacy) |
| DBeaver | Arrow Flight SQL JDBC | Dremio JDBC (Legacy) |
| DbVisualizer | Arrow Flight SQL JDBC | Dremio JDBC (Legacy) |
| Domo | Arrow Flight SQL JDBC | Dremio JDBC (Legacy) |
| IBM Cognos Analytics | Bundled Dremio JDBC (Legacy) | Bundled Dremio JDBC (Legacy) |
| Looker | Bundled Dremio JDBC (Legacy) | Bundled Dremio JDBC (Legacy) |
| Microsoft Excel | Arrow Flight SQL ODBC | Legacy ODBC |
| Microsoft Excel PowerPivot | Arrow Flight SQL ODBC | Legacy ODBC |
| Microsoft Power BI | ADBC | Legacy ODBC |
| Microstrategy Workstation | Arrow Flight SQL JDBC | Dremio JDBC (Legacy) |
| Preset | N/A | N/A |
| SAP Business Objects | Arrow Flight SQL ODBC | Legacy ODBC |
| Tableau | Arrow Flight SQL JDBC | Dremio JDBC (Legacy) |
| Thoughtspot | Bundled Dremio JDBC (Legacy) | Bundled Dremio JDBC (Legacy) |
Supported Drivers
Developing Custom Applications
To create a connection to Dremio and run queries, you can use Arrow Flight SQL JDBC. You can also use PyArrow.
Client Encryption
Transport Layer Security (TLS) communication is supported for encrypting communication between JDBC client applications and Dremio servers. See the configuration of client TLS for Dremio on Kubernetes or Dremio standalone clusters for more information.
Transport Layer Security (TLS) communication is enabled by default for Arrow Flight client applications. See the configuration of Arrow Flight encryption for Dremio on Kubernetes or Dremio standalone clusters for more information. If you want to connect via unencrypted connections, you must explicitly disable useEncryption by setting it to false in the connection parameters for the Arrow Flight SQL ODBC driver.