Configuring Impala to Work with ODBC
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.
Note:
You may need to sign in and accept license agreements before accessing the pages required for downloading ODBC
connectors.
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. Although the 2.x drivers include authentication through either Kerberos tickets or username/password credentials, Impala only supports Kerberos for authentication.
See the downloads page for the versions of these drivers for different products, and the documentation page for installation instructions.
Important:
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.
<< Post-Installation Configuration for Impala | Configuring Impala to Work with JDBC >> | |