KNOWLEDGE BASE

Error "Check that the necessary drivers are installed and that the connection properties are valid." Connecting to Cloudera Impala Using SSL


Published: 15 Apr 2015
Last Modified Date: 12 Jun 2017

Issue

When connecting to Cloudera Impala using SSL, the following error might occur:

Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid.

[Cloudera][ThriftExtension] (5) Error occurred while contacting server: No more data to read.. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

Unable to connect to the server "<server address>". Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop 
  • Cloudera Impala
  • SSL

Resolution

Download the attached Tableau Data Customization (.tdc) file and edit it to specify the file path to the trusted certificates, and then add the .tdc file to your My Tableau Repository\Datasources folder.
Note: For the TrustedCerts= value, you do not need the double quotation mark for the file path. For more information on .tdc files, see Customize and Tune ODBC Connections.
Did this article resolve the issue?