Support Questions

Find answers, ask questions, and share your expertise

What do I enter into this Tableau data connector to connect to the Hadoop Sandbox,What do I enter into the Tableau data connector to successfully connect to a Default Sandbox Installation

avatar
New Contributor

I have successfully installed Sandbox and loaded and queried data via Ambari and Hive 2. I followed the tutorial, so no changes were made to the installation. Here is a screen shot of the Hosts screen and the IP address info at the top of Ambari:

ambari-interface-to-hadoop.jpg

I downloaded and installed these two database drivers, because of uncertainty. Here's a screen shot of the driver files:

drivers-downloaded-and-installed.jpg

Now, in Tableau, I chose the Hortonworks Hadoop Hive data connector, and this is where the confusion set in. I simply do not know what I should enter after trying different details based on the information I knew about Sandbox.

tableau-data-connector.jpg

Also, I looked at the MapR Hadoop Hive data connector in Tableau, and it looks for the same basic information, but simply unsure as to what I should enter.

mapr-hadoop-hive.jpg

PLEASE HELP AS SOON AS POSSIBLE! Thank you so much! Which server, port, etc should I enter based on a default installation of Sandbox?

,

1 ACCEPTED SOLUTION

avatar
Guru

Hi @Terrie Pugh

I just connected Tableau installed on my Mac to the latest HDP 2.6 Sandbox's Hive. Here are the steps I took with some screenshots in case they help you:

1) Install the Hortonworks ODBC Connector for the OS you are using: https://hortonworks.com/downloads/#addons

2) In Tableau, Choose the Hortonworks Hadoop Hive Connection and configure as per the screenshot

3) maria_dev should be fine if that was the user your loaded your data with

15474-screen-shot-2017-05-16-at-24306-pm.png

Once you are in, you can test the connection within Tableau by doing a schema search for "*" to see if it pulls back the databases as shown:

15475-screen-shot-2017-05-16-at-24644-pm.png

As always, if you find this post useful, don't forget to accept the answer.

View solution in original post

9 REPLIES 9

avatar
New Contributor

I found two youtube videos that added clarity to my initial question, however, I am still uncertain of what I would specify as the server name based on the tutorial from Hortonworks and should I use the maria_dev username and password that I used to log into Ambari to create/load the tables?

Thanks,

Terrie

avatar
Guru

Hi @Terrie Pugh

I just connected Tableau installed on my Mac to the latest HDP 2.6 Sandbox's Hive. Here are the steps I took with some screenshots in case they help you:

1) Install the Hortonworks ODBC Connector for the OS you are using: https://hortonworks.com/downloads/#addons

2) In Tableau, Choose the Hortonworks Hadoop Hive Connection and configure as per the screenshot

3) maria_dev should be fine if that was the user your loaded your data with

15474-screen-shot-2017-05-16-at-24306-pm.png

Once you are in, you can test the connection within Tableau by doing a schema search for "*" to see if it pulls back the databases as shown:

15475-screen-shot-2017-05-16-at-24644-pm.png

As always, if you find this post useful, don't forget to accept the answer.

avatar
Explorer
@Sonu Sahi

is Tableau working as a live data stream dashboard? I mean if the chars are reloading in real time?

avatar
Guru

I haven't seen it work that, I think in the background it is generating SQL queries and sending them over the JDBC driver.

avatar
New Contributor

@Sonu Sahi I want to THANK YOU! It worked! Greatly appreciated.

avatar
Contributor

@Sonu Sahi

Hi, I am having the same issue with cloudbreak in azure. Would you please help me out how to configure the DSN setup. I am confused with the host name. What should i provide here? I have 2 node cluster- master and worker. Should i provide the FQDN here? would you please provide the step-by-step configuration with all the values those need to be configured? Thank you.

avatar
Contributor

Sonu Sahi

you have to provide the Hiveserver2 server name and the port (default is 10000)

avatar
Contributor

@ Sankaru Thumuluru @Terrie Pugh

Hi, i am using cloudbreak in AZURE. Now trying to connect Tableau with hive table. Would you please help me out? I am getting confused in the ODBC driver configuration. What should i provide in --

1. host name: is it my HDP master node's DNS?

2. Port: 10000

3. Database: default

4. Authentication: which mechanism should i choose?

5.User name: is it my Ambari user name and password?

6. Thrift Transport: which one need to be selected?

Thank you.

avatar
Guru

@Marshal Tito

The hostname should be the node you have installed the hiveserver2 on. The username/pw should be a hadoop user you have created (or if using the Sandbox, one of the pre-created users such as maria_dev). Within Azure, make sure the port that you are connecting over is open (10000) from your tableau system to your hadoop cluster. Usually on public clouds, it is the closed firewall ports that is the issue.