PowerExchange for MapR-DB User Guide

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5

Back Next

Creating an HBase Data Object for MapR-DB

Create an HBase data object to specify the MapR-DB table that you want to access to read or write data.

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 an HBase connection from which you want to import the MapR-DB table.

From the

Available OS Profiles

list, select an operating system profile. You can use the

Available OS Profiles

to increase security and to isolate the design-time user environment when you import and preview metadata from a Hadoop cluster.

The Developer tool displays the

Available OS Profiles

list only if the Metadata Access Service is enabled to use operating system profiles. The Metadata Access Service imports the metadata with the default operating system profile assigned to the user. You can change the operating system profile from the list of available operating system profiles.

To add a MapR-DB table to the data object, click

Browse

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 sources to the data object

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 MapR-DB table that you want to add to the data object and click

You can add one MapR-DB 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 MapR-DB table that 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 appear 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 MapR-DB table.

Specify the datatype, 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. The 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 Objects in the project or folder in the

Object Explorer

view.

HBase Data Objects for MapR-DB

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal