Connect Client Applications to Dremio
You can connect to Dremio from a variety of client applications. Connections are established using JDBC or ODBC.
Dremio supports a broad range of clients including the following applications:
- Alteryx Designer
- DataGrip
- DBeaver
- DbVisualizer
- Domo
- IBM Cognos Analytics
- Looker
- Microsoft Excel
- Microsoft Excel PowerPivot
- Microsoft Power BI Desktop, Microsoft Power BI Gateway, and Microsoft Power BI Service
- Microsoft Power BI with ADBC (Preview)
- Microstrategy Workstation
- Preset
- SAP Business Objects
- Superset
- Tableau
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.