EDI Mapping

Creating an EDI Mapping

The MapForce data mapping tool is a visual EDI translator that lets you convert EDI to other prevalent data formats, as well as to other EDI formats. Common EDI translation includes:

Full support for a wide range of EDI formats in MapForce allows you to use any of the hundreds of messages and transaction sets covered by these standards in your mapping design. You can even map from EDI to EDI, to, for example, convert EDIFACT files to an X12 format for your global business partners. You can also take advantage of MapForce's XML support to update your legacy HL7 v2.x messages to version 3.

MapForce supports EDI mapping for:

Because users often need to customize the EDIFACT, X12, HL7, HIPAA X12, PADIS, TRADACOMS, ODETTE, VDA, and FORTRAS messages according to specific implementation requirements, MapForce includes a user-friendly EDI configuration file format that allows you to add new transactions or modify and enhance existing messages quickly and easily.

Once you've specified the data sources for your EDI data mapping, MapForce inserts them in your project as graphical components. Drag and drop to map data fields, insert data processing functions, and even build your own with the visual function builder to transform data as required.

MapForce supports any-to-many data mapping as well as chained mappings.

ETL for EDI

Rich coverage for the most popular EDI message formats coupled with support for all major relational and NoSQL databases makes MapForce particularly well suited for creating EDI ETL pipelines.

The graphical MapForce interface makes it easy to visualize the structure of EDI messages, breaking them down into segments, elements, and subelements. Then, its built-in library of data processing functions and visual function builder can be used to define processing rules to extract message data and transform it before mapping and loading it to the target system or database.

Then, MapForce makes it easy to configure connections to target databases, generate SQL scripts to insert transformed data, and set actions like insert, update, or delete to control how data is written, all with comprehensive options for error handling and logging.

With robust validation and error handling, MapForce ensures accurate and compliant data transformation, making it an efficient tool for managing EDI ETL workflows. For automating ETL, MapForce Server provices unmatched scalability and affordability.