Please enable JavaScript to view this site.

Altova MapForce 2020 Professional Edition

New in MapForce 2020 Release 2:


A new Manage Libraries window is available that enables you to view and manage all function libraries imported at document and at program level (this includes MapForce user-defined functions and other kinds of libraries). This makes it possible, for example, to easily copy-paste user-defined functions from one mapping to another, see Copy-Pasting UDFs Between Mappings.

When a mapping file imports libraries, the path of imported library files is relative to the mapping file by default, see Relative Library Paths. You can still import mappings at application level, like in previous releases, but in this case the library path is always absolute.

If a mapping file imports XSLT or XQuery libraries, you can generate XSLT or XQuery code that references the imported library files using a relative path. The new option is available in the Mapping Settings dialog box.

The MapForce API has been enhanced with new members that enable you to manage imported libraries programmatically (for example, add or remove them).

Code generated for XML schema wrapper libraries now provides more control over element namespaces and prefixes. New methods are available to declare or override namespaces for an element, or to append an element with a prefixed namespace. See Example: Purchase Order.

New database versions are supported: PostgreSQL 12.1 and Informix 14.10.

Internal updates and optimizations



New in MapForce 2020:


Support for Visual Studio 2019 in the MapForce Plug-in for Visual Studio and code generation

Support for Eclipse 4.9 - 4.12, see MapForce Plug-in for Eclipse

If an Oracle package contains public stored procedures or functions, those are also available to the mapping, see Adding Stored Procedures to the Mapping.

You can configure a database component so that database object names are treated as relative to the default schema, not bound to a particular schema. This helps save time if you need to switch to a different database in future, see Switching Databases and Schemas.

You can deploy Global Resources created in MapForce to FlowForce Server, see Deploying Global Resources to FlowForce Server.

When replacing values with the help of a look-up table, you can paste tabular data (key-value pairs) from external sources such as CSV or Excel into the mapping. Also, it is easier to handle cases when a value is not found in the predefined look-up table—processing such values no longer requires the use of substitute-missing function. See Using Value-Maps.

Internal updates and optimizations



New in MapForce 2019 Release 3:


Major parts of the graphical user interface are now optimized for monitors with high pixel density (HiDPI)

Support for Database Tracing and Error Logging

Better support for database transaction handling in generated program code and server execution. If an error occurs when a mapping updates a database, it is possible to continue the mapping execution even if some operations failed, see Handling Database Exceptions.

A mapping can encode or decode Base64 data with the help of the new charset-encode and charset-decode functions.

New database versions are supported: PostgreSQL 11, Db2 for i 7.2 and 7.3

Support for Eclipse 4.7 - 4.10, see MapForce Plug-in for Eclipse

Support for explicitly setting the Java Virtual Machine path from MapForce, see Java Settings

Internal updates and optimizations



New in MapForce 2019:


New database versions are supported: Firebird 3.0, Informix 12.10, MariaDB 10.2, MySQL 8.0, PostgreSQL 10, SQL Server 2017, SQL Server for Linux (adds to support for previous versions)

You can selectively apply a default value or node function to specific nodes that meet your custom-defined criteria. For example, you can apply a node function only to nodes of specific type whose name matches a regular expression, see Applying Node Functions and Defaults Conditionally.

When creating node functions, you can process data conditionally based on metadata such as node name or node annotation, see Supplying Node Metadata to Node Functions.

Mappings that contain grouping functions run much faster in generated C#, C++, or Java code

Internal updates and optimizations



New in MapForce 2018 Release 2:


Support for the following databases: MariaDB 10.2, Teradata 16

Built-in functions, user-defined functions, and constants can be conveniently added to the mapping by double-clicking an empty area on the mapping (see Add a Built-in Function to the Mapping and Add a Constant to the Mapping)

Internal updates and optimizations



New in MapForce 2018:


Support for generating program code for Visual Studio 2013, 2015, and 2017, see Code Generator

Support for the following database versions: Sybase ASE 16, PostgreSQL 9.6, MySQL 5.7

Internal updates and optimizations



New in MapForce 2017 Release 3:


A new component type (Join) has been introduced which can be used to join data from two or more different structures based on custom-defined conditions (see Joining Data). When the mapping reads data from a database, it is possible to join database tables or views in SQL JOIN mode, see Joining Database Data.

The text search options in the Output pane, the XQuery pane, as well as the XSLT pane have been enhanced (see Searching in Text View). Also, text highlighting is available in the above-mentioned panes (see Text Highlighting).

Mappings which update databases can be optionally configured to compare data in a NULL-aware manner. NULL-aware comparisons provide a better way (tailored to each specific database) to handle data that contains null values (see Handling Nulls in Database Table Actions).

In the MapForce ActiveX control, the structure of the MapForceCommand object has been enhanced to include a new Name property, which can be used to get the unique name of the command. This simplifies retrieving information about MapForce commands programmatically (see Retrieving Command Information).

Internal updates and optimizations



New in MapForce 2017:


It is possible to read node names from a source XML (or field names from a CSV/Fixed-length field file) and map this information to a target. It is also possible to dynamically create new XML attributes or elements in a target based on values supplied from a source. See Mapping Node Names.

XML instance files can be created with custom namespaces, at element level (see Declaring Custom Namespaces)

MapForce Server execution files (.mfx) can be compiled for specific MapForce Server versions (see Compiling mappings for a specific MapForce Server version)

Mappings can connect to PostgreSQL databases through native connections (see Setting up a PostgreSQL Connection)

Mappings can connect to SQL Server and other database types through ADO.NET providers (see Setting up an ADO.NET Connection)

A new database type is supported: Progress OpenEdge. See Connecting to Progress OpenEdge (ODBC) and Connecting to Progress OpenEdge (JDBC).

When connecting to a database through JDBC, the search path to .jar libraries can be specified directly in the database connection dialog box (see Setting up a JDBC Connection)

When a database is updated by the mapping through "Update if... Insert Rest" actions, MERGE statements are created for selected databases (see MERGE statements)

Internal updates and optimizations



New in MapForce 2016 R2:


More intuitive code folding in the XSLT pane: collapsed text is displayed with an ellipsis symbol and can be previewed as a tooltip. The same rules apply for text in the XQuery pane and the SQL Editor

You can search for all occurrences of a function within the active mapping (in the Libraries window, right-click the function, and select Find All Calls).

Internal updates and optimizations



New features in MapForce 2016:


Improved generation of XSLT 1.0 code (generated stylesheets are easier to read and often faster to execute)

Two new aggregate functions are available in the MapForce core library: min-string and max-string. These functions enable you to get the minimum or maximum value from a sequence of strings.

Mappings written for the Built-in execution engine can be debugged (see Debugging Mappings)

The MapForce Plug-in for Visual Studio supports Visual Studio 2015 (adds to support for previous versions)

New database versions are supported: SQL Server 2014, Oracle 12c, IBM DB2 10.5, PostgreSQL 9.4, MySQL 5.6 (adds to support for previous versions)

Firebird databases are supported (see Connecting to Firebird (ODBC) and Connecting to Firebird (JDBC) )



New features in MapForce Version 2015 R4:

In the MapForce plug-in for Eclipse, the commands specific to MapForce files are now available under a new MapForce menu (see Accessing Common Menus and Functions)

Internal updates and optimizations



New features in MapForce Version 2015 R3 include:


Option to suppress the <?xml ... ?> declaration in XML output

Text-based components (including EDI, CSV, fixed-length field, JSON, and XML) can parse and serialize strings in addition to plain files

SQLite database support (see Setting up a SQLite connection)

New string padding functions: pad-string-left and pad-string-right

New component type: Simple Output

Internal updates and optimizations



New features in MapForce Version 2015 include:


New language argument available in the format-date and format-dateTime functions

New sequence function: replicate-item



New features in MapForce Version 2014 R2 include:


New sequence functions: generate sequence, item-at, etc.

Ability to define CDATA sections in output components

Ability to define timeout values for database execution

Keeping connections after deleting components

Bulk transfer of database data (bulk Insert all)

Automatic highlighting of mandatory items in target components



New features in MapForce Version 2014 include:


Integration of RaptorXML validator and basic support for XML Schema 1.1

Integration of new RaptorXML XSLT and XQuery engines

XML Schema Wildcard support, xs:any and xs:anyAttribute

Support for Comments and Processing Instructions in XML target components

Age function

Ability to always insert quote character for CSV files



New features in MapForce Version 2013 R2 SP1 include:


New super-fast transformation engine RaptorXML Server



New features in MapForce Version 2013 R2 include:


MapForce Server support.

Ability to generate a MapForce Server execution file from the command line and File menu, to be executed by MapForce Server.

Ability to deploy MapForce mappings to FlowForce Server.

Support for Informix 11.7 databases, and extended support for other databases.

User defined end-of-line settings for output files.

Internal updates and optimizations.



New features in MapForce Version 2013 include:


Ability to call stored procedures in mappings

Support for database functions (functionally similar to stored procedures)

Support for SELECT statements with parameters

Internal updates and optimizations



New features in MapForce Version 2012 R2 include:


New Sort component for XSLT 2.0, XQuery, and the Built-in execution engine

User defined component names

Extended SQL-Where functionality: ORDER BY

MapForce supports logical files of the IBM iSeries database and shows logical files as views

Support for IBM DB2 logical files. A logical file in IBM iSeries editions of the DB2 database represents one or more physical files. A logical file allows users to access data in a sequence or format that can be different from the physical file. Users who connect to IBM iSeries computers may encounter existing databases constructed with logical files. These were previously not accessible, but are now supported in Version 2012 Release 2.



New features in MapForce Version 2012 include:


Data streaming for XML, CSV and fixed-length field files (when using the built-in execution engine)

New database engine supports direct ODBC and JDBC connections

Auto-alignment of components in the mapping window

New functions: parse-date and parse-time

Find items in Project tab/window

Prompt to connect to target parent node

Specific rules governing the sequence that components are processed in a mapping



New features in MapForce Version 2011R3 include:


Intermediate variablesSupport for .NET Framework 4.0 assembly files

Ability to output StyleVision formatted documents from the command line



New features in MapForce Version 2011R2 include:


Built-in Execution Engine now supports streaming output

Find function capability in Libraries window

Reverse mapping

Extendable IF-ELSE function

Node Name and parsing functions in Core LibraryImproved database table actions dialog with integrated key generation settings

New option of using StyleVision Power Stylesheets when documenting a mapping



New features in MapForce Version 2011 include:


Ability to preview intermediate components in a mapping chain of two or more components connected to a target component (pass-through preview).

Formatting functions for dateTime and numbers for all supported languages

Enhancement to auto-number function

New timezone functions: remove-timezone and convert-to-utc

Ability to preview target components using StyleVision Power Stylesheets containing StyleVision Charts



New features in MapForce Version 2010 Release 3 include:


Support for generation of Visual Studio 2010 project files for C# and C++ added

Support for MSXML 6.0 in generated C++ code

Support for Nillable values, and xsi:nil attribute in XML instance files

Ability to disable automatic casting to target types in XML documents



New features in MapForce Version 2010 Release 2 include:


64-bit MapForce Enterprise / Professional editions on 64-bit operating systemsAutomatic connection of identical child connections when moving a parent connection

Support for fields in the SQL Where component

Ability to add compiled Java .class and .NET assembly files

Ability to tokenize input strings for further processing



New features in MapForce Version 2010 include:


Multiple input/output files per component

Upgraded relative path support

xsi:type support allowing use of derived types

New internal data type system

Improved user-defined function navigation (see Navigating User-Defined Functions)

Enhanced handling of mixed content in XML elements



New features in MapForce Version 2009 SP1 include:


Parameter order in user-defined functions can be user-defined (see Parameters in User-Defined Functions)

Ability to process XML files that are not valid against XML Schema

Regular (standard) user-defined functions now support complex hierarchical parameters (see Inline and Regular User-Defined Functions)

Apache Xerces 3.x support when generating C++ code



New features in MapForce Version 2009 include:


EDI HL7 versions 3.x XML as source and target components

Documentation of mapping projects

Native support for XML fields in SQL Server

Grouping of nodes or node content

Ability to filter data based on a nodes position in a sequence

QName support

Item/node search in components



New features in MapForce Version 2008 Release 2 include:


Ability to automatically generate XML Schemas for XML files

Support for stream objects as input/output in generated Java and C# code

Generation of Visual Studio 2008 project files for C++ and C#

Ability to strip database schema names from generated code

SQL SELECT Statements as virtual tables in database components

Local Relations - on-the-fly creation of primary/foreign key relationships

Support for Altova Global Resources

Performance optimizations



New features in MapForce Version 2008 include:


Aggregate functions

Value-Map lookup component

Enhanced XML output options: pretty print XML output, omit XML schema reference and Encoding settings for individual components

Various internal updates



New features in MapForce Version 2007 Release 3 include:


XML data mapping to/from database fields (see Mapping XML Data to / from Database Fields )

Direct querying of databases

SQL-WHERE filter and SQL statement wizard

Code generator optimization and improved documentation

© 2020 Altova GmbH