What's new in Altova MapForce Enterprise Edition 2024 Release 2

Apr 23, 2024
  • Support for FORTRAS EDI messages:
  • MapForce supports EDI messages for numerous industry standards as the source or target of any data transformation process. New support has been added for FORTRAS EDI in the latest version.
  • FORTRAS EDI messages are used to exchange information among freight hauling companies, and support for this popular standard has been requested by MapForce customers working on EDI data integration.
  • Option to share database connection among components:
  • In some data mapping applications, a project may connect to the same database twice. Now, in these cases it is easy for database components to share the same database connection. This is enabled by checking Use Shared Database Connection at Runtime in the database component settings.
  • Ability to deploy original design file to FlowForce Server:
  • High performance automation of data integration and ETL projects defined in MapForce is provided by MapForce Server and FlowForce Server, with MapForce Server automating data transformation and FlowForce Server providing comprehensive workflow management.
  • When you deploy your MapForce Server Execution file to FlowForce Server, it is now possible to attach the mapping files for later retrieval. This will help your team if the original files are lost unintentionally by enabling them to download them at any time.
  • Support for video and web links in Projects:
  • MapForce includes a Project view for creating projects that include multiple data mapping projects, input files, and other related assets.
  • MapForce users can now add links to relevant web pages and videos in their MapForce projects.
  • The MapForce Examples project that ships with the software now includes numerous links to video tutorials and web pages describing specific functionality alongside the relevant sample MapForce projects.
  • Code generation for .NET 8:
  • C# code generation is now available for the .NET framework in addition to earlier versions. MapForce also offers royalty-free program code generation in Java and C++.
  • Updated database support:
  • MapForce supports connecting to the most popular SQL and NoSQL databases, as well as numerous versions thereof, for data integration and ETL projects.
  • Support has been updated in the latest version to include:
  • MySQL 8.2 & 8.3
  • PostgreSQL 16
  • MariaDB 11.2
  • SQLite 3.45

New in Altova MapForce Enterprise Edition 2023 Release 2 (Apr 12, 2023)

  • Support for VDA EDI messages
  • Comments in data mapping projects
  • Support for standalone =“yes” declaration in XML output
  • Support for additional EDIFACT version: 2022B
  • Support for additional database versions:
  • MapForce now supports the latest versions of the following relational databases in addition to previous versions:
  • Firebird 4
  • PostgreSQL 15
  • SQL Server 2022
  • Integration with latest Eclipse versions:
  • MapForce can be integrated in the Eclipse IDE, with support added for the latest versions:
  • Eclipse 4.26
  • Eclipse 4.27

New in Altova MapForce Enterprise Edition 2023 (Oct 19, 2022)

  • Integrated Altova XML Schema Manager
  • Light and Dark modes
  • Support for ODETTE EDI messages
  • Support for additional EDIFACT versions: 2021B, 2022A
  • Support for additional SWIFT version: 2022
  • Ability to dynamically set EDI separators and terminators
  • Support for additional database versions
  • Integration with Eclipse 4.23, 4.24, 4.25

New in Altova MapForce Enterprise Edition 2022 Release 2 (Mar 8, 2022)

  • Support for images in the Project Window:
  • The StyleVision Project Window provides a convenient view for grouping, managing, and working with related files. Once collected in a project, files can be accessed easily from the Project sidebar when designing a report.
  • Now, when a project includes images, you can preview (via mouseover) and open them directly from the Project Window.
  • StyleVision now supports the latest versions of the following databases in addition to previous versions:
  • IBM DB2 11.5.7
  • MySQL 8.0.28
  • MariaDB 10.6.5
  • SQLite 3.37
  • PostgreSQL 14.1
  • Integration with latest Visual Studio and Eclipse versions
  • StyleVision can be integrated in the Eclipse and Visual Studio IDEs, with support added for the latest versions:
  • Eclipse 4.22
  • Visual Studio 2022

New in Altova MapForce Enterprise Edition 2022 (Oct 27, 2021)

  • Support for NoSQL databases:
  • NoSQL – sometimes said to stand for “not only SQL” and other times “no SQL” – databases store data in a format different than the relational tables found in relational databases.
  • While MapForce has long supported a wide variety of relational database types, a frequent user request has been support for mapping and converting data in NoSQL databases. Now, with Version 2022, MapForce includes native support for MongoDB and Apache CouchDB, two of the most popular NoSQL databases, with plans to add additional types in the future.
  • Support for Windows 11:
  • MapForce and all Altova desktop and server software in the Version 2022 release now supports running on Windows 11.
  • Windows 11 represents a significant operating system upgrade from Microsoft that brings improved stability, security, scalability, and enhanced performance to developer desktops and laptops. Altova is proud to release full Windows 11 compatibility in its v2022 product line.
  • Variables based on JSON Schema:
  • In MapForce variables are a special type of component used to store an intermediate mapping result for further processing. Variables can be simple types (e.g., string, integer, boolean, etc.) and complex types (a tree structure).
  • With Version 2022, the variables component now also supports variables based on JSON Schema.
  • Copy all connections for JSON structures:
  • Copy all connections is a convenient feature that lets you automatically map data between complex structures (i.e., nodes with child items) that are similar or the same.
  • Now, auto connecting matching child items also works for JSON data structures.
  • Support for additional EDI versions:
  • MapForce supports data mapping and conversion for numerous EDI standards, with updated version support as follows:
  • EDIFACT 2020B and 2021A
  • SWIFT 2021
  • Support for additional database versions:
  • MapForce now supports the latest versions of the databases below in addition to previous versions.
  • IBM DB2 11.5
  • MySQL 8.0.25
  • PostgreSQL 13
  • SQLite 3.35.5
  • Integration with the newest versions of Eclipse:
  • MapForce supports seamless integration with the Eclipse IDE, with support in the latest version added for Eclipse 4.19, 4.20, and 4.21.

New in Altova MapForce Enterprise Edition 2021 Release 3 (Jun 1, 2021)

  • Support for JSON Schema versions 2019-09, 2020-12

New in Altova MapForce Enterprise Edition 2021 Release 2 SP1 (Mar 31, 2021)

  • Bug fixes and other enhancements

New in Altova MapForce Enterprise Edition 2021 (Oct 14, 2020)

  • Support for SWIFT messages
  • Conversion of EDI to XML without mapping
  • Arbitrary location of EDI configuration files
  • Support for SQL left outer join
  • Dynamic assignment of URLs for REST Web services at runtime
  • Read/write binary files
  • XBRL Taxonomy Manager
  • COVID-19 related XBRL taxonomy updates
  • Updated support for MariaDB
  • Integration with Eclipse 4.15 and 4.16

New in Altova MapForce Enterprise Edition 2020 Release 2 (Mar 17, 2020)

  • Excel output: option to update existing documents:
  • MapForce supports converting data to or from Excel documents.
  • This new feature allows you to write directly to nicely formatted Excel files to update its data at runtime: any designated worksheets, rows, and cells from the specified file will be replaced with data from the mapping and all formatting in the existing file will be preserved as-is. To protect functionality in the existing spreadsheet, cells with formulas will not be overwritten.
  • This option gives developers even more flexibility, especially for outputting nicely formatted Excel files for end users, directly from MapForce.
  • All new Library Management system:
  • MapForce includes a comprehensive data processing function library, and developers may also import libraries and build and save user-defined functions. In MapForce 2020r2, a new Manage Libraries window has been introduced to make this process more flexible and straightforward.
  • Adding to the ability to import libraries globally such that libraries and user defined functions are available to all mappings, the Manage Libraries window now lets users import them to a specific data mapping project (.mfd). This way, when you send a MapForce project file to colleague(s), it will already include any imported libraries – they do not have to be installed separately. This also makes it possible to, for example, easily copy and paste user-defined functions from one mapping to another seamlessly.
  • In the case of XML mappings, when a project imports XSLT or XQuery libraries, developers can now generate XSLT or XQuery code that references the imported library files using a relative path.
  • The MapForce COM API supports the new library management functionality as well. For example, if you need to configure a standard setup of available common libraries for all users on your team, you can now use the COM API to set up the same set of libraries for each one of your developers when you initially configure MapForce on their machines.
  • New namespace options in generated (C++, C#, Java) code:
  • When program code is auto-generated in C++, C#, or Java based on XML data mapping projects in MapForce, new methods are available to declare or override namespaces for an element, or to append an element with a prefixed namespace.
  • Extended support for UN/EDIFACT:
  • When mapping EDIFACT EDI messages, MapForce provides support for numerous versions of the UN/EDIFACT standard, now updated to include 2019A and 2019B.
  • Support for additional database versions:
  • MapForce supports mapping data in any of the most popular databases, and in this release support is added for new versions of:
  • Informix 14.10
  • PostgreSQL 12
  • SQLite 3.31
  • Integration with Eclipse 4.13 and 4.14:
  • MapForce offers optional integration with Eclipse, adding support for its latest versions in this release.

New in Altova MapForce Enterprise Edition 2020 (Oct 9, 2019)

  • Support for OAuth 2.0 in Web services calls
  • Support for JSON Lines
  • Value Map configuration via copy/paste
  • Extended Value Map options
  • Database schema independency
  • Extended support for Oracle packages
  • Ability to deploy Global Resources to MapForce Server & FlowForce Server
  • Support for additional database versions
  • Code gen for & integration with Visual Studio 2019
  • Integration with Eclipse 4.11 and 4.12

New in Altova MapForce Enterprise Edition 2019 Release 3 (Apr 2, 2019)

  • MapForce is going sharp - full support for high resolution monitors
  • Support for JSON Schema draft-06 and draft-07
  • Handling of Web services errors
  • Dynamic username and password for Web services
  • Support for unstructured request/response bodies in REST Web services
  • Database output logging (tracing)
  • Transaction roll-back for database error handling
  • New functions: charset-encode / charset-decode
  • Support for additional database versions
  • Support for EDIFACT 2018B
  • Updated OpenJDK support
  • Support for Windows Server 2019
  • Support for Office 2019
  • Support for Eclipse 4.9 and 4.10

New in Altova MapForce Enterprise Edition 2019 (Oct 18, 2018)

  • Support for mapping Protocol Buffers
  • Additional functionality for node functions
  • Support for EDIFACT 2017B, 2018A
  • Support for additional database versions
  • Support for Eclipse 4.6, 4.7 and 4.8

New in Altova MapForce Enterprise Edition 2018 Release 2 (Apr 23, 2018)

  • 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

New in Altova MapForce Enterprise Edition 2015 Release 3 (Apr 3, 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

New in Altova MapForce Enterprise Edition 2014 SP 1 (Dec 5, 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

New in Altova MapForce Enterprise Edition 2013 Release 2 SP 2 (Jun 28, 2013)

  • SP2 includes the enhancements listed under SP1 as well as single-thread execution options, performance-oriented bug fixes, and more.

New in Altova MapForce Enterprise Edition 2013 Release 2 SP 1 (Jun 28, 2013)

  • Provides management of RaptorXML Server via FlowForce Server, and availability of RaptorXML Development Edition for licensed customers of XMLSpy, MapForce, and StyleVision.

New in Altova MapForce Enterprise Edition 2013 (Nov 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

New in Altova MapForce Enterprise Edition 2012 Release 2 (Mar 6, 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

New in Altova MapForce Enterprise Edition 2012 (Oct 24, 2011)

  • Streaming reading for large files:
  • MapForce 2012 includes new streaming reading functionality for large XML, CSV, and FLF (fixed length format) files and databases. This enhanced read feature is equivalent to the direct file output feature introduced in v2011r2. Now the MapForce built-in execution engine can read arbitrarily long input sources and create correspondingly large output streams.
  • Users no longer have to split extremely large XML, CSV, or FLF input files into chunks for processing, and MapForce can even theoretically read an entire relational database in one pass and generate an XML or other output file in a single pass.
  • This is an important feature for extremely large ETL (Extract/Transform/Load) applications. MapForce already has included streaming output capabilities in recent releases and the streaming input capabilities allow MapForce to perform the most demanding ETL tasks.
  • New parse-date and parse-time functions:
  • Users must produce a tremendous variety of representations of date and time in data transformation projects. Sometimes an input data stream includes a value that represents only the date or only the time. These two new functions make it easier to process these formats than the existing parse-dateTime function.
  • Visual alignment guides:
  • Complex data mappings with many components and functions can appear very cluttered on the screen. MapForce 2012 introduces new horizontal and vertical alignment guides to help users organize a mapping as they drag elements into place.
  • JDBC database driver support:
  • Now, in addition to ODBC and ADO drivers, MapForce 2012 supports JDBC database drivers for database connectivity. When the user clicks the Insert Database toolbar icon or menu selection, the database connection dialog now includes a selection for JDBC drivers.
  • JDBC stands for Java Database Connectivity and JDBC drivers were originally developed by database vendors to support Java programming environments. Currently, database vendors such as Oracle and IBM DB2 apply greater development resources to JDBC drivers than older ODBC connectivity models, and JDBC is the recommended driver for those databases. However, ODBC drivers continue to be supported by MapForce as in earlier releases, and the recommended connection method for accessing Microsoft database products remains ADO.
  • Java developers who work with databases are likely to have JDBC drivers already installed on their workstations, making database mapping in MapForce much more straightforward.
  • Users who want to compile Java code generated from MapForce database mapping projects have needed JDBC drivers even before v2012, so directly supporting JDBC drivers in MapForce 2012 simplifies configuration of working environments for ETL (Extract Transform Load) developers.
  • New Java API:
  • The same features of the new Java API described above in the XMLSpy section are available in MapForce 2012, allowing Java developers to directly manipulate MapForce functionality via the Java API. New API examples for all programming languages demonstrate API functionality much more extensively than previous versions.
  • Search in Project window:
  • Also as described above in the XMLSpy section, search functionality has been added to the Project window in MapForce 2012. This means users can find files contained in large, complex MapForce projects more easily.
  • The Help in MapForce 2012 frequently refers to example files included in the MapForce Examples project. Since the MapForce Examples folder now contains over 400 individual files in multiple sub-folders, searching in the project window can often be the fastest way to find a relevant mapping example

New in Altova MapForce Enterprise Edition 2011 Release 3 (Jun 11, 2011)

  • Define multiple ranges in a single Excel worksheet
  • Native Support for HIPAA 5010
  • Auto-generation of 999 messages for X12 version 5010
  • Command line extensions
  • Support for .NET 4 in built-in execution
  • Save individual values or entire sub-trees in intermediate variables
  • Support for XML signatures on output

New in Altova MapForce Enterprise Edition 2011 Release 2 (Feb 21, 2011)

  • Direct file output (data streaming)
  • Expandable if-else component (switch statement)
  • Ability to process different EDI message types in a single mapping
  • Support for the IATA PADIS EDI format
  • Reverse existing mapping
  • Ability to execute SQL statements prior to database output
  • New parsing functions
  • New function to retrieve node name
  • Ability to search Function Library
  • Custom analysis reports via StyleVision integration

New in Altova MapForce Enterprise Edition 2011 (Sep 15, 2010)

  • 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.

New in Altova MapForce Enterprise Edition 2010 Release 3 (Sep 15, 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 ro ensure that formatting is maintained from source to target.
  • Support for SAP IDoc
  • Support for Visual Studio 2010

New in Altova MapForce Enterprise Edition 2010 Release 2 (Feb 25, 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

New in Altova MapForce Enterprise Edition 2010 (Oct 29, 2009)

  • Processing data from/into multiple files
  • Using input/output file names as parameters
  • Support for xsi:type in XML Schema
  • EDI file validation in generated code
  • Support for additional EDIFACT messages
  • Support for WSDL 2.0

New in Altova MapForce Enterprise Edition 2009 SP1 (May 12, 2009)

  • Support for XBRL taxonomies & XBRL Dimensions;
  • Support for HL7 v2 EDI; Support for HL7 v3 XML;
  • Support for grouping;
  • Distinct-values function;
  • Position function;
  • Documentation generation;
  • Find dialog for identifying nodes;
  • Native support for XML fields in SQL Server;
  • Support for additional databases;