Dremio provides the following Dremio ODBC drivers:
Tip: To distribute query planning for ODBC and JDBC connections, configure secondary coordinator nodes for your deployment.
ODBC Parameters for Dremio wire encryption
If you are setting up encrypted communication between your ODBC/JDBC client applications and the Dremio server, use the following connection parameters to configure a connection to Dremio through an ODBC tool.
The Dremio ODBC driver does not support password protected PEM/CRT files or multiple CRT certificates in a single PEM/CRT file.
The SSL parameters in the following table are not required.
|SSL||Clear (0)||This option specifies whether the client uses an SSL encrypted connection to communicate with Dremio.
Enabled(1):The client communicates with Dremio using SSL.
Disabled(0): SSL is disabled. SSL is configured independently of authentication.
When authentication and SSL are both enabled, the driver performs the specified authentication method over an SSL connection. |
|TLSProtocol||Empty, which defaults to tlsv12.||This property specifies the TLS protocol version used.Accepted values are: tlsv1, tlsv11, tlsv12|
|TrustedCerts||The cacerts.pem file in the \lib subfolder within the Driver's installation directory.||The full path of the PEM file containing Trusted CA certificates, for verifying the server.
If this option is not set, then the driver defaults
to using the trusted CA certificates PEM file installed by the driver.
Note: The exact file path varies depending on the version of the driver that is installed. For example, the path for the Windows driver is different from the path for the Mac OS driver.
|UseSystemTrustStore||Clear (0)||This option specifies whether to use a CA certificate from the system truststore, or from a specified PEM file.
Enabled (1): The driver verifies the connection using a certificate in the system truststore.
Disabled (0): The driver verifies the connection using a specified PEM file.
Note: This option is only available on Windows. If using this option, import the certificate into the "Trusted Root Certificate Authorities” certificate store.
|DisableCertificateVerification||0||This property specifies that the driver verifies the host certificate against the truststore.
Accepted values are:
0: The driver verifies the certificate against the truststore.
1: The driver does not verify the certificate against the truststore.
|DisableHostVerification||0||This property specifies if the driver verifies that the host in the certificate is the host being connected to.
Accepted values are:
0: The driver verifies the certificate against the host being connected to.
1: The driver does not verify the certificate against the host.