Establishing a Connection
Connecting with the Apache HBase Connection Manager
Adding a new Apache HBase connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the Apache HBase Connection Manager from the Add SSIS Connection Manager window.
Alternatively, you can create a new connection directly using the Apache HBase Source or the Apache HBase Destination. You can set the connection properties in the Apache HBase Connection Manager window.
Connecting to Apache HBase
The CData SSIS Components 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 SSIS Components 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.