Components

Back Next

Mapping a schema for an industry-standard message

To map a schema for an industry-standard message and convert the message to a different hierarchical structure, download the data service from the data services repository and upload the schema as a hierarchical schema in

Data Integration

. Then, you can use the hierarchical schema in a hierarchical mapper and use the hierarchical mapper in a mapping.

In Administrator, download and unzip the data service.

Open the

Data Services Repository

page.

Select the row that contains the data service, click the

Download

icon, and then save the ZIP file to your local machine.

Unzip the file to a folder with a unique name.

Data Integration

, create a hierarchical schema based on the data service that you downloaded.

Click

New

Components

Hierarchical Schema

On the

New Hierarchical Schema

page, specify a name and location for the hierarchical schema, or use the default values.

Click

Upload

In the

Upload Schema/Sample File

dialog box, click

Choose File

to select the XSD file that contains the schema for the data service, and then click

to upload it.

To save the hierarchical schema, click

Save

Create a hierarchical mapper using the hierarchical schema as the source schema.

Click

New

Components

Hierarchical Mapper

In the

Hierarchical Mapper

designer, configure the general properties and select the hierarchical schema that you created as the source schema. Then, map it to a target hierarchical schema.

For more information about creating a hierarchical mapper, see Creating a hierarchical mapper.

To use the hierarchical mapper, create and run the following mappings, in order:

A mapping that uses the Data Services transformation to invoke a parser data service that parses the incoming industry-standard message and generates an XML file.

A mapping that uses the Data Services transformation to run the hierarchical mapper on the generated XML file and output the XML file defined as the target schema in the hierarchical mapper.

Hierarchical mappers

Download Guide

Watch

Comments

Cloud Data Integration Homepage