|
| | | Database MappingAltova MapForce® 2008 includes powerful support for database mapping, including bi-directional mapping between any combination of database data and XML, flat files, EDI, Excel 2007, Web services, and even other database formats. Database Mapping MapForce is the first affordable, general purpose data integration and Web services implementation tool to support all major relational databases. Using MapForce, you can create graphical data mappings by simply dragging connecting lines between source data, data processing functions and filters, and target data structures. MapForce supports:
MapForce supports the following databases:
Developing Database Mappings MapForce 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.
Once you have loaded all of the content models required for your mapping, complete the mapping by simply dragging connecting lines between the source and target structures.
Filtering and Processing Data Most 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 data transformations on-the-fly for a multitude of real-world transformation requirements. You can, for example, construct 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 Actions When 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, Web services, or other database data through MapForce. Database Key Settings The 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 explicity defined in your database tables, MapForce allows you to define these relationships inline, without any affect on the source data.
Instant Data 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, while mappings to flat files have output in CSV or fixed-length text files, mappings to EDI produce either EDIFACT messages or X12 transaction sets, depending upon which standard you choose to work with, and mappings to Excel 2007 produce Office Open XML (OOXML) markup. Mappings to a database produce output in the form of SQL scripts (e.g., SELECT, INSERT, UPDATE, and DELETE statements), which can be edited on-the-fly and run against your target database directly from within MapForce. Learn more in the Output View section. Generating Program Code In addition to instant data 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. Learn more in the Code Generation section. Querying Database Data To complement its data conversion and database integration capabilities, MapForce includes the 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. Discover the power of MapForce® 2008 for querying, converting, and integrating database data. Download a free 30-day trial today! | |
| | |||||||||||||||||||||||||||||||||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | |||||
|
View a 
