MapForce is a Windows-based, multi-purpose IDE (integrated development environment) that enables you to transform data from one format to another, or from. MapForce is a powerful visual mapping tool with a range of features and Complete the MapForce tutorial which can be found in the Altova MapForce User and. Find it here –> http://altova-mapforce-tutorials.

Author: Male Bashura
Country: Mauritania
Language: English (Spanish)
Genre: Art
Published (Last): 22 October 2015
Pages: 232
PDF File Size: 3.11 Mb
ePub File Size: 8.40 Mb
ISBN: 525-3-87879-463-3
Downloads: 17258
Price: Free* [*Free Regsitration Required]
Uploader: JoJojin

MapForce is a Windows-based, multi-purpose IDE integrated development environment that enables you to transform data from one format to another, or from one schema to another, by means of a visual, “drag-and-drop” -style graphical user interface that does not require writing any program code.

In fact, MapForce generates for you the program code which performs the actual data transformation or data mapping. When you prefer not to generate program code, you can just run the transformation using the MapForce built-in transformation language available in the MapForce Professional or Enterprise Editions.

Mappings designed with MapForce enable you to conveniently convert and transform data from and to a variety of file-based and other formats. Regardless of the technology you work with, MapForce determines automatically the structure of your data, or gives you the option to supply a schema for your data, or generate it automatically from a sample instance file.

For example, if you have an XML mapforcw file but no schema definition, MapForce can generate it for you, thus making the data inside the XML file available for mapping to other files or formats. Based on the MapForce edition, you can choose the preferred language for your data transformation as follows.

You can preview the result of all transformations, as well as the generated XSLT mapfore XQuery code without leaving the graphical user interface.

Note that, as you design or preview mappings, MapForce validates the integrity of your schemas or transformations and displays any validation errors in a dedicated window, so that mapfocre can immediately review and address them. For advanced data integration scenarios, you can also extend the generated program with your own code, using Altova libraries and the MapForce API. In MapForce, you design all mapping transformations visually.

For example, in case of XML, you can connect any element, attribute, or comment in an XML mapforcd to an element or attribute of another XML file, thus instructing MapForce to read data from the source element or attributeand write it to the target element or attribute. Sample data transformation between two XML files.


Likewise, when working with databases in MapForce Professional or Enterprise Editions, you can see any database column in the MapForce mapping area and map data to or from it by making visual connections.

Additionally, you can visually build Altovw queries, use stored procedures, or query a database directly support varies by database type, edition and mapfotce. Sample data transformation between an XML file and a database.

In a very simple scenario, a mapping design created with MapForce could be resumed as “read data from the source X and write it to target Y”.

However, you can easily design MapForce scenarios such as “read data from tutoorial source X and write it to target Y, and then read data from the source Y and write it to the target Z”. These are known as “pass-through”, or “chained” mappings, and enable you to access your data at an intermediary stage in the transformation process in order to save it to a file, for example.

Learn about the Mapping Tool

Note that the data mappings you can create in MapForce are not limited to single, predefined files. In the same transformation, you can process dynamically multiple input files from a directory and generate multiple output files.

Therefore, you can have scenarios such as “read data from multiple X files and write it to a single Y file”, or “read file X and generate multiple files Y”, and so on. Importantly, in the same transformation, you can mix multiple sources and multiple targets, which can be of any tutprial supported by your MapForce edition.

What Is MapForce?

For example, in case of MapForce Professional or Enterprise, this makes it possible to merge data from two different databases into a single XML file. Or, you can merge data from multiple XML files, and write some of the data to one database, and some of the data to another database. You can preview the SQL statements before committing them to the database.

Direct conversion of data from a source to a target is not typically the only thing you want to achieve. In many cases, you might want to process your data in a particular way for example, sort, group or filter it before it reaches the destination. On the other hand, MapForce includes rich and extensible function libraries which can assist you with virtually any kind of data manipulation.

When your data mapping design files become too many, you can organize them into mapping projects available in MapForce Professional and Enterprise edition.

tutoial This allows for easier access and management. Maapforce, you can generate program code from entire projects, in addition to generating code for individual mappings within the project. For advanced data processing needs such as when running mapping transformations with the MapForce Server APIyou can design a mapping so that you can pass values to it at run-time, or get a simple string value from it at run-time. This feature also enables you to quickly test the output of functions or entire mappings that produce a simple string value.


The Professional and Enterprise editions of MapForce also include components that enable you to perform run-time string parsing and serialization, similar to how this works in many other programming languages. You can also call and get data from a WSDL 1. Documentation design can be customized for example, you can choose to include or exclude specific components from the documentation. If you are using MapForce alongside other Altova MissionKit products, MapForce integrates with them as well as with the Altova server-based products, as shown in the following table.

You can run data transformations either directly in MapForce, or deploy them to altoova different machine and even operating system for command-line or automated execution.

Altova Online Training and Tutorials

More specifically, you can design mappings on Windows, and run them on a Windows, Linux, or Mac server machine which runs MapForce Server either standalone or under FlowForce Server management. MapForce Professional and Enterprise edition can be installed as a plug-in of Visual Studio and Eclipse integrated development environments. This way, you can design mappings and get access to MapForce functionality without leaving your preferred development environment.

In MapForce, you can completely customize not only the look and feel of the development environment graphical user interfacebut also various other settings pertaining to each technology and to each mapping component type, for example:. All editions of MapForce are available as a bit application. The MapForce Professional and Enterprise editions are additionally available as a bit application. The technologies supported as mapping sources or targets are as follows. You can also choose the encoding of the generated files for example, UTF Data from legacy text files can be mapped and converted to other formats with MapForce FlexText.

When mapping to or from databases, you can define settings such as the time-out period for executing database statements, whether MapForce should use database transactions, or whether it should strip the database schema name from table names when generating code.

Author: admin