Tableau Connector for Apache HBase

Build 21.0.7930

Configuring a Connection

The connector comes with a connection builder which allows you to build and test your connection settings outside of Tableau. It also allows you to create a connection string, which can be used to provide options not listed in the connection dialog in Tableau.

Configuring a Connection Builder

There are two ways to access the connection builder:

  • On Windows, there will be a shortcut called Connection Builder in the start menu, under the CData Apache HBase Tableau Data Connector folder.
  • The connection builder can also be started by going to the driver install directory and running the .jar file in the lib directory.

In the connection builder, you can set values for connection properties and click the Test Connection button to validate that they work. You can also use the Copy to Clipboard button to save the connection string for use with Tableau.

Connecting to Apache HBase

The CData Tableau Connector for Apache HBase connects to Apache HBase via the HBase REST (Stargate) server. Set the Port and Server properties to connect to Apache HBase.

The Server property will typically be the host name or IP address of the server hosting Apache HBase. If there are multiple nodes, you will use the host name or IP address of the machine running the REST (Stargate) server.

Starting the Server

Different Hadoop distributions contain different interfaces and means of starting and stopping the HBase REST server, along with different default port settings.

In most distributions, the HBase REST server can be started in the foreground by running the following command: "hbase rest start -p <port>". Please consult your Hadoop distribution's documentation for further information regarding the HBase REST server.

Authenticating to Apache HBase

The CData Tableau Connector for Apache HBase supports authentication over Basic and Negotiate.

No Authentication

By default, no authentication (or anonymous auth) is used. Set AuthScheme to None to explicitly enforce no authentication.

Authenticating with Basic

Basic authentication may be used by setting AuthScheme to Basic. In addition, set the following:

  • User: The Apache HBase user;
  • Password: The Apache HBase password;

Authenticating with Kerberos

To authenticate with Kerberos, set AuthScheme to NEGOTIATE and set the User and Password. Please see Using Kerberos for details on how to authenticate with Kerberos.

Next Step

See Getting Data for the next step, which includes authenticating to the Apache HBase APIs.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930