New in MapForce 2018

Version 2018 of Altova MapForce became available on October 3, 2017. Learn about all the new features below and update to the latest version.
MapForce® 2018 (October 3, 2017)
Enterprise
Professional
Basic
MapForce® 2018 (October 3, 2017)
NCPDP SCRIPT support
Easily insert or remove columns in Excel mappings
Significant speed improvement in the XSLT engine
Generate code for VS2013, VS2015, and VS2017
Support for Sybase 16, PostgreSQL 9.6, MySQL 5.7
Integration with Eclipse 4.7

NCPDP SCRIPT Support

SCRIPT is an EDI standard for exchanging electronic information in the US healthcare sector developed by the NCPDP (National Council for Prescription Drug Programs). MapForce 2018 supports mapping data between files in SCRIPT format and any other format supported by MapForce, including XML, CSV, Microsoft Excel, databases, and others. The supported NCPDP SCRIPT versions are: 8.1, 10.6, 10.10.
NCPDP SCRIPT can use either the UN/EDIFACT format or an XML format. If the user has the NCPDP XML Schemas, MapForce will support mapping data to or from SCRIPT using the standard XML mapping commands and validation.
The image below shows the list of SCRIPT version 10.10 message types supported by MapForce 2018. To insert any message as either a mapping source or target, simply select from the list.
NCPDP SCRIPT Support in MapForce

Easily Insert or Remove Columns in Excel Mappings

MapForce 2018 includes a new feature to easily add new columns in between any existing columns mapping data to an Excel spreadsheet, without redoing the existing mapping connections. The user can select any cell in the Excel mapping, and add a cell from the context menu.
Selecting this option opens a dialog where the user can specify the range and datatypes of inserted cells:
Insert new columns in an Excel mapping in MapForce
In the example illustrated here, the existing Excel Spreadsheet contained two columns of numeric data with the column headings West and East. The user inserted a new column with the heading North.
Similarly, the Remove Cell menu option deletes the cell from the target Excel spreadsheet, but does not otherwise modify the mapping.
This new feature simplifies modifications and updates to existing mappings when a change is required in the Excel file output, because all existing connections are automatically preserved.

Significant Speed Improvement in XSLT Processing

The lightning-fast XSLT engine in MapForce, powered by RaptorXML, is now significantly faster* when processing these common commands that can be generated internally when XML data mappings are processed:
  • //* [condition]: up to 300 times faster
  • unparse-text-lines: up to 88 times faster
  • regular expressions: up to 100 times faster
*Based on internal Altova tests. Your results may vary.

Generate Code for VS2013, VS2015, and VS2017

MapForce 2018 can now generate program source code from data mappings with project files for Visual Studio 2013, 2015, and 2017, adding to support for earlier versions of Visual Studio.

Enhanced Database Support

MapForce 2018 supports mapping to or from Sybase 16, PostgreSQL 9.6, MySQL 5.7, adding to support of previous versions of these databases.

Enhanced Integration Module Support

MapForce 2018 now supports integration with Eclipse version 4.7 in addition to previously supported versions.
Update
Existing customers may update to the latest version here
Download
Download a fully functional, free 30 day trial of any Altova product now!
New in MobileTogether
Support for Push Notifications and other new features for cross-platform mobile app development in MobileTogether 4.0

New Features in Previous Versions

Learn about all the additional capabilities you’ll get by upgrading from an older version to MapForce 2018.
MapForce® 2017 Release 3 (April 4, 2017)
Enterprise
Professional
Basic
MapForce® 2017 Release 3 (April 4, 2017)
New Join component for all data types
Support for NULL values in database table actions
New Find bar
Support for JSON5 syntax
Integration with Visual Studio 2017
Windows Server 2016 Support
MapForce® 2017 (October 4, 2016)
Enterprise
Professional
Basic
MapForce® 2017 (October 4, 2016)
Dynamic access to node names for generic mappings
Update-If and Insert-Rest database table actions performed as SQL Merge when possible
Support for EDIFACT versions 2015B and 2016A including the new VERMAS message
Support for inline XBRL files as a mapping source
Ability to add namespace nodes to XML output
MapForce Debugger is now available within Eclipse and Visual Studio integration packages
Support for XBRL taxonomy packages
Enhanced database support – support for ADO.NET database drivers, native support for PostgreSQL, support for Progress OpenEdge, support for SQL Server 2016
Support for integration with Eclipse 4.6
MapForce® 2016 release 2 (February 16, 2016)
Enterprise
Professional
Basic
MapForce® 2016 release 2 (February 16, 2016)
Support for REST Web services, including parameters and authentication settings
Significant speedup of EDI mappings processed by the Built-in Execution Engine
Support for integration with Eclipse 4.5
MapForce® 2016 (September 30, 2015)
Enterprise
Professional
Basic
MapForce® 2016 (September 30, 2015)
Interactive data mapping debugger
Support for Firebird databases
Support for numerous databases updated to include newest versions: IBM DB2 10.5, SQL Server 2014, PostgreSQL 9.4, MySQL 5.6, and Oracle 12C
Visual Studio integration updated to include VS 2015
Windows 10 support
New functions: min-string and max-string
MapForce® 2015 release 4 (June 10, 2015)
Enterprise
Professional
Basic
MapForce® 2015 release 4 (June 10, 2015)
Support for TRADACOMS EDI standards
MapForce® 2015 release 3 (February 25, 2015)
Enterprise
Professional
Basic
MapForce® 2015 release 3 (February 25, 2015)
String processing as XML, JSON, EDI, CSV, FLF, and FlexText, for both input and output components
FlexText support for regular expressions
Support for SQLite databases
Support for Web Services Security and other security extensions
Support for Excel 2013 files
New string processing functions pad-string-left, pad-string-right, repeat-string
Support for EDIFACT D.14A and D.14B and X12 5040, 6030, and 6040 standards – adds to existing support
MapForce® 2015 (September 17, 2014)
Enterprise
Professional
Basic
MapForce® 2015 (September 17, 2014)
JSON support – Read and write JSON files, with functionality similar to XML files, for both input and output components
XBRL Table Linkbase Support – When processing XBRL instances user can now map Table Linkbases, if available in the taxonomy
Support for US GAAP 2014 XBRL taxonomy – Adds to support for previous versions
New function replicate-item – A new sequence function that allows a mapping to produce a sequence of an arbitrary length from every single node
New Flextext option for Single Split "delimited (line starts with)" – Similar to the Repeated Split option that has been available in previous versions
Support for integration with Eclipse 4.4 – Adds to support for previous versions
Support for German, Spanish, and Japanese languages in format-date function
MapForce® 2014 Release 2 (March 19, 2014)
Enterprise
Professional
Basic
MapForce® 2014 Release 2 (March 19, 2014)
Support for CDATA generation in XML files – Target nodes may be specified individually for generation as CDATA
New functions for processing and generating sequences – New functions allow bulk processing of sequences, including generate-sequence, replicate-sequence and more
Timeout settings for Web service calls and database execution – Define timeouts for Web service calls (Enterprise Edition only) and database sources
Improved mapping validation and editing help – Mapping validation error message have been improved to enable quick identification of mapping errors
Support for integration with Visual Studio 2013 (adds to support for previous versions)
MapForce® 2014 (October 29, 2013)
Enterprise
Professional
Basic
MapForce® 2014 (October 29, 2013)
Support for XML wildcards (xs:any and xs:anyAttribute).
Integration of RaptorXML – RaptorXML is now used for all XSLT 1, XSLT 2 and XQuery transformations in MapForce.
Support for comments and processing instructions in output XML.
New function to calculate age based on a birthdate – Simplifies this calculation compared to using dateTime functions.
Support for new databases – Preliminary support announced in v2013r2 is now upgraded to full support implemented across the MissionKit product line.
Support for integration with Eclipse 4.3.
MapForce® 2013 Release 2 (April 29, 2013)
Enterprise
Professional
Basic
MapForce® 2013 Release 2 (April 29, 2013)
Deploy to FlowForce Server functionality – Makes it easy to deploy mapping projects to FlowForce Server for automation.
Preliminary support for new databases and database versions: Informix 11.70, PostgreSQL versions 9.0.10/9.1.6/9.2.1, MySQL 5.5.28, IBM DB2 versions 9.5/9.7/10.1, SQL Server 2012, Sybase ASE (Adaptive Server Enterprise) 15/15.7, and Access 2010/2013
MapForce® 2013 (September 15, 2012)
Enterprise
Professional
Basic
MapForce® 2013 (September 15, 2012)
Support for SQL stored procedures – MapForce 2013 now supports stored procedures as input components, output components, or even inserted into a mapping as a function-like call (allowing users to provide input data, execute the stored procedure, and read/map the output data to other components).
New API for integration into Java programs – Java developers working with popular Java tools for Windows platforms can now execute MapForce inside a window within their own application.
Support for US GAAP 2012 XBRL taxonomy – adds to support for earlier versions, enabling users to comply with the latest SEC revision of financial and business reporting mandates.
Support for integration with Eclipse 4.2 – adds to support for earlier versions, allowing developers to implement all the data mapping, content conversion, Web services implementation, and code generation capabilities of MapForce from within the latest version of the Eclipse environment.
MapForce® 2012 Release 2 (February 23, 2012)
Enterprise
Professional
Basic
MapForce® 2012 Release 2 (February 23, 2012)
Sort input data by various criteria – Saves a step for users who require large datasets to be sorted as part of a data mapping task.
Support for logical files in IBM iSeries databases – Users can map data both to and from logical files in IBM iSeries databases.
MapForce® 2012 (October 19, 2011)
Enterprise
Professional
Basic
MapForce® 2012 (October 19, 2011)
Streaming reading for large XML, CSV, and FLF files and databases – Allows mappings to process arbitrarily large XML, CSV, and FLF input files by using a streaming processor approach.
New functions parse-date and parse-time – Easier than the existing parse-dateTime function when data in an input stream defines only the date or time, not both.
Visual alignment guides on mapping screen – Allows users to create more clearly organized mapping displays.
JDBC database driver support – Improves database connectivity for many users.
New Java API – Allows Java developers to more easily manipulate, customize, and enhance MapForce functionality.
Search in Project Window – Helps users manage organization of large projects.
MapForce® 2011 Release 3 (June 8, 2011)
Enterprise
Professional
Basic
MapForce® 2011 Release 3 (June 8, 2011)
Define multiple ranges in a single Excel worksheet – Significantly increases flexibility of mapping designs.
Native Support for HIPAA 5010 – Support for a new EDI collection dedicated to HIPAA 5010, the latest version of the standard for electronic health care records established by the US Department of Health and Human Services for electronic medical data transactions between insurers, providers, and employers.
Auto-generation of message 999 for X12 version 5010 – Starting with version 5010, the X12 standard requires message 999 instead of 997 for error reporting.
Command line extensions – HTML/Word/PDF files can be generated in post-processing by StyleVision, similar to the interactive mode.
Support for .NET 4 in built-in execution – Users may now add external .NET 4 functions for immediate processing by MapForce.
Save individual values or entire sub-trees in intermediate variables – An optional feature to simplify and speed up mapping definitions.
Support for XML signatures on output – Optionally apply an XML digital signature to XML and XBRL output documents.
MapForce® 2011 Release 2 (February 16, 2011)
Enterprise
Professional
Basic
MapForce® 2011 Release 2 (February 16, 2011)
Direct file output (data streaming) – gives ETL projects a huge performance boost with the ability to stream XML, CSV, and FLF file output.
Expandable if-else component (switch statement) – enables users to easily control the flow of data in their mapping projects by matching a value to a selected criterion.
Ability to process different EDI message types in a single mapping – allows users to define multiple EDI mappings in a single design so that MapForce can automatically determine a suitable mapping based on the incoming message that has been received.
Support for the IATA PADIS EDI format.
Reverse existing mapping – lets users automatically reverse the direction of mappings that they have already created.
Ability to execute SQL statements prior to database output – enables users to execute SQL statements before the result of their database mappings is written to database tables.
New parsing functions – parse-number and parse-dateTime.
New function to retrieve node name – returns the QName of the selected node.
Ability to search Function Library.
Documentation formatting with StyleVision – lets users customize detailed reports for mapping verification and analysis.
MapForce® 2011 (September 8, 2012)
Enterprise
Professional
Basic
MapForce® 2011 (September 8, 2012)
Chained transformations – enables users to create complex mappings in which the output of one mapping becomes the input of another.
Integration with StyleVision for output components – lets MapForce users automatically render results of their XML and XBRL mappings in HTML, PDF, RTF, or Word 2007+ (depending on StyleVision edition) using an associated StyleVision template design.
Formatting of numbers, dates, and times – enables MapForce users to easily convert numbers, dates, and times to their string representations using a variety of different formatting functions.
Two new parameters in auto-number function – lets MapForce users access the same auto-number counter in different parts of their mappings and restart counting every time the supplied value changes.
Functions for working with timezones.
Extended support for EDIFACT – support has been extended to include 08B, 09A, and 09B messages.
Extended support for X12 – support has been extended to include the 6010 and 6020 transaction sets.
MapForce® 2010 Release 3 (May 10, 2010)
Enterprise
Professional
Basic
MapForce® 2010 Release 3 (May 10, 2010)
MSXML6 support in C++.
64-bit code generation in C++.
Support for xsi:nil in XML Schema.
Support for mapping field names (headers) in Excel 2007+.
Ability to preserve value formatting in XML output – allows users to ensure that formatting is maintained from source to target.
Support for SAP IDoc.
Support for Visual Studio 2010.
MapForce® 2010 Release 2 (February 16, 2010)
Enterprise
Professional
Basic
MapForce® 2010 Release 2 (February 16, 2010)
64-bit version – for use with 64-bit operating systems.
New string functions: tokenize, tokenize-regexp, tokenize-by-length.
Automatic reassignment of child connections – enables users to automatically reassign descendent element mappings when a parent element is mapped to a new connection.
Automatic generation of X12 997 messages – lets users automatically create mappings to X12 functional acknowledgment messages.
Support for external C# and Java calls – allows users to use external C# and Java functions in mapping transformations inside MapForce.
Simplified process for adding C# and Java libraries.
MapForce® 2010 (October 28, 2009)
Enterprise
Professional
Basic
MapForce® 2010 (October 28, 2009)
Processing data from/into multiple files – enables users to easily consolidate file collections by aggregating data from a directory into one file or split data from one source into multiple files.
Using input/output file names as parameters – lets users generate dynamic mappings in which this information is defined at run-time.
Support for xsi:type in XML Schema – allows users to incorporate schemas that use abstract and derived types in their mapping projects.
EDI file validation in generated code – lets users validate the EDI output in MapForce-generated code.
Support for additional EDIFACT messages – provides integrated access to configuration files for the control messages: CONTRL, AUTACK, and KEYMAN.
Support for WSDL 2.0 – lets users use the WSDL 2.0 recommendation from the W3C for building and connecting to Web services.
Compatibility with Windows 7.
MapForce® 2009 (February 3, 2009)
Enterprise
Professional
Basic
MapForce® 2009 (February 3, 2009)
Support for XBRL taxonomies & XBRL Dimensions – enables users to comply with financial and business reporting mandates by graphically mapping internal data to the XBRL format.
Support for HL7 v2 EDI – allows healthcare organizations to comply with international mandates for the secure transmission of clinical data.
Support for HL7 v3 XML – allows HL7 users to update their messages and transmission data to the latest version of the standard.
Support for grouping – enables users to combine source data in groups for output and then apply processing instructions to those groups, essentially transforming flat data into a hierarchical structure.
Distinct-values function – allows users to automatically remove duplicate values from the result-set of a mapping.
Position function – gives users the ability to return output based on the context position of data in the input document.
Documentation generation – enables designers and data integration specialists to share and confirm the accuracy of their mappings with other departments and/or customers.
Find dialog for identifying nodes – allows users to search for specific nodes within mapping components.
Native support for XML fields in SQL Server – lets users expose XML data in SQL Server database fields for mapping by assigning an XML Schema to the data in that field.
Support for additional databases – SQL Server 2008, Oracle 11g, and PostgreSQL 8.
MapForce® 2008 Release 2 (April 28, 2008)
Enterprise
Professional
Basic
MapForce® 2008 Release 2 (April 28, 2008)
Mapping Excel 2007+ (OOXML) data.
Support for data streams for code generation.
Sample XML Schema generation based on an XML instance.
Support for SOAP 1.2.
Support for SQL SELECT statements.
Inline Primary Key / Foreign Key creation.
Project generation for Visual Studio 2008.
MapForce® 2008 (September 12, 2007)
Enterprise
Professional
Basic
MapForce® 2008 (September 12, 2007)
Support for aggregate functions: SUM, MIN, MAX, AVG, STRING-JOIN – allows users to perform computations on a range of data within a source field and return a single value to the target.
ValueMap function for transforming field values – allows users to build a MapForce data processing function that maps one field value to another to ensure that values are written to the mapping target in the desired style.
Enhanced options for XML output – including options for pretty printing, omitting schema references, and changing and setting encoding options.
MapForce® 2007 Release 3 (May 30, 2007)
Enterprise
Professional
Basic
MapForce® 2007 Release 3 (May 30, 2007)
Seamless integration of XML fields in databases in mapping components – users can map XML data directly to and from XML-enabled databases by assigning an XML Schema to the data (for IBM DB2 9 only in this version).
Enhanced database connectivity – via a quick connect wizard to easily access, preview, and integrate database data.
Extended data filtering functionality – MapForce now supports the SQL-WHERE filter, which allows for precise, high-performance filtering of database sources used in data mapping projects.
Redesigned and optimized code generation.
MapForce® 2007 (October 24, 2006)
Enterprise
Professional
Basic
MapForce® 2007 (October 24, 2006)
Enhanced Web services support – Web services can be a source, target, or data processing function in any mapping project.
Improved editing of existing mappings – added visual cues and support for refactoring mappings when source or target data structures change.
Tighter Visual Studio integration – for integrating the MapForce user interface and functionality into Microsoft’s premier multi-purpose development environment.
MapForce® 2006 Release 3 (June 1, 2006)
Enterprise
Professional
Basic
MapForce® 2006 Release 3 (June 1, 2006)
Added integration with Microsoft Visual Studio and Eclipse – allows developers to directly harness all the data mapping, content conversion, Web services implementation, and code generation capabilities of MapForce from within their favorite platforms.
Enhanced EDI Transaction Set Editing – allowed users to easily modify and extend existing standard EDI transaction sets (i.e. EDIFACT and ANSI X12 messages) to meet business requirements.
More Versatile Visual Function Builder – enabled visual creation of data processing functions that can operate on entire XML tree fragments, allowing for better modularization and scalability of mapping projects.
Options for Handling Empty Flat File Values – provided ability for developers to choose whether empty fields in flat files are rendered as empty elements or not rendered at all in the data results of the mapping target.
MapForce® 2006 (October 3, 2005)
Enterprise
Professional
Basic
MapForce® 2006 (October 3, 2005)
Introduced Visual Web Services Construction – developers can simply map between operations in Web Services Description Language (WSDL) transactions by dragging connecting lines between data sources and WSDL operations.
Supported Web Services Implementation – auto-generate required C# or Java code for implementing Web services on a server after mappings have been defined for the transactions in a WSDL file.
FlexText™ Flat File Parsing – a graphical utility for parsing structured text files and incorporating legacy data into mapping designs
Project Management and Code Generation – enabled grouping of related data mappings and Web services mappings into a project, then allows automatic code generation either for individual mappings or for the entire project.
Enhanced Standards Support – updated XSLT 2.0, XPath 2.0, and XQuery support in compliance with then-current World Wide Web Consortium (W3C) Working Drafts released on September 15, 2005.
Textual Annotation – simplified documentation of mapping projects with the ability to add annotations to mapping connections
Support for OLE and ActiveX Control – allowed developers to embed the MapForce user interface and access all its functionality from within their own applications
Introduced three editions – tailored to meet customers’ specific Web services and data integration needs: MapForce 2006 Basic Edition supports XML-to-XML mappings,MapForce 2006 Professional Edition supports XML, database, and basic flat file data mappings, MapForce 2006 Enterprise Edition supports all the features of MapForce 2006 Professional Edition with the addition of Web services mapping and implementation, EDI mapping, and the FlexText flat file integration utility.
MapForce® 2005 release 3 (March 9, 2005)
Enterprise
Professional
Basic
MapForce® 2005 release 3 (March 9, 2005)
EDI Output – enabled the use of EDI files in the ANSI/ASC X12 and UN/EDIFACT standards as output targets of complex data mappings. This capability expands MapForce’s previous support of EDI files as input sources.
ANSI X12 Standard Support – provided full support for all the transaction sets covered by X12, the de facto EDI standard used in North America for electronic business transactions. Files based on the X12 standard can be used as both mapping sources and targets.
Extended EDIFACT Coverage – supported EDIFACT configuration files for all years starting with 93a through 04b.
Unlimited Function Input Parameters – allowed the use of unlimited parameters in several data processing functions, such as concatenate, add, and multiply, when using MapForce’s visual function builder. This feature made it easier for developers to perform mathematical manipulations and concatenate multiple parameters
Mixed Content Mapping Support – accommodated mapping of mixed XML elements, such as text and sub-elements
Accommodation of Null Values – enabled mappings of XML files and databases to use default values when sources have absent or null values, but targets must receive content
MapForce® 2005 (October 3, 2004)
Enterprise
Professional
Basic
MapForce® 2005 (October 3, 2004)
XSLT 2.0 Code Generation – introduced auto-generation of program code required to execute XML mappings and transformations using the new XSLT 2.0 specification.
XQuery Code Generation – added auto-generation of program code required to execute intelligent querying of XML documents and databases via the new XQuery 1.0 specification.
Flat File Support – added the ability to use CSV, tab-separated, or fixed-width text files as the sources and/or targets of data mappings.
Visual Function Builder – enabled the creation and reuse of custom mapping transformation and data processing functions.
Transformation Input Parameters – allowed the input of outside parameters for use in mapping transformations at runtime.
MapForce® 2004 Release 4 (May 17, 2004)
Enterprise
Professional
Basic
MapForce® 2004 Release 4 (May 17, 2004)
Introduced two editions – Enterprise and Professional.
Greatly enhanced mapping functionality – provides the ability to map any combination of XML, database, and EDI data into XML and/or databases
Added database support – now supports all the most popular relational databases: Microsoft Access, Microsoft SQL Server, MySQL, Oracle, IBM DB2, Sybase, as well as any ADO/ODBC database
Introduced MapForce Engine – enabled the user to preview the output of any mapping project even if one or more of the sources is a database or an EDI file, or if the target is a database.
Allowed users add existing XSLT files as libraries – all named templates in those files automatically become available as data transformation functions.
MapForce® 2004 Release 3 (October 21, 2003)
Enterprise
Professional
Basic
MapForce® 2004 Release 3 (October 21, 2003)
Introduced code generation in C# and C++.
Supported visual mapping of Database Views to XML.
Numerous usability enhancements including zoom, copy & paste, printing, autohighlighting of connections, and much more.
Update
Existing customers may update to the latest version here
Download
Download a fully functional, free 30 day trial of any Altova product now!