Here is a list of some common problems and steps to resolution.

Note: Tableau will provide reasonable levels of customer support to assist in troubleshooting connections with JDBC drivers, but can't create or customize a connector to work with a specific JDBC driver. Some JDBC drivers might not work with Tableau. Some JDBC drivers will support the full Tableau interactive experience, while others may work only for creating extracts.

Tableau provides no guarantee or warranty that using the Other Databases (JDBC) connector with any particular JDBC driver or database will be able to successfully connect and query data. Tableau supports the ability to customize your JDBC data connection, which can improve the connection experience. Note: If you are using a version of Tableau Desktop before 2020.2, see the Driver Downloads (Link opens in a new window) page for instructions on installing Java. Starting with version 2020.2, all Tableau applications are bundled with the Java Runtime, so you don't have to install it separately. JDBC requires Java, which makes it platform-independent. This includes both official named connectors, such as Athena, and generic connector for use with other JDBC-based drivers, called Other Databases (JDBC).

TrustedCerts=/opt/cloudera/impalaodbc/lib/universal/cacerts.Tableau supports JDBC (Java Database Connectivity) drivers for several connectors. # Username/password authentication with SSL settings. # 6 - Username/password authentication (NOSASL) # 5 - No authentication with SSL (NOSASL) # 4 - Username/password authentication with SSL (SASL) # 3 - Username/password authentication (SASL) # They can also be specified on the connection string. # Values for HOST, PORT, KrbFQDN, and KrbServiceName should be set here. # When set to 2, SimbaDM runs in UTF-8 mode. # When set to 1, SimbaDM runs in UTF-16 mode. # The DriverUnicodeEncoding setting is only used for SimbaDM # Driver: The location where the ODBC driver is installed to.ĭriver=/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib # This key is not necessary and is only to give a description of the data source.ĭescription=Cloudera ODBC Driver for Impala DSN Sample Cloudera Impala DSN=Cloudera ODBC Driver for Impala # Specify any global ODBC configuration here such as ODBC tracing. Install the Cloudera ODBC Connector using its installerĬloudera ODBC Driver for Impala Install Guide.pdf Install the IODBC driver using its installer dmg file runs a GUI-based installer, first for the underlying IODBC driver needed for non-Windows systems, then for the Cloudera ODBC Connector, and finally for the BI tool itself.Ĭloudera-ODBC-Driver-for-Impala-Install-Guide.pdf To illustrate the outline of the setup process, here is a transcript of a session to set up all required drivers and a business intelligence application that uses the ODBC driver, under Mac OS X.

Odbc driver cloudera for tableau mac