Data Integration

Altova MapForce excels at connecting and transforming data across a wide range of databases, making it a powerful tool for data integration projects of all sizes. It supports popular relational databases such as SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2, and more. With MapForce’s graphical interface, you can simply drag-and-drop mappings between tables and columns, visually designing how data should flow and transform between sources and targets. It even provides user-friendly features for merging multiple data inputs into a single output, helping you streamline the development process.

Beyond basic mapping, MapForce offers robust functions and filters that can be inserted to handle data transformations on the fly—things like joining data from various tables, filtering records based on dynamic criteria, or converting data types automatically.

Here is a selection of blog posts about data integration:

Posts categorized: data-integration

CbC Reporting Made Easy (May 22, 2025)
How to Create Batch Data Mapping Projects (May 15, 2025)
OpenAPI Tools for Developers (April 15, 2025)
Updating Shopify Inventory from a Mobile App (April 01, 2025)
Exporting Products from Shopify as CSV (March 28, 2025)
New Tools for Shopify, OpenAPI, & More (March 25, 2025)
ETL Tutorial: Video (February 05, 2025)
What is ETL? (February 05, 2025)
ETL Basics: CSV to Database in MapForce (January 28, 2025)
Text Search for Precise PDF Data Extraction (December 03, 2024)
Altova Version 2025 with YAML Grid and More (October 22, 2024)
Run Altova Server Software on Azure Cloud (October 20, 2024)
Mapping Structured Data with Enhanced Node Functions (May 03, 2024)
Extract Data for PDF Mapping (November 06, 2023)
AI Integration & PDF Data Mapping in Version 2024 (October 24, 2023)
AI-based Database Image Classification with Altova MapForce (July 31, 2023)
AI-based Database Image Classification with Altova MapForce (July 31, 2023)
AI-based support request sentiment analysis using MapForce and GPT-4 (July 17, 2023)
How to Create a Chained Data Transformation (July 05, 2023)
How to Convert Data in MapForce [Video] (June 06, 2023)
Drive VDA EDI Conversion and Transformation with MapForce (May 03, 2023)
Split Mode in Grid View and More in v2023r2 (April 12, 2023)
Validating and Debugging Data Transformations (November 30, 2022)
Dark Mode and Much More in Version 2023 (October 19, 2022)
Automatically Convert EDI to XML (May 18, 2022)
How to Compare CSV Files or Compare a CSV File to a Database Table (May 04, 2022)
MapForce Data Mapping Tutorial (Video) (April 04, 2022)
Transforming and Converting Protobuf (February 10, 2022)
Transforming and Converting Protobuf (February 10, 2022)
Excel Data Mapping to Update Existing Documents (February 02, 2022)
Data Mapping NoSQL Databases (November 26, 2021)
API Data Mapping (April 30, 2021)
How to View Workflow Automation Reports on FlowForce Server (April 28, 2021)
Data Mapping with XSLT3 Math Functions (April 14, 2021)
Data Mapping Binary Objects – Part 2 (October 30, 2020)
Data Mapping Binary Objects (October 21, 2020)
Web Service Data Integration (May 11, 2020)
New Data Integration Tools (March 25, 2020)
How to Convert Legacy Text Files [Video] (March 11, 2020)
Data Mapping JSON Lines (February 24, 2020)
Data Mapping JSON Lines (February 24, 2020)
Transitioning Data Mapping Projects from Development through Testing and Production (November 29, 2019)
Handle HTTP Errors During Automated Data Integration (July 29, 2019)
Handling HTTP Errors in Web Service Data Mappings (June 19, 2019)
Database Mapping with Database Exception Handling (June 05, 2019)
Database Mapping with Database Exception Handling (June 05, 2019)
Database Tracing to Log Changes Made by a Data Mapping Project (May 01, 2019)
Database Tracing to Log Changes Made by a Data Mapping Project (May 01, 2019)
Updated JSON Schema Support Highlights v2019 Release 3 (April 02, 2019)
Job Distribution on FlowForce Server (November 28, 2018)
Node Functions Simplify Mapping Hierarchical Data Structures (June 12, 2018)
Data Mapping NCPDP SCRIPT (October 11, 2017)
MapForce Server Accelerator Edition Achieves a New Level of Data Transformation Performance (May 23, 2017)
Use Join to Integrate Data in Any Format (April 18, 2017)
A Typical MapForce Server Use Case (March 02, 2017)
JSON Data Mapping and Transformation with MapForce (February 15, 2017)
EDI Data Mapping with MapForce (November 15, 2016)
MapForce Supports SQL Merge When It’s the Right Tool for the Job (November 01, 2016)
MapForce Offers Dynamic Access to Node Names (October 13, 2016)
Faster EDI Data Translation (March 07, 2016)
XBRL Data Mapping: WIP Taxonomy (March 02, 2016)
Data Mapping REST Web Services (February 24, 2016)
Using Google Cloud SQL (January 06, 2016)
Applying Data Mapping Patterns (December 28, 2015)
Interactive Debugger for Data Integration Projects (October 14, 2015)
New JSON Schema Editor and Data Mapping Debugger Debut in Altova Version 2016 (September 25, 2015)
Data Mapping Files with XML Mixed Content (September 08, 2015)
Manipulating Data in Cross-Platform Mobile Applications (July 09, 2015)
New Data Integration Whitepaper Now Available (December 22, 2014)
Data Integration for Mobile Devices – MobileTogether Works with FlowForce Server (November 20, 2014)
Automating Data Integration Workflows – Download the E-Book (August 19, 2014)
FlowForce Server Job Cache Enhancements (May 06, 2014)
Deploy Data Mappings and Report Designs for Automated Processing (March 04, 2014)
XML Wildcard Data Mapping and Transformation in MapForce (December 17, 2013)
Result Caching Accelerates Application Response Time (November 25, 2013)
FlowForce Server Jobs as HTTP Services (October 21, 2013)
Use XPath Expressions to Refine Data Selection (September 12, 2013)
Filesystem Commands and More Wizardry with FlowForce Server Built-in Functions (August 13, 2013)
Constant Quest for Efficiency (July 30, 2013)
Download Example Files for FlowForce Server, MapForce, and StyleVision (June 25, 2013)
Taming Bad Input Data with FlowForce Server (June 18, 2013)
Customizing a FlowForce Server Job (May 21, 2013)
Automate Data Mapping and Transformation with FlowForce Server (May 08, 2013)
New Server Products for Data Transformation (April 29, 2013)
Automate Data Transformation with FlowForce Server (February 05, 2013)
Process Multiple Input Files in a Single Data Mapping (January 29, 2013)
Stored Procedures in Database Mappings (September 25, 2012)
Web Service as a Look-Up Table to Refine GPS Data (June 20, 2012)
New Case Study: Automating XBRL Data Collection and Processing (May 22, 2012)
Resist Data Integration Redundancy (April 30, 2012)
Data Exchange for the Mobile Workforce (February 01, 2012)
Processing the Groupon API – Epilogue (November 28, 2011)
XML Development with Database Integration (October 06, 2011)
Leverage Your Financial Data with the XBRL Chart Wizard–Part 1 (September 13, 2011)
Processing the Groupon API with MapForce – Part 2 (August 16, 2011)
Processing the Groupon API with Altova MapForce (August 02, 2011)
Switch Statement vs. Look-up Table in MapForce (May 17, 2011)
Expandable If-Else Works like a Switch Statement in MapForce (April 26, 2011)
MapForce Japanese Version - 日本語版 MapForce (June 04, 2010)
Altova MapForce Brings Powerful Data Transformation Capabilities to Quark Dynamic Publishing Solution (April 28, 2010)
New MapForce Online Training (March 15, 2010)
HL7 and XML Healthcare Data Integration at HIMSS10 (February 25, 2010)
MapForce v2010r2 New Features (February 19, 2010)
MapForce v2010 - “Most Wanted” (November 10, 2009)
HubKey Case Study (September 28, 2009)
New Data Mapping Demo Video Released (June 24, 2009)
SOA and Cloud Services Within Your Budget (March 26, 2009)
What's New in MapForce 2009? (March 05, 2009)
HL7 Data Integration (February 26, 2009)
New MapForce Online Training - Code Generation (January 09, 2009)
MapForce data mapping tool now supports Excel 2007/OOXML mapping (June 03, 2008)
Case Study: MapForce EDI Conversion Optimizes Business Transactions (May 27, 2008)
LANSA OEMs MapForce to Convert Data in Business Process Integration App (March 24, 2008)