Components > Hierarchical mappers
  

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.
Note: You can use an intelligent structure model only as a source schema.
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.
  1. 1Map 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.
  2. 2Edit statement properties or add a new statement.
  3. 3Add and edit variables.
  4. 4Search for elements.
  5. 5Download the schema.
  6. 6Create a simplified target schema using the source schema.
  7. 7Import statements from a CSV file.
  8. 8Use the JSON editor to import statements from a JSON file or to edit statements in JSON format.
To use a hierarchical mapper, perform the following tasks:
  1. 1Optionally, 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.
    2. 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.
  2. 2Create a hierarchical mapper to map the source schema to the target schema.
  3. 3Create 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.