Tableau Desktop connect to Cloudera Hadoop using Kerberos

Reference:

http://website4everything.blogspot.com/2015/04/connecting-tableau-to-hive-server-2.html

The basic steps to connect Tableau to Cloudera Hive or Impala with Kerberos authentication involves the following steps:

  1. Download and Install the MIT Kerberos Client for Window
  2. Set the C:\ProgramData\MIT\Kerberos5\krb5.ini with  the Kerberos realm and server details
  3. (Optional) KRB5CCNAME system environment variable may need to be set at times to a temporary value: FILE:C:\temp\kerberos\krb5cache
  4. Start the MIT Client and get a new ticket using the userid/password provided by the Kerberos admin.
  5. Start the Tableau Desktop and select Cloudera Hadoop data source and enter the HiveServer2 or Impala connection values including Server address, Kerberos realm, kerberos fqdn etc.
  6. You may need to download and install the Impala or Hive ODBC driver from the Cloudera.com website.
  7. After that the connect to Hive or Impala using Kerberos will work.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.