Database Mapping
Database Mapping Features:
- Database queries on all major databases
- Mapping data from any supported database type to any other
- Specify database key settings
- Define database table actions
- Query databases directly
- Connect to and map XML in database fields
- Sort database input components
Developing Database Mappings
Altova MapForce® 2013 includes powerful support for database mapping, including mapping between any of database data and XML, flat files, EDI, Excel (OOXML), XBRL, Web services, and even other database formats.
When you load a database structure in the design window, MapForce automatically interprets the database schema, lets you pick available database tables and views, and recognizes table relationships.
Once you have loaded all of the content models required for your database mapping, complete the mapping by simply dragging connecting lines between the source and target structures.
MapForce supports all major relational databases, empowering you to create graphical database mapping designs between database source data, data processing functions and filters, and other data structures of various types.
Filtering and Processing Database Data
Many database mappings require manipulation of data between the source and target based on Boolean conditions or SQL and SQL/XML statements. You may need to perform logical comparisons, mathematical computations, or string operations, check for database data of a particular value, and make other modifications to the data. In screenshot above, data processing functions appear as the boxes between the lines joining the source and the target data model.
Data processing functions enable you perform advanced database mappings on-the-fly for a multitude of real-world transformation requirements. You can, for example, construct database mappings that use XML or EDI messages to extract database rows based on filter criteria from the XML or EDI elements.
Instant Database Conversion
Once your mapping is defined, the built-in MapForce Engine allows you to view and save the results with one click.
Database-to-XML mappings produce an XML output document, database mappings to flat files have output in CSV or fixed-length text files, mappings of databases to EDI can produce EDIFACT, X12, or HL7 messages, database mappings to Excel produce Office Open XML (OOXML) markup, and mappings to XBRL produce XBRL financial reports.
Mappings to a database produce output in the form of SQL scripts (e.g., SELECT, INSERT, UPDATE, and DELETE statements) that are run against your target database directly from within MapForce.
Supported Databases:
- Microsoft® SQL Server® 2000, 2005, 2008, 2012
- IBM DB2® 8, 9, 9.5, 9.7, 10.1
- IBM DB2 for iSeries® v5.4, 6.1
- Oracle® 9i, 10g, 11g
- Sybase® 12
- Sybase ASE (Adaptive Server Enterprise) 15, 15.7
- MySQL® 4, 5, 5.5.28
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1
- Microsoft Access™ 2003, 2007, 2010, 2013
- Informix 11.70
