Altova MapForce Server is based on the built-in data transformation engine developed for MapForce and performs data transformations for any combination of XML, database, EDI, XBRL, flat file, Excel, JSON, and/or Web service using preprocessed and optimized data mappings stored in MapForce Server Execution files. Preprocessing enables faster performance and reduced memory footprint for most data mappings. MapForce Server operates under the management of FlowForce Server, in a standalone configuration executed from a command line, or programmatically via an API.
After a MapForce 2017 mapping is designed and tested, it can be executed on demand by MapForce Server to automate business processes that require repetitive data transformations.
MapForce and MapForce Server
After a MapForce 2016 mapping is designed and tested, it can be executed by MapForce Server to automate business processes that require repetitive data transformations.
MapForce pre-processes and optimizes data mappings, stores them in MapForce Server Execution files for command-line execution by MapForce Server, and uploads them for use in FlowForce Server jobs.
MapForce Server Supports Bulk Insert for Databases
Bulk Insert is an operation available for certain databases that allows a large volume of data to be inserted into a database table in a single SQL statement, as opposed to the typical method of using individual Insert statements for each row. Since processing overhead by the database engine is greatly reduced, performance is much faster. Testing MapForce Server with some examples has shown Bulk Insert can be more than 10 times faster than individual Insert statements.
Bulk Insert is also advantageous in multi-user environments. A long series of Insert commands transmitted to the database by one user could potentially be interrupted by another user sending a Select request to the same table, then the Insert sequence would continue. In a situation like this the Select operation would result in incomplete or invalid data.
API for Direct Execution
MapForce Server supports an API that allows direct native execution by programs written in C# and VB.NET in Windows, from other Windows apps via a COM interface, and from Java programs in Windows, Linux, and MacOS.
This API allows developers to incorporate MapForce Server functionality as a feature of their own applications. One use case could be for MapForce Server to transform data coming from an external source to a standard internal format before a developer manipulates it in his own program.
Data mappings for MapForce Server are created in Altova MapForce and saved as MapForce Server Execution files.
New in MapForce Server 2021:
- Support for SWIFT messages
- Ability to read/write binary files
- Support for SQL left outer join
- XBRL Taxonomy Manager
- Updated support for MariaDB
Please contact our sales team for 16, 24 and 32 CPU pricing.
Please contact our sales team for Mac and Linux downloads.