Overview

Enterprise integration may require complex transformations of data. Some interfaces require transforming data from an RDBMS table format (rows and columns) into an XML hierarchical structure and back. Some of the transformations require conversion of hierarchical data into radically different hierarchies such as inversions of parent and child elements, aggregations, and possibly cross-path mappings.

To accomplish these transformations, the principal behavior of Transformer must be understood and alternative methods (for example, multiple transformations and XSLT) explored. This appendix considers a variety of scenarios that may occur and captures the default behavior of Transformer when performing the transformation.

Opening Sample Transform Projects

iWay Transformer is packaged with many sample Transform projects, which you can use as reference when creating your own Transform projects.

An overview of the sample projects, including a list of the format types and techniques that are used in the projecs, is provided in the readme.txt file to help you get started. This file is located in the following directory:

<iWaySMHome>\tools\transformer\samples

where:

<iWaySMHome>: Is the directory where iWay Service Manager was installed.

To open a sample Transform project, follow the instructions in Opening Transform Projects and browse to the following directory:

<iWaySMHome>\tools\transformer\samples\transform_projects

where:

<iWaySMHome>: Is the directory where iWay Service Manager was installed.

For your convenience, the sample Transform projects are organized into groups (subfolders) and named according to the format type that is being used by the project. These subfolders contain the project workspace folders, which contain the .GXP project files and any supporting files that are required by the project (for example, input files and dictionary files). These workspace folders are named according to the type of sample transformation that is demonstrated by the project. The following list provides the complete folder structure of the sample Transform projects that are available:

csv
- CSV_to_XML
edi_hipaa
- EDI_HIPAA_to_XML
edi_x12
- EDI_X12_to_XML
- FWF_to_EDI_X12
edifact
- EDIFACT_APERAK_to_XML
fwf
- FWF_to_EDI_X12
- FWF_to_XML
html
- Pictures_Result2Html
- XML_to_HTML_Table
idoc
- IDOC_to_IDOC
- IDOC_to_XML
swift
- SWIFT_to_XML
xml
- CSV_to_XML
- EDI_HIPAA_to_XML
- EDI_X12_to_XML
- EDIFACT_APERAK_to_XML
- FWF_to_XML
- IDOC_to_XML
- SWIFT_to_XML
- XML_to_HTML_Table
- XML_to_XML

Each project workspace folder contains a readme.txt file that explains the goal and behavior of the Transform project or projects, contained in this workspace. It is strongly recommended to review this information before using the project.