Integration Engine Solutions to Connect Anything to Anything

Log out?

eiConsole v.19R1


Tutorial 30 mins

eiConsole Foundation

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 the eiConsole Foundation, 1-13, are modular and are designed to be used in the sequence presented.

Select Data Format of Incoming Interface Data

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.

Enter a name for the new file transformation format.

When the Add New Format dialogue opens, name the file “FlatFileToXML” and choose OK.

Select Pre-Built Data Transformation Module for Non-XML to XML File Conversion.

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.

Data Translation Interface Setup Pilotfish

Choose this option from the Transformation Module drop-down.

Add metadata to file transformation.

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.

This is a unique website which will require a more modern browser to work! Please upgrade today!