Generating an XML model via the XML Builder Wizard

Chapter 9 Generating Other Models from a PDM

Generating an XML model via the XML Builder Wizard

The XML Builder Wizard helps you build an XML model that will be used to generate SQL/XML queries for retrieving data from databases. Unlike the standard PDM to XML model generation, the XML Builder Wizard facilitates the next operations:

You can build your own hierarchy of elements and attributes from tables, views and columns
A SQL/XML extended model definition is automatically attached to the generated XML model, therefore you can generate SQL/XML queries from global elements, to retrieve data from relational databases supporting SQL/XML (See Generating SQL/XML queries)
The generated XML model is automatically mapped to the PDM. By attaching the appropriate extended model definition to the generated XML model, you can generate an annotated schema to store or retrieve data in an XML format, from relational databases supporting XML (See Generating annotated schemas)

During the XML Builder Wizard process, you can perform the following actions:

Generate columns as elements or attributes
Generate tables and views as elements by drag and drop or using the contextual menu
Display tables, views or columns property sheets
Add Sequence, Choice or All group particles
Rename elements or attributes
Add new elements or attributes without mapping
Delete elements, attributes or group particles

To generate an XML model via the XML Builder Wizard:

Select Tools→XML Builder Wizard.

Select generation options and click Next in each page of the wizard.

Click Finish.

The different actions of the wizard are detailed in the following sections.

WARNING!

Caution
The following sections assume you have a PDM open in the workspace. If you choose to work with an existing XML model, it must also be open in the workspace.