Source Transformation Introduction
You will need to download sample files to do this tutorial. If you have not done so yet, please click this LINK.
Note: the Tutorials in eiConsole Foundation, 1-13, are modular and are designed to be used in the sequence presented.
Click the Source Transform icon in the main route grid.
The Source Transform stage allows you to take data from its proprietary format (the format exported by the Source system) and translate it into the canonical XML model that you will be using for this transaction. For this interface, the input is a Tab-delimited text file that will be converted into an XML standard format. To do this, click the Add Format button.
When the Add New Format dialogue opens, name the file “FlatFileToXML” and choose OK.
Each format has two stages. The first stage is the Transformation Module. This is the stage that will allow you to take data from a non-XML format and convert it into XML. After the data is in an XML format, you will configure the XSLT to logically map the data from this XML format onto the chosen canonical structure. In order to convert the tab-delimited file into XML you will need to use the Delimited and Fixed-Width File transformation module. Choose this option from the Transformation Module drop down.
Also on this stage, you can add Metadata to the Source in this interface so that it is easier to search and sort this interface later on. To add Metadata to the Source, select the Format Info tab.