EDI Translator

EDI translation with Altova MapForce

MapForce EDI Translation:

  • EDI to XML
  • EDI to databases
  • EDI to text/flat files
  • EDI to EDI
  • EDI to Excel
  • EDI to Web services

Download Trial

Visual EDI Translation

EDI formats are standards for electronic data exchange and are specifically suited for exchanging information between disparate systems. Mapping and translating these transactions to other usable document types for transfer, storage, and management purposes is a very common business requirement. Altova MapForce® 2017 acts as a visual EDI translator, enabling you to maintain the integrity of your EDI data by visually translating it to a wide variety of other usable file formats, including XML, databases, flat files, other EDI standards, Excel, and Web services.

MapForce provides strong support for translating the UN/EDIFACT, ANSI X12, Health Level 7 (HL7), SAP IDoc, IATA PADIS, and TRADACOMS EDI standards, and its intuitive visual mapping interface facilitates translation to a multitude of other formats, allowing this valuable data to be interpreted and consumed by distributed systems. MapForce’s powerful data integration and translation capabilities extend beyond simple EDI mapping operations, enabling you to generate program code in Java, C++, or C# for application integration and recurrent EDI translations.

MapForce also supports mapping multiple sources to multiple targets so that you can combine disparate data formats in your transformations.

Translating EDI to Databases

Translating EDI to database formats is essential for storing and accessing your transaction information. While an increasing number of databases support storing EDI messages in their native formats, it is necessary to translate this data into a valid database structure in order for it to be available for search and retrieval.

Supported Databases:

  • Firebird 2.5
  • IBM DB2 for iSeries® v6.1, 7.1
  • IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
  • Informix® 11.70
  • Microsoft Access™ 2003, 2007, 2010, 2013
  • Microsoft® Azure SQL
  • Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
  • MySQL® 5, 5.1, 5.5, 5.6
  • Oracle® 9i, 10g, 11g, 12c
  • PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
  • Progress OpenEdge 11.6
  • SQLite 3.x
  • Sybase® ASE 15

Translating EDI to XML

XML continues to be one of the most versatile and widely used document formats in businesses across the globe. Its unique ability to be repurposed for any conceivable output format or delivery mechanism makes it an ideal file format for a wide variety of uses.

Using either a proprietary XML Schema or DTD or an XML Schema generated by MapForce from an XML sample file, MapForce enables you to easily translate EDI messages to valid XML structures.

Selection of an EDI message for translation with Altova MapForce