How to Convert Data in MapForce [Video]
Altova MapForce offers a powerful, yet easy-to-use, approach to converting and transforming data. Whether you need to write XML to a database, convert JSON to EDI, or map Excel to multiple different data formats, MapForce has you covered.
From simple one-to-one conversions to complex ETL scenarios, the MapForce approach is to represent data structures as graphical components. To associate fields, drag and drop connecting lines. A comprehensive library of data filters and functions is available for transforming data before writing it to the target.
We have recently revamped our series of Introduction to MapForce videos. Each short how-to gives a demo of a common MapForce scenario.
Start at the beginning to learn how MapForce works:
And follow along to learn:
An overview of MapForce features and functionality
How data transformation works
XML to XML transformation
Database to XML mapping (including filters and querying the database)
Mapping XML to databases (including database table actions)
One-to-many data integration (featuring Excel to JSON and XML and value-map functions)
Chained data transformation (including if-else conditions and data sorting functions)
Batch-to-batch mapping using wildcards & dynamic file names
Batch-to-one mapping to merge files
Node functions and defaults to apply the same processing logic to multiple nodes at once
And, check out our series of videos on implementing ETL processes:
You can follow along with the examples in these how-to videos by downloading a free, 30-day trial of MapForce. Check back for new MapForce videos, which are added often.