User Guide

10.2.1
- 10.5.7
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 Service Pack 1
- 10.2.2

Back Next

Creating an HBase Data Object

Create an HBase data object to specify an HBase resource.

Select a project or folder in the Object Explorer view.

Click

File

New

Data Object

Select

HBase Data Object

and click

The

New HBase Data Object

dialog box appears.

Enter a name for the data object.

Click

Browse

next to the

Location

option and select the target project or folder.

Click

Browse

next to the

Connection

option and select a connection from which you want to import the HBase resource.

To add a resource to the data object, click

Add

next to the

Resource

option.

If a default Metadata Access Service is not set, a message appears to configure the Metadata Access Service. Click

and set one Metadata Access Service as default. After you set a default Metadata Access Service, the

Add Resource

dialog box appears. If the Metadata Access Service does not exist, contact the Informatica administrator to create a new Metadata Access Service.

Navigate or search for the resources to add to the data object and click

You can add one HBase table to the data object.

Click

. The

Column Families

dialog box appears.

Select a column family and specify the columns in it. Choose to add columns or get all columns.

To manually add, or search and add columns to the column family, select the

Add Columns

option.

To read from or write all columns in the column family to a single binary column, select the

Get all columns

option.

Add the columns in the column family. Choose to add columns or search the column names in the column family and add the columns.

To specify the columns from the column family when you know the column name and data type, select the column family to which you want to add the columns and click

Add

. Configure the add properties.

To search columns in the column family and add them, click

Search and Add

. The

Search and Add

dialog box appears.

Specify the following details in the

Search and Add

dialog box:

Specify the maximum rows in the HBase tables you want to include in the search.

Specify the threshold value of the column occurrence percentage.

Click

The column name and the occurrence percentage of the column in the table appears in the results.

Select the columns that you want to specify for the column family. Configure the add properties.

Click

Next.

The

Create Row

dialog box appears.

Select the

Include Row ID

option to generate a row ID for the HBase table.

Specify the data type, precision, and scale for the row ID and click

Next.

The

Review Columns

dialog box appears. The column family name is the prefix for all the column names in that column family for unique identification. Default data type of the row ID is String.

Review the columns in the column families and click

Finish

The data object appears under Data Object in the project or folder in the Object Explorer view. You can also add resources to a data object after you create it.

Rename Saved Search

Table of Contents

User Guide

User Guide

Creating an HBase Data Object

Creating an HBase Data Object