Setup of XML to database mapping
|
| Previous Top Next |
Setup of XML to database mapping |
Setting up an XML to database mapping, is in no way different from the methods previously described.
| 1. | Click the Insert Schema | XML instance icon, and select the Altova_Hierarchical.xsd. |
| 2. | Select the Altova-cmpy.xml file as the XML instance file. Click the Altova entry, and hit the * key on the numeric keypad to view the items; resize the component if necessary. |
| 3. | Click the Insert Database icon, select the Microsoft Access (ADO) entry and click Next. |
| 4. | Click the C++ icon in the title bar to specify the language the generated code should support. This setting also loads the language related library into the Libraries window. |
| 5. | Click the Browse button to select the altova.mdb database available from the C:\Documents and Settings\<username>\My Documents\Altova\MapForce2008\MapForceExamples\Tutorial\ folder, and click Next. |
This dialog box allows you to define the specific Tables, Views or System tables that you want to appear in the Database component.
| 6. | Click the check box to the left of User Tables to select them all, and click OK to insert the database. |
| 7. | Click the + expand icon of the Altova item, to display the Altova table fields. |
Please note:
Creating mappings between database components is not possible if you select XSLT, XSLT2, or XQuery as the target language. XSLT does not support database queries.
Database settings can be changed by right clicking the database and selecting:
| • | Add/Remove tables, allows you to add or delete tables to/from the current component |
| • | Component settings, allows you to change the component database by clicking the Change button, and using the wizard to select a different database. |
|