Help Manual - HBase Connection Manager

Documentation on SSIS Hbase Connection Manager component

Using the HBase Connection Manager

The HBase Connection Manager is an SSIS connection manager component that can be used to establish connections with HBase.

To add an HBase connection to your SSIS package, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection..." from the context menu. You will be prompted the "Add SSIS Connection Manager" window. Select the "HBase" item to add the new HBase connection manager.

New Connection

Add HBase Connection Manager.png

The HBase Connection Manager contains the following two pages to connect to your HBase server:

  • General
  • Advanced Settings

General Page

The General page of the HBase Connection Manager allows you to specify the server addresses and credentials for authentication.

Authentication
Server URL

The Host represents the Server address containing your HBase server.

Authentication Mode

This option allows you to select the authentication mode to connect to HBase. Available options are:

  • Basic
  • Kerberos
User

The User represents the user for your HBase Server instance.

Password

The Password for the HBase Server instance.

Domain

The domain or host to authenticate against.

Advanced Settings Page

The Advanced Settings page contains all possible settings for an HBase connection. Clicking on a specific setting will display a description for the selected property at the bottom of the Advanced Settings page.

HBase Connection Manager - Advanced Settings.png

Proxy Server Settings
Proxy Mode

The Proxy Mode option allows you to specify how you want to configure the proxy server setting. There are three options available:

  • No Proxy
  • Auto-detect (Use system-configured proxy)
  • Manual
Proxy Server

Using the Proxy Server option allows you to specify the name of the proxy server for the connection.

Port

The Port option allows you to specify the port number of the proxy server for the connection.

Username (Proxy Server Authentication)

The Username option (under Proxy Server Authentication) allows you to specify the proxy user account.

Password (Proxy Server Authentication)

The Password option (under Proxy Server Authentication) allows you to specify the proxy user's password.

Note: The Proxy Password is not included in the connection manager's ConnectionString property by default. This is by design for security reasons. However, you can include it in your ConnectionString if you want to parameterize your connection manager. The format would be ProxyPassword=myProxyPassword; (make sure you have a semicolon as the last character). It can be anywhere in the ConnectionString.

Misc Settings
Timeout (secs)

The number of seconds requests should wait before timing out.

API Throttling Rate (requests/second)

The API Throttling Rate will limit the number of requests that can be sent per unit of time. This is useful when accessing APIs with request limits. The Requests drop-down will allow you to specify whether the API Throttling Rate should be per second, minute, or hour.

Retry on Intermittent Errors

The Retry on Intermittent Errors option determines if requests will be retried when there is an error. If this option is checked requests will be retried up to 3 times.

Test Connection

The Test Connection button will open a dialog that allows you to test the connection manager.