Database to XML Conversion in MapForce
Learn how to map data to convert between databases and XML. MapForce supports all popular SQL and No SQL databases for integration with PDF, XML, JSON, CSV, and other formats.
The MapForce database connection wizard makes it easy to connect to the desired database and select the tables required for the data mapping project. The database structure is displayed visually, with table relations indicated via arrows and levels of indentation.
The structure of the XSD target is reflected similarly. To connect associated source and target nodes, we simply drag and drop. Then, we'll use built in filters and functions to fine tune the data transformation and calculate values.
This video also explores the MapForce DB Query window, which lets you explore and even edit the data in the connected database. The intelligent SQL editor makes it easy.
Access sample database to XML projects and try this functionality for yourself with a free, 30-day trial of Altova MapForce: https://www.altova.com/mapforce
Read more about database mapping and transformation: https://www.altova.com/mapforce/datab...
