Mapping XML data to databases
|
| Previous Top Next |
Mapping XML data to databases |
MapForce allows you to not only map database data to XML documents, but you can do the reverse as well, map XML data to databases and even create mappings between databases! MapForce takes primary and foreign key constraints into account and also generates transaction data which ensure data integrity.
Database functions (table actions) supported by MapForce:
| • | Insert |
| • | Update |
| • | Delete |
| • | Database key field handling |
Examples for each of these table actions follow, and are of a simple nature to get you acquainted with how to achieve the specific goals.
Currently supported databases (and connection types) are:
| • | Microsoft Access versions 2003 / 2007 |
| • | Microsoft SQL Server versions 2000 and 2005 |
| • | Oracle version version 9i and 10g |
| • | MySQL 4.x and 5.x |
| • | Sybase 12 |
| • | IBM DB2 version 8.x und 9 |
| • | IBM DB2 for iSeries v4 |
| • | IBM zSeries for DB2 8 and greater |
Please note:
MapForce fully supports the databases listed above. While Altova endeavors to support other ODBC/ADO databases, successful connection and data processing have only been tested with the listed databases.
Files used in this section:
|
Altova_Hierarchical.xsd |
the hierarchical schema file, containing identity constraints |
|
Altova-cmpy.xml |
the Altova company data file which supplies the XML data |
|
Altova.mdb |
the Altova MS-Access database file, which functions as the target database |
|
All these example files are available in the C:\Documents and Settings\<username>\My Documents\Altova\MapForce2008\MapForceExamples folder |
|
Please note:
This section makes heavy use of the Altova.mdb database, to show the database-as-target functionality of MapForce. Make sure you backup the file before you try any of the examples shown here.
MapForce is able to map from password protected Access files, if they are added via the Any ODBC option in the "Select a source database" dialog box. The user and password settings can then be entered in the wizard.
|