Third-party products can be designed to integrate with Impala using ODBC. For the best experience, ensure any
third-party product you intend to use is supported. Verifying support includes checking that the versions of
Impala, ODBC, the operating system, and the third-party product have all been approved for use together. Before
configuring your systems to use ODBC, download a connector.
You may need to sign in and accept license agreements before accessing the pages required for downloading ODBC
Version 1.x of the Cloudera ODBC Connectors uses the original HiveServer1 protocol,
corresponding to Impala port 21000.
The newer versions 2.5 and 2.0, currently certified for some but not all BI applications,
use the HiveServer2 protocol, corresponding to Impala port 21050.
Impala supports Kerberos authentication with all the supported versions of the driver,
and requires ODBC 2.05.13 for Impala or higher for LDAP username/password authentication.
for the versions of these drivers for different products, and the
for installation instructions.
If you are using the Cloudera Connector for
Tableau, to connect Impala to your Kerberos-secured CDH clusters, contact your Tableau
account representative for an updated Tableau Data-connection Customization (TDC) file. The
updated TDC file will override the Tableau connection settings to set specific parameters on
the connection string that are required for a secure connection.
If your JDBC or ODBC application connects to Impala
through a load balancer such as haproxy
be cautious about reusing the connections.
If the load balancer has set up connection timeout values,
either check the connection frequently
so that it never sits idle longer
than the load balancer timeout value,
or check the connection validity before using it
and create a new one if the connection has been closed.