Data Integration

Mapping data to and from Excel files in Altova MapForce

MapForce Data Conversion:

  • Map data to and from all popular databases
  • Data mapping debugger gives deep insight into the exact inner workings of data integration projects
  • Map XML, JSON, flat files, EDI, Excel, XBRL, & Web services
  • Map data from Web Services with parameters and authentication
  • Data processing functions convert data on the fly
  • Process data from/into multiple files
  • Direct file input and output (data streaming)
  • Data mapping automation through MapForce Server, scripting, or royalty-free code generation

Download Trial

Simplified Data Integration

Altova MapForce is an advanced data integration application with support for integrating data with virtually any formats including XML, JSON, databases, flat files, EDI, Excel, XBRL, and Web services. With additional support for automating data integration, MapForce is an ideal middleware product for connecting distributed applications in any enterprise, Web-based, or even Cloud architecture.

The data integration process can often seem overwhelming, and this is often compounded by the vast number of large-scale, complex, and costly enterprise integration applications available on the market. MapForce alleviates this burden with powerful data integration capabilities built into a straightforward graphical user interface.

MapForce allows you to easily associate target and source data structures using drag and drop functionality.

Re-usable Data Mappings

Whether it is an XML or database schema, EDI configuration file, or XBRL taxonomy and beyond, MapForce integrates data based on data structures regardless of the underlying content. This means that you can re-use your data integration mappings again and again as your business data changes.

If you need to make changes to your mapping along the way – to accommodate for underlying schema changes, for instance – MapForce offers a variety of automation features that help ease this process. For example, when you re-map a parent element, you have an option to automatically reassign child elements or other descendant connections accordingly.

Automated Data Integration

For XML mappings, MapForce automatically generates data integration code on-the-fly in XSLT 1.0/2.0 or XQuery, based on your selection.

MapForce can also generate royalty-free data integration code in Java, C#, or C++ for your data mappings. This enables you to implement scheduled or event-triggered data integration/migration operations for inclusion in any reporting, e-commerce, or SOA-based applications.

Another option is FlowForce Server, an exciting new server product from Altova designed to provide a robust environment to automate the execution of MapForce data transformations and other tasks on dedicated servers, virtual machines, or even desktop workstations.

MapForce data integration operations can also be automated via data integration API, ActiveX control, or the command line.

Data mapping automation with Altova MapForce and FlowForce

Data Manipulation

Data integration projects often require data manipulation to convert input data before it is consumed by the target system. MapForce provides an intuitive visual function builder, fully scalable data processing functions with built-in libraries, filters and conditions, and more, to empower you to easily manipulate data and integrate disparate formats.

Data mapping functions in Altova MapForce

Data Mapping Web Services

MapForce supports calling SOAP and REST Web services directly from within a mapping. You can insert a Web service call into a mapping and supply input parameters and username/password or other authentication. Connect output components to the Web service to pass the result to another component or write it to a file.

MapForce also supports generic HTTP Web services that typically carry custom request or response structures in the message body. MapForce supports both JSON or XML data in the request or response body, allowing you to call virtually any HTTP Web service that requires or returns XML or JSON structures.

Manual definition of settings in the Web Service Call definition dialog allows developers to define settings based on a template URL. This is a convenient step when developers test and refine Web service calls in a Web browser window, since they can copy the URL from the browser to become the template.

MapForce Web service data mapping dialog

WSDL Mapping

MapForce connects to WSDL 1.1 or 2.0-based Web services to integrate their functionality in mappings with any other supported data. You can insert a Web service as a look-up function, source, or target.

During execution, MapForce connects to the service and displays the results in the Output window. You can also generate Java or C# code to implement the mapping.

Legacy Data Integration

As technology rapidly advances, organizations are often left burdened with legacy data repositories that are no longer supported, making the data difficult to access and impossible to edit in its native format. MapForce provides the unique FlexText utility for parsing flat file output so that it can easily be integrated with any other target structure.

FlexText enables you to create reusable legacy data integration templates for mapping flat files to modern data formats like XML, JSON, databases, Excel, XBRL, Web services, and more.

In addition, legacy data formats like EDI can easily be integrated with modern accounting systems like ERP and relational databases, or even translated to modern formats like XML.

"We evaluated Altova MapForce against all the major data integration applications in the industry and found it to be the most powerful and easiest to use by far."

Mark Beede
Senior J2EE Consultant for HealthTrans

Using a Web service as a data processing lookup function in Altova MapForce