Components

Back Next

Hierarchical mappers

A hierarchical mapper maps the schema from a hierarchical schema, industry-standard message, or

intelligent structure model

to another schema. For example, you can map the XML output of a parser data service to a target XSD file.

A hierarchical mapper loads a source schema and a target schema. It uses statements to link source elements from the source schema to target elements in the target schema. To generate a statement, you can drag a source element to a target element, or you can manually create a statement. In the statement, you define how the data in the source maps to the target as well as conditions and filters. You can use a hierarchical mapper in a Data Services transformation to convert inputs to a different hierarchical structure.

For example, you can load a source schema that represents customer invoice data in XML format and map it to a target schema that represents customer orders in XML format. You can use statements to group customer orders by month and to map contact information and order totals.

The following image shows a hierarchical mapper:

The hierarchical mapper designer has sections for the hierarchical mapper and
the mapping statements. The hierarchical mapper includes a source schema and a
target schema. Elements in the source schema are linked to elements in the
target schema using lines to represent the mappings. The mappings correspond to
the statements at the bottom of the designer. Each statement includes statement
properties such as the statement name, statement type, input, and output.

Map source elements to target elements. The mapper displays the source and target schemas. You can drag a source element to a target element to generate a statement. You can also hover over an element to copy its XPath expression or view the element properties.

Edit statement properties or add a new statement.

Add and edit variables.

Search for elements.

Download the schema.

Create a target schema by modifying the source schema.

Import statements from a CSV file.

Use the JSON editor to import statements from a JSON file or to edit statements in JSON format.

Delete statements.

Add statements.

To use a hierarchical mapper, perform the following tasks:

Optionally, create hierarchical schemas or

intelligent structure models

to use as inputs to the hierarchical mapper. For more information, see Hierarchical schemas or Intelligent structure models, respectively.

You don't need to create hierarchical schemas if you use data services from the data services repository to load the source and target schemas. The hierarchical mapper generates a hierarchical schema for the data service automatically.

Create a hierarchical mapper to map the source schema to the target schema.

Create a mapping and select the hierarchical mapper in a Data Services transformation to convert inputs to a different hierarchical structure. For more information about creating a mapping, see

Mappings

. For more information about the Data Services transformation, see

Transformations

Statements

XPath expression editor

JSON editor

Data preview

Creating a hierarchical mapper

Download Guide

Watch

Comments

Cloud Data Integration Homepage