Transformation maps define how to transform or map data between disparate formats including XML, EDI, Microsoft Excel 2010 (XSLX), text files, web service functions and database tables.

Typically, most of your structured corporate data is held in database tables, while information is exchanged with external parties in open formats such as XML documents.  Commonly you will have the need to transform data between your internal database table representation and external exchange formats such as XML that you agree with your trading partners.  Examples of transformation requirements include:

• Receiving incoming sales orders in agreed XML format and mapping to the received orders database

• Generating invoices in agreed XML format directly from your accounts receivable database tables

• Transferring information between internal applications (perhaps from different vendors) that are not directly integrated.

Transformation Maps created using LANSA Composer can be directly integrated into your business processes along with transport and other Activities.