New in MapForce 2017r3
Version 2017 Release 3 of Altova MapForce became available on April 4, 2017. Learn about all the new features below and update to the latest version.
Enterprise
Professional
Basic
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

New Join Component

A new join component for data mapping works like a SQL join for database tables and extends data integration functionality by empowering users to join data trees of any data format. Since join works similarly to a SQL JOIN statement, so it is easy to understand and intuitive to use. Join is also extremely visual, since results can be viewed immediately in the output window. When applied to databases, the join component in MapForce produces SQL JOIN statements, achieving fast data mapping execution.
The structures to be joined in MapForce can even contain different data types. For example, an XML structure could be joined with a CSV file. In the data mapping at right, information from two XML files is joined to create a complete contact list for a group of people.
New join component in MapForce
The condition element at the bottom of the join component defines how the files are combined. Our mapping needs to match FirstName and LastName from each file to connect the right address to each email and phone number. Clicking on the key icon next to the condition opens a dialog where the condition is defined.

Support for NULL Values in Database Table Actions

The Database Table Actions dialog has been extended to support NULL value comparison. NULL-aware comparisons provide an improved way to handle databases that contains null values. MapForce 2017r3 users can now configure a database mapping so that data comparison is done in a NULL-aware manner, according to rules applicable to the database kind involved in the mapping.
The data mapping shown at right is intended to update the target table without inserting duplicate entries. Both tables are defined allowing the email field to be NULL, so matching name entries with NULL email fields could exist in each table.
Clicking the Actions icon next to the TARGET database table opens the Database Actions Dialog. The NULL equal checkbox next to the email field allows MapForce to treat NULL values in the source and target as equal for data mapping purposes, even though they are not considered equal by database rules.
Null-aware data mapping in MapForce

All new Find functionality for various Output windows

A new MapForce Find bar is based on the Find features introduced in XMLSpy 2017.
The new Find bar allows users to perform searches of text in the Output, XQuery, and XSLT windows. New features include:
  • Case sensitive searches
  • Regular expressions
  • Find in current selection
  • Multi-line searches
Additionally, highlighting any string will instantly highlight all matches throughout the document, with their locations indicated on the scroll bar as well.
The enhanced Find functionality gives users one more tool to check the output of immediate conversions for the desired data mapping results.
New find features in MapForce

JSON5 Support

JSON5 is a proposed extension to JSON intended to make JSON code easier for humans to write and read. MapForce supports JSON5 as input, output, or intermediate data mapping components in chained mappings.

Updated Visual Studio and Windows Server support

Adding to support for previous versions, MapForce now supports integration with Visual Studio 2017 and can run on the Windows Server 2016 operating system.
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
Over 18 new features for mobile app development in MobileTogether 3.2

New Features in Previous Versions

Learn about all the additional capabilities you’ll get by upgrading from an older version to MapForce 2017.
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 acknowledgement 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!