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® 2017 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.
- Windows Server 2008 R2, Windows 7, 8, 10 or newer
- Linux (CentOS 6, RedHat 6, Debian 6, 8 & Ubuntu 12.04, 15 or newer)
- Mac OS X10.8 or newer
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.
API Code Examples
The documentation provided with the MapForce Server API contains code examples for C#, C++, Java, VBScript, and Visual Basic to help developers quickly access MapForce Server programmatically from .NET, Java, or COM-based code. The sample for C# is shown at left.
Complete documentation is available at the Altova Documentation page.
MapForce Server on the Altova Blog
Click the links below to read more about MapForce Server and FlowForce Server:
MapForce Server Accelerator Edition
MapForce Server Accelerator Edition is a high performance option for MapForce Server.
The MapForce Server Accelerator Edition contains several optimizations for high-performance server platforms, including multi-threading of execution of individual data mappings and optimization for execution of data mappings that include the MapForce join component. Our testing has shown some existing data mappings submitted by customers perform up to 70 times faster* when run by the MapForce Server Accelerator Edition.
MapForce Server Accelerator Edition is available for platforms with two or more CPU cores.
Data Challenges and the MapForce Platform for Data Integration
Download the whitepaper
* Performance results based on Altova internal tests. Your results may vary.