Components

Back Next

Hierarchical mappers

A hierarchical mapper maps a hierarchical schema, such as the schema for an industry-standard message, to another hierarchical 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 to convert the data from hierarchical input to hierarchical output as well as define conditions and filters.

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.

You can use a hierarchical mapper in a Data Services transformation to process hierarchical input and convert it to hierarchical output that uses a different hierarchical structure, such as converting an XML document into a different XML document or converting a JSON document into a different JSON document.

The following image shows a hierarchical mapper:

The hierarchical mapper designer has two sections: the hierarchical mapper and the 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.

Hierarchical mapper. 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.

Statements. Edit statement properties or add a new statement.

To use a hierarchical mapper, perform the following tasks:

Optionally, create hierarchical schemas based on the hierarchical documents, such as XML or JSON documents. For more information, see Hierarchical schemas.

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 process the hierarchical input and convert it to hierarchical output. For more information about creating a mapping, see

Mappings

. For more information about the Data Services transformation, see

Transformations

Statements

XPath expression editor

Creating a hierarchical mapper

Download Guide

Watch

Comments

Cloud Data Integration Homepage

Free Trial

Communities