Components

Back Next

Creating a hierarchical mapper

Create a hierarchical mapper to map the schema from a hierarchical schema, industry-standard message, or

intelligent structure model

to another schema.

Click

New

Components

Hierarchical Mapper

and then click

Create

In the

Hierarchical Mapper

designer, configure the properties on the

General

page.

The following table describes the general properties:

Property	Description
Name	Name of the hierarchical mapper.
Description	Description of the hierarchical mapper.
Location	Project folder where you want to save the hierarchical mapper.

Click

On the

Hierarchical Mapper

page, click

Select a source schema

. Use one of the following options based on the source type that you select:

If you select

Hierarchical Schema

, click

Browse

to browse for the source schema that you want to load into the designer, and then click

Select

If you select

Data Services Repository

, click

Browse

to browse for the data service and then click

Select

. Then, select the root that you want to load into the designer.

If you select

Input in Native format

, you can provide an industry-standard message in its native format as input to the hierarchical mapper. When this option isn't selected, you need to provide industry-standard messages in XML format.

If you select

Intelligent Structure Discovery

, click

Browse

to browse for an

intelligent structure model

and then click

Select

To add a target schema, use one of the following methods:

Click

Select a target schema

to select a hierarchical schema, data service from the data services repository, or

intelligent structure model

For a data service, select the root that you want to load into the designer.

For an

intelligent structure model

, select one of the following output formats: relational, JSON, XML, or JSON Lines.

Click

Modify source schema

. Then check or uncheck the source elements to include or exclude in the target schema.

Optionally, add variables to the source and target schemas.

Click the

Variables

icon.

In the

Variables

dialog box, click

Add

to add a variable and configure the variable properties.

To add mapping statements, use one of the following options:

Drag a source element to a target element to automatically generate a statement.

Click

Add

Add new statement

to add a statement and configure the statement properties.

Click

Upload CSV

and then select a CSV file to upload.

Click

Open JSON editor

and then select a JSON file to upload.

Click

On the

Preview

page, you can optionally preview the hierarchical mapper.

Click

Choose File

to select an input file.

Select a runtime environment. The runtime environment can be a Secure Agent group, the Hosted Agent, or the Cloud Server. If you run the hierarchical mapper on the Cloud Server, the hierarchical mapper runs natively and you don't need to configure a runtime environment in Administrator.

Click

Run

and verify the preview result.

Click

Save

to save the hierarchical mapper.

Hierarchical mappers

Download Guide

Watch

Comments

Cloud Data Integration Homepage

Free Trial