Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (2)
New Contributor

Note: The ODBC connector is supported for Windows version of Tableau only.

  1. Download Hortonworks driver from the link below
    https://hortonworks.com/downloads/#addons
    1. Chose Hortonworks ODBC Driver for Apache Hive (v2.1.10) from Hortonworks Data Platform Add-Ons section (Tested Windows 64 bit)
    2. Download and run/install the driver.
  2. Create a Data Source Name in ODBC Administrator:
    1. Open Data Sources (ODBC) from Control Panel/Administrative Tools.
    2. Highlight "Sample Hortonworks Hive DSN" from System DSN tab and click "Configure" button
    3. Enter the following info
      1. Host(s): <HOST_NAME>
      2. Port: <PORT>
      3. Database: Default
      4. Mechanism: select "User name password" from dropdown
      5. User name: <USER_NAME>
      6. Password: <PASSWORD>
      7. Delegation UID:
      8. Thrift Transport: select "HTTP" from dropdown
    4. Click on HTTP Options
      1. HTTP Path: gateway/default/hive
    5. Click on SSL Options
      1. Check "Enable SSL" checkbox
      2. Check "Allow Common name host name mismatch" checkbox - This option specifies whether a CA-issued SSL certificate name must match the host name of the Hive server
      3. Trusted Certificates: The full path of the .pem file containing trusted CA certificates for verifying the server when using SSL.
    6. Click "Test" on the bottom of the dialog box to test
    7. Once successful, click "OK" button

From Tableau

  1. On the Connect screen
    1. Click "More ..." from "To a Server" section
    2. Choose "Other Databases (ODBC)"
      1. DSN: Choose "Sample Hortonworks Hive DSN" from dropdown
      2. Click "Connect" button. (Once connected, "Connection Attributes" section will be activated/enabled)
    3. On the Connection Attributes Section
      1. Server: <HOST_NAME>
      2. Port: <PORT>
      3. Database: Default
      4. Username: <USER_NAME>
      5. Password: <PASSWORD>
      6. Click on "Sign In"
10,593 Views
Comments
Contributor

@Avinash Makey ...Can you please guide on how to connect to Tableau in environments without SSL connection.

New Contributor

Did you try without checking "Enable SSL" option?

Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎08-31-2017 10:31 PM
Updated by:
 
Contributors
Top Kudoed Authors