KNOWLEDGE BASE

Unable to Browse to SSL Certificate in Tableau Prep


Published: 28 Nov 2018
Last Modified Date: 11 Jun 2019

Issue

When connecting Tableau Prep to an SSL-enabled Hive server, the following error may occur:
[Hortonworks][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect.

Additionally, there is no option to browse to an SSL certificate file from the data connection dialog in Tableau Prep. 
 
User-added image

Environment

  • Tableau Prep
  • Hortonworks Hadoop Hive
  • Custom SSL Certificate

Resolution

The following options need to be performed with the help of your IT team.

Option 1

Apply the attached .tdc file on the Tableau Prep computer:

  1. Open the .tdc file in a text editor, such as Notepad, replace {filepath} with the file path for the trusted certificate file, and then save the changes.
  2. Copy the edited .tdc file to Documents\My Tableau Prep Repository\Datasources
  3. Restart Tableau Prep to apply the change.
Note: If you’re not sure where the Tableau Prep repository is located, open Tableau Prep and select File > Repository Location.


Option 2

Install the required root certificate on the computer where Tableau Prep is installed:

Windows:
  1. Verify that the SSL Certificate Chain File is configured in Tableau Server.

  2. Copy the certificate file (.crt) to the computer running Tableau Prep.

  3. Double-click the certificate file, click Install Certificate, and then click Next.

  4. Select Place all certificates in the following store.

    Browse to select Trusted Root Certification Authorities and then click OK > Next > Finish.

  5. Wait for the certificate to finish importing, then click OK.

 You can verify that there are no duplicate certificates for Tableau Server CA in the Windows certificate store with the steps below:

  1. From the Start menu, type certmgr, then open Manage computer certificates.

  2. Navigate to Trusted Root Certification Authorities> Certificates.

  3. If there are duplicate certificates for Tableau Server, open each one and check the Serial number on the Detailstab.

  4. Delete all the Tableau Server certificates with serial numbers that don't match the correct Tableau Server certificate.

  5. Follow steps 3 and 4 for any duplicate Tableau Server certificates in Intermediate Certification Authorities > Certificates.

Mac OS X: 
  1. Verify that the SSL Certificate Chain File is configured in Tableau Server.

  2. Add the root certificate to your computer's keychain to ensure that the certificate authority is trusted by your computer.

  3. Double click the certificate file (with ".cer" extension)
  4. Choose "System" from the keychain option. Then press "OK"
  5. In the following pop-up window, click the "Always Trust" button.
  6. Then you will notice that the certificate is added to the system entry.

Cause

Currently there is no option to browse to an SSL certificate from the data connection dialog in Tableau Prep. 
Did this article resolve the issue?