Establishing a Connection
Configure a Connection Profile
From the CData ribbon, click Get Data and select From Apache HBase to launch the CData Query window. To setup your connection, you will have to click the Select button. Here you can set the connection settings, test the connection, and save the connection profile.
Connecting to Apache HBase
The CData Excel Add-In 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 Excel Add-In for Apache HBase supports authentication over Basic and Negotiate.
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.
Connection PropertiesThe Connection properties describe the various options that can be used to establish a connection.
Managing ConnectionsAfter successfully authenticating to Apache HBase you will be able to customize the data you are importing. To learn more about this, see Managing Connections.