Mapping Database Objects to an XML Schema Via the XML Builder Wizard

You can create an XSM to generate an annotated schema from a PDM via the XML Builder.

1. Open a PDM targeted with the appropriate DBMS, and select Tools > XML Builder Wizard to open the XML Builder Wizard.
2. Specify whether to create a new XML model or work with an existing model, and then click Next to go to the Tables and Views Selection page.
3. Select the tables and views from which you want to generate the schema, and then click Next to go to the XML Hierarchy Design page.
4. Build your hierarchy by dragging and dropping tables and/or columns from the left pane to the right pane or by using the tools above the panes:
   
   
   

   For detailed information about using the wizard, see Data Modeling > Working with Data Models > Generating Other Models from a Data Model > Generating Other Models from a PDM > Generating an XSM from a PDM via the XML Builder Wizard.

5. Click Finish to generate the XML model:
   
   
   

   In the case of an existing XML model, the generated elements appear alongside the existing elements.

   Note: The SQL/XML extension file is automatically attached to the generated XML model. You can optionally attach the XML Document extension file to generate a simplified XML file that will help you understand the annotated schema (see Extending your Modeling Environment).