Xenos OnLine for Data Transformation 

Xenos OnLine provides data mapping, translation, routing control and secure reliable transport between trading partners and/or back-office applications and databases. It supports corporate Electronic Data Interchange (EDI), Extract, Transform and Load (ETL) and Enterprise Application Integration (EAI) initiatives as a service.

Support Exists for virtually any format through XML-based dictionaries,
including:

• COBOL Copybooks (text and binary data)
• CSV
• Databases, using JDBC and ODBC technology
• EDI HIPAA
• EDI X12
• EDIFACT
• Flat Text
• HL7
• Java Objects, via JAXB, Castor, or XBean
• PDF Forms
• SWIFT
• SAP IDOC
• SQL
• XBRL
• XML

Supported databases include; IBM DB2 , Microsoft SQL Server , mySQL ,Oracle , PostgreSQL

Common use-cases:

• Data Field Mapping – Flat File to XML
• Structured Data Mapping, Routing and Transport between Trading Partners (EDI)
• PDF Forms Population

Typical files include:

• Financial Invoices
• Manufacturing Inventory Orders and Responses
• Insurance Forms
• Logistics Waybills, Container Plans and Customs Documents
• Healthcare messages – HL7
• Pharmacy Prescriptions