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
• Microstrategy Workstation
• Preset
• SAP Business Objects
• Superset
• Tableau

Drivers

• Arrow Flight SQL JDBC
• Dremio JDBC (Legacy)
• Arrow Flight SQL ODBC

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 JDBC Client Encryption (Enterprise Edition only)

Transport Layer Security (TLS) communication is enabled by default for Arrow Flight client applications. To configure encryption, see Arrow Flight Encryption. 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.