Please enable JavaScript to view this site.

Altova MapForce 2020 Enterprise 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.

In addition to generating Excel files from a mapping, MapForce now supports updating existing Excel files (when the transformation language is BUILT-IN). See Example: Updating Existing Excel Sheets.

Support for UN/EDIFACT D.19A and D19B Directories, see EDI.

When creating OAuth 2.0 credentials, you can configure the authorization details to be in the POST request body. This is an optional method in addition to the already supported standard method of supplying authorization details in the POST request header, see OAuth 2.0 Credentials.

Internal updates and optimizations

 

 

New in MapForce 2020:

 

It is now possible for mappings to call Web services that require OAuth 2.0 authorization.

HTTP or OAuth authentication details can be transferred to other execution environments with the help of credential objects, see Credentials.

Support for mapping data to or from JSON files using the JSON Lines text format

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.


Web service enhancements, including the following:

oAbility to map the HTTP status code returned by the Web service (applicable for RESTful Web services)

oAbility to supply the username, password, and URL of the Web service from the mapping (applies both to WSDL-style and RESTful Web services), see Web Service Call Settings

oAbility to create the raw body (MIME entity) of the Web service from the mapping, or map the raw body returned by the Web service call, with the help of new mime functions. Applicable for RESTful Web services.

oAbility to handle the Web service response conditionally, depending on the HTTP status code and content type (for RESTful Web services), see Handling the HTTP Response Conditionally.


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


Support for UN/EDIFACT D.18B Directory, see EDI.


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:

 


MapForce (and MapForce Server) can now map data to or from binary files in Protocol Buffers format, see Protocol Buffers.


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:

 


You can apply default values and functions not only to a single item, but also to multiple descendant items in a structure, without copy-pasting the function. This greatly simplifies the mapping and provides new ways to solve miscellaneous mapping requirements, see Defaults and Node Functions.


Mappings that include JSON components can be run not only by the BUILT-IN transformation engine, but also with generated code (C# and Java)


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:

 


When FlowForce Server Advanced Edition is licensed alongside MapForce and MapForce Server, you can create data workflows that automate the AS2 process, see AS2 Integration.


Support for NCPDP (National Council for Prescription Drug Programs) SCRIPT standard, see NCPDP SCRIPT.


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


When mapping data to Microsoft Excel, it is possible to add, directly from the mapping, new Excel columns in between existing columns, without redoing any existing connections, see Inserting Columns Between Existing Ones.


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.


Support is available for mapping data from JSON files which use JSON5 syntax. It is also possible to generate JSON5 files with unquoted object keys (see JSON5 Support).


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)


Support for XBRL taxonomy packages


Support for reading inline XBRL


Support for EDIFACT D.15B and D.16A directories (see EDI). The D.16A directory includes support for the Verification of Mass (VERMAS) message.


Validation of EDI messages can be customized through configuration files. This makes it possible to relax the validation rules when necessary or adapt to MapForce external code values referenced by the EDI standard (see Customizing EDI Validation Through Configuration Files).


Debugging of mappings is also available in the MapForce Plug-in for Visual Studio and MapForce Plug-in for Eclipse


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

You can call REST-style Web services from a mapping, see Adding a Web Service Call (REST-style). This adds to existing support for WSDL-style Web services.

Support for the EDIFACT 2015A directory (see EDI)

Support for Eclipse 4.5 (see MapForce Plug-in for Eclipse)

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:

 

Support for mapping data to or from TRADACOMS format

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

When calling Web services, you can use preemptive HTTP authentication, HTTPS, and basic WS-Security (see Setting HTTP Security and Setting WS-Security)

Support for reading Strict Open XML Excel 2013 files

FlexText split and switch using regular expressions (see FlexText and Regular Expressions)

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

XBRL table linkbase support

New mode for FlexText "Split Once" option: Delimited (line starts with)

Map to or from JSON files

 

 

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 and Web service calls

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 variables

Support for multiple row ranges in Excel components

Support for EDI X12 - HIPAA Implementation Guides

Generation of X12 EDI 999 Implementation Acknowledgement component

XML Digital signatures

Support for US-GAAP 2011

Support 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 Library

New EDI format IATA PADIS

Ability to process multiple EDI messages per component

Improved 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

Ability to define a worksheet row as column names in an Excel component

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

Support for SAP IDocs

 

 

New features in MapForce Version 2010 Release 2 include:

 

64-bit MapForce Enterprise / Professional editions on 64-bit operating systems

Support for Excel 2010

Automatic 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

UN/EDIFACT and ANSI X12 EDI source file validation

Generation of X12 EDI 997 Functional Acknowledgement component

 

 

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)

Validation of EDI output in generated code (see EDI Component Validation)

Support of EDIFACT service messages CONTRL, AUTACK and KEYMAN

Support for Web services defined using WSDL 2.0

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:

 

Support for XBRL and XBRL dimension instance files, as well as XBRL taxonomies as source and target components

EDI HL7 versions 2.2 to 2.6 components as source and target components

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

Office Open XML Excel 2007 and higher (*.xslx) support as source and target components

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

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

Support for SOAP version 1.2 in Web services

New Repeated split option "Starts with..." in FlexText

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

Full support for all EDI X12 releases from 3040 to 5030

Full support for UN/EDIFACT messages of directories 93A to 06B

© 2020 Altova GmbH