User Guide > Connections > HBase Connection
  

HBase Connection

Create an HBase connection to write data to an HBase table.
You can create and manage an HBase connection in the Developer tool or through infacmd.

General Properties

The following table describes the general connection properties for the HBase connection:
Property
Description
Name
The name of the connection. The name is not case sensitive and must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
ID
The string that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
Description
The description of the connection. Enter a string that you can use to identify the connection. The description cannot exceed 4,000 characters.
Location
The domain where you want to create the connection. Select the domain name.
Type
The connection type. Select on the folloiwng options:
  • - HBase
  • - MapR-DB

Connection Properties

The following table describes the connection properties for the HBase connection:
Property
Description
Database Type
The connection type. Select on the following options:
  • - HBase
  • - MapR-DB
Cluster Configuration
The name of the cluster configuration associated with the Hadoop environment.
For more information about cluster configuration, see the Informatica Big Data Management Administrator Guide.
MapR-DB Database Path
Database path that contains the MapR-DB table that you want to connect to. Enter a valid MapR cluster path.
When you create an HBase data object for MapR-DB, you can browse only tables that exist in the MapR-DB path that you specify in the Database Path field. You cannot access tables that are available in sub-directories in the specified path.
For example, if you specify the path as /user/customers/, you can access the tables in the customers directory. However, if the customers directory contains a sub-directory named regions, you cannot access the tables in the following directory: /user/customers/regions

Creating an HBASE Connection using Informatica Command Line Program

You can use the infacmd command line program to create an HBASE connection. Access the command from the <Informatica installation directory>/clients/DeveloperClient/infacmd directory.
On UNIX, run the following command:
sh infacmd.sh createConnection
On Windows, run the following command:
infacmd.bat createConnection
Enter connection options in the following format:
... -o option_name='value' option_name='value' ...
For example, On UNIX you can run the following command to create an HBASE connection:
sh infacmd.sh createConnection -dn <domain name> -un <domain user> -pd <domain password> -cn <connection name> -cid <connection id> -ct HBase -o DatabaseType=HBase CLUSTERCONFIGID=ConfId
For more information about the CreateConnection command and the HBASE connection options, see the Informatica Command Reference Guide.