|
|
Data Transformation
|
|
OrderWare's powerful data transformation capabilities can import data from,
transform and export to a wide range of data formats. The system stores the data
definitions in it's configuration database to provide for quick re-use. The source and target
are graphically presented to allow for drag and drop mappings using the visual transformation
editor. The system also comes with a smart 'auto map' feature to take the tedious effort out
of mapping similarly named fields.
Complex mappings can use the built-in scripting and calculator for transformations,
manipulations and data cleansing. Template functions allow complex transformations to be handled,
such as combining fields, adding text to fields, key generation, reference to lookup tables and
converting product codes, dates, account numbers or characters.
|
|
|