Note: must be installed on a machine with at least 2 CPU cores available. Provides license management for Altova server and desktop products. To aid those deploying Altova Server Software products in the cloud, a free Azure virtual machine template is available in the Azure Marketplace.
This template installs the complete line of Altova server software products, including MapForce Server and the free LicenseServer, on the VM that you specify in the Azure cloud. Once you install the template, activate the desired products using the installed Altova LicenseServer to either request free, day trial s or upload purchased licenses. Networking Software.
Trending from CNET. Download Now. Developer's Description By Altova. Full Specifications. What's new in version sp1. Version sp1 may include unspecified updates, enhancements, or bug fixes. Release December 17, Date Added December 17, Version sp1. Operating Systems. Additional Requirements None. Total Downloads 13, Downloads Last Week 0. Report Software. Download MapForce Libraries.
XBRL Taxonomies. Previous Releases of MapForce. Software Release r3 r2sp1 r2 r2sp1 r2 sp1 r3sp1 r3 sp2 sp1 r2sp1 r2 sp1 r3sp1 r3 sp2 sp1 r2sp1 r2 sp1 r4sp1 r4 r3sp1 r3 sp2 sp1 r2sp1 r2 sp1 r2sp2 r2sp1 r2 sp1 r2sp1 r2 sp1 r3sp1 r3 r2sp1 r2 sp1 r3sp1 r3 r2 sp1 r2 sp1 r3 sp1 r3sp1 r3 sp2 sp1 r1 r3 sp2 sp1 r3 r2. Free Trial Evaluation Information. Company News Partners Careers Legal. Aggregate functions allow you to perform computations on groups of data, including count, sum, min, average, join-string, and others.
Conversion functions are provided to conveniently parse complex data types. Functions in the core library are generalized and not specific to any type of output. Using these core functions, you can create XSLT 1. Intermediate variables are a special type of component that store an intermediate mapping result for further processing and can be used to solve various advanced mapping problems.
An intermediate variable is equivalent to a regular non-inline user-defined function, and is a structural component without an instance file.
Inserting filters and conditions into a mapping allows you to select data from the source based on Boolean conditions. The if-else condition in MapForce is equivalent to a switch statement in many programming languages, enabling you to easily control the flow of data in your mapping projects by matching a value to a selected criterion.
MapForce supports transformation input parameters, allowing outside parameters to affect mapping transformations. Node functions and defaults are applied at the node level and may apply to one or multiple nodes at once. You can define a node function or default value for an input or output mapping component, and you can optionally propagate the function or default to some or all children of the node. MapForce includes a highly flexible, easy-to-use Manage Libraries window that lets you import user defined functions and custom libraries, both globally and specific to a particular mapping project.
This way, when a developer sends 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, simply copy and paste user-defined functions from one mapping to another as needed. When mapping to a database, the output preview displays the SQL commands that would be executed against the database as a result of your mapping.
The MapForce Engine also allows you to actually run the SQL script to execute the transformation and make the changes to the database.
If you choose to provide sample data, MapForce allows you to easily preview the results of a sample transformation as you are working by clicking on the Output tab at the bottom of the main design window. This helps to ensure that your data mapping achieves the desired result.
Check out our blog for helpful tips, tricks, and how-tos for MapForce. MapForce includes a revolutionary interactive debugger to assist with data mapping design. The debugger allows users to single step through a mapping and see the data actually flow from the sources to the target nodes step by step along the way. The MapForce debugger is supported with menu commands, a special toolbar, and helper windows that are opened automatically while the debugger is running, so users can trace the intermediate processing operations and examine data values during mapping execution.
The MapForce data mapping debugger provides deep insight into the exact inner workings of data integration and ETL projects in a way that was never possible before, not even in much higher-cost mapping products. The MapForce debugger supports breakpoint and stepping functionality that will be familiar to developers experienced at debugging source code. Breakpoints can be placed on any input or output node, to pause mapping execution at that point, and conditional breakpoints are supported.
Several commands enable stepping with various levels of granularity to manually debug a data mapping or continue execution after a breakpoint is reached, allowing users to view as much detail as they need. Take a more in depth look at the MapForce debugger in this tutorial on validating data transformations.
After a project is designed and tested in the data mapping tool, it can be executed by MapForce Server to automate business processes that require repetitive data transformations. File names that may be defined as data mapping inputs and outputs, or database queries included in the mapping, can be replaced by job parameters at runtime for execution by MapForce Server.
To develop an XML mapping , simply load two or more schemas into MapForce and drag connecting lines between the nodes of the source and target. Mixed content support even enables you to map text data that is interspersed with XML. Once you have finished defining your XML mapping and data processing rules, you can load a source file, and the MapForce Built-In Execution Engine will instantly convert the data into the new format.
This is known as an XML wildcard and it is a popular mechanism used to allow a degree of customization in many XML Schemas that support industry standards across a wide variety of businesses. You can also click the Output tab to view the actual output generated by your XML mapping. As shown below, JSON components are displayed with appropriate element syntax and their data types are clearly indicated. In such cases, the MapForce component displays separate structure nodes for all basic types that can occur at that location.
If an array has different types of items in the JSON schema for example, both strings and numbers , MapForce displays an "item" node for each item type.
0コメント