Create a hierarchical mapper to map the schema from a hierarchical schema, industry-standard message, or intelligent structure model to another schema.
1Select New > Components > Hierarchical Mapper and then select Create.
2In 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. |
3Select Next.
4On the Hierarchical Mapper page, select Select a source schema to add 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. If you select Use native format for industry-standard messages, you can input an industry-standard message in its native format. When this option isn't selected, you need to provide industry-standard messages in XML format.
5To add a target schema, use one of the following methods:
- - Select Select a target schema to add 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. If you select Output in Native format, you can output an industry-standard message in its native format. When this option isn't selected, industry-standard messages output in XML format.
For an intelligent structure model, select one of the following output formats: relational, JSON, XML, or JSON Lines.
- - Select Modify source schema. Then check or uncheck the source elements to include or exclude in the target schema.
6Optionally, add variables to the source and target schemas.
- aSelect the Variables icon.
- bIn the Variables dialog box, select Add to add a variable and configure the variable properties.
7To add mapping statements, use one of the following options:
- - In the Mappings area, drag a source element to a target element.
The hierarchical mapper identifies the statement type, input, and output, generates a statement, and validates it.
- - In the Mappings area, select Automap to automatically map source elements to target elements with matching names.
Automapped elements use a dashed link. After you save the hierarchical mapper, automapped elements use a solid link.
- - In the Mapping Statements area, select Add > Add new statement to add a statement and configure the statement properties.
- - In the Mapping Statements area, select Upload CSV and then select a CSV file to upload.
- - In the Mapping Statements area, select Open JSON editor and then select a JSON file to upload.
8Optionally, delete a statement using one of the following options:
- - In the Mappings area, select the link between the source and target schema and press Delete.
- - In the Mapping Statements area, select the statement and select Delete.
9Select Next.
10On the Preview page, you can optionally preview the hierarchical mapper.
- aSelect Choose File to select an input file.
- bSelect 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.
- cSelect Run and verify the preview result.
11Select Save to save the hierarchical mapper.