Altova MapForce

Altova MapForce® 2017 is an award-winning any-to-any graphical data mapping, conversion, and integration tool that maps data between any combination of XML, database, EDI, XBRL, flat file, Excel, JSON, and/or Web service, then transforms data instantly or autogenerates royalty-free data integration code for the execution of recurrent conversions.

MapForce Highlights

·         Mapping design

·         Data integration

·         Data processing functions

·         Interactive data mapping debugger

·         XML mapping

·         JSON data mapping

·         Database mapping

·         Enterprise ETL

·         Text and flat file and Excel mapping

·         EDI mapping

·         Data mapping SOAP and REST Web services

·         XBRL Data Mapping

·         Any-to-many or chained data mappings

·         Data conversion code generation

·         Data mapping documentation

·         MapForce Server

Visual Data Mapping

MapForce Visual Data Mapping:

Drag and drop connection of source and target

Pop-up display of node datatypes

Automatically connect child elements where appropriate

Message window displays validation warnings or errors

Project helper window organizes large projects with multiple files

Find function to locate nodes in large data mappings

Optionally integrate MapForce in Visual Studio or Eclipse

Visual data mapping interface in Altova MapForce

Debug Data Mappings Interactively

Data Mapping Debugger:

MapForce includes a revolutionary interactive debugger to assist with data mapping design. The debugger allows users to single step through a mapping and see the data actually flow from the sources to the target nodes step by step along the way. The MapForce debugger is supported with menu commands, a special toolbar, and helper windows that are opened automatically while the debugger is running, so users can trace the intermediate processing operations and examine data values during mapping execution.

Setting Debug Breakpoints

The MapForce debugger supports breakpoint functionality that will be familiar to developers experienced at debugging source code. Breakpoints can be placed on any input or output node, to pause mapping execution at that point, and conditional breakpoints are supported.

Mapping Output Preview

MapForce Output Window:

Depending on the data format of the output component, the Output preview window displays:

XML data

XSLT 1.0/2.0 stylesheets

SQL statements to update or insert databases

Flat files

EDI files

Excel spreadsheets

XBRL documents

Powerful, Flexible, Cost-Effective Data Integration

MapForce Data Conversion:

Map data to and from all popular databases

Map XML, flat files, EDI, Excel, XBRL, & Web services

Data processing functions convert data on the fly

Process data from/into multiple files

Insert data from REST Services as XML or JSON

Direct file input and output (data streaming)

Data mapping automation through scripting or royalty-free code generation.