Transformation Maps define how to transform or map data between disparate formats, including:
- XML documents
- EDI documents
- Microsoft Excel 2007 (XLSX) files
- Text files (for example, comma-separated values)
- Web service functions
- A wide range of databases, including IBM DB2 Universal Database for IBM i
The usual procedure for creating and using a Transformation Map is as follows:
1. Create a Transformation Map definition in LANSA Composer as described in Create or Copy a Transformation Map in Work with Transformation Maps.
2. Edit the Transformation Map in the mapping tool to perform the mapping required for your application as described in Edit Transformation Map.
3. Prepare the Transformation Map for use in a processing sequence as described in Prepare Transformation Map.
You can then use the Transformation Map in processing sequences.