|
| | | Database MappingAltova MapForce® 2010 includes powerful support for database mapping, including mapping between of database data and XML, flat files, EDI, Excel 2007+, XBRL, Web services, and even other database formats. MapForce is the first affordable, general purpose data mapping and Web services implementation tool to support all major relational databases. Using MapForce, you can create graphical database mapping designs by simply dragging connecting lines between source data, data processing functions and filters, and target data structures.
MapForce supports the following databases:
Developing Database MappingsMapForce supports databases as the source and/or target of any mapping. 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.
After you have confirmed your selection, MapForce displays all chosen top-level and related tables in a hierarchical tree structure.
MapForce also allows you to connect to and map XML data stored in relational database fields (currently supported for SQL Server & IBM DB2). You simply assign an XML Schema – either one registered in the database or one from your local file system – to the field, and MapForce renders the schema as a sub-tree of the database field for mapping purposes.
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. Filtering and Processing Database DataMost database mappings involve the use of data processing functions to filter data based on Boolean conditions or SQL and SQL/XML statements, or manipulate data between the source and target. For example, you might want 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 in between the lines joining the source and the target data model. MapForce provides advanced support for SQL SELECT and WHERE statements, allowing you to insert mapping components based on these operators. 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. Learn more in the Data Processing Functions section. Database Table ActionsWhen you are mapping to a database, MapForce allows you to select database table actions to control how data is written to the database. This gives you full flexibility to automate the most advanced data management tasks. The easy-to-use Database Table Actions dialog box allows you to define the columns within the selected table to be used to determine what action (INSERT, UPDATE, DELETE) should be executed in the database.
This provides unprecedented flexibility in manipulating database rows in response to XML, flat file, EDI, Excel 2007+, XBRL, Web services, or other database data through MapForce. Database Key SettingsThe MapForce database key settings allow you to customize how primary and foreign key values will be added to a database. You can either provide values for keys from within MapForce, or you can let the database system handle the generation of auto-values. In situations when primary and/or foreign key relationships are not explicitly defined in your database tables, MapForce allows you to define these relationships inline, without any affect on the source data.
Querying Database DataTo complement its database mapping and integration capabilities, MapForce includes a powerful Database Query tab for performing direct database queries. When you connect to a database using the Database Query tab, MapForce displays its tables in a hierarchical tree in the browser pane. You can then use the SQL editor tab to display, edit, and execute SQL or SQL/XML statements, either by opening existing SQL files or creating SQL statements from scratch using drag and drop and auto-complete functionality.
You can execute your SQL script and view the results in tabular form and save both the retrieved data and the SQL script individually to separate files. Instant Database ConversionOnce 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 2007+ 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 can be edited on-the-fly and run against your target database directly from within MapForce. Learn more in the Output View section. Automating Database MappingsIn addition to instant database conversions, you can autogenerate the software program code required to marshal data from the source to the target content model for use in your own software, such as a customized server-side data integration or Web services application. Program code can be generated in Java, C++ or C# and can easily be used - royalty-free - in any software application. MapForce also supports data mapping automation through the command line. Learn more in the Automate Data Integration section. Discover the power of MapForce® 2010 for querying, converting, and mapping database data. Download a free 30-day trial of MapForce. | |
| | |||||||||||||||||||||||||||||||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||
|
Read this 
