## XML Connection Wizard

This wizard appears when you select XML Connection and click OK in the New Data Source dialog or right-click the Relational node and select Add XML Connection from the shortcut menu. It helps you to import an XML schema and transform it to a relational schema for future use, and consists of the following windows:

- Import XML Schema window
- Modify Schema Properties window
- Transform XML Schema window
- Transformed Relational Schema window
- Add Table window

Back

Goes back to the previous window.

Next

Goes to the next window.

Finish

Finishes confirming to transform an XML schema to a relational schema.

Cancel

Does not retain changes and closes this wizard.

Help

Displays this help document.

### Import XML Schema window

Specifies the necessary information to import XML schema. See the window.

Schema Type

Specifies the type to import XML schema. You can import from XSD or parse from an XML instance.

Schema Name

Specifies the schema file by clicking the Browse button or inputting the URI string directly in the text box.

Starting Node

Specifies the starting node, according to the root name in the XML source.

Notes:

- If a value of DateTime data type is accurate to millisecond, a message - Invalid Value will still pop-up although the value is valid according to the W3C standard. If that, ignore the error message and continue the transformation steps.
- If you select to create a parameter and then dynamically specify an XML instance at runtime, the XML instance will be validated at runtime rather than in the importing process.

Instance

Specifies the XML instance. It should match with the selected XSD schema.

These two operations below are available only when you select Import from XSD from the Schema Type drop-down list.

- URI
  If selected, specify an XML file for the XSD by clicking the Browse button or input the URI string directly in the text box.
- Parameter
  If selected, click to open the Create Parameter dialog to create a parameter and then dynamically specify an XML instance that matches with the selected XSD schema at runtime.

Validate with schema before fetching

If selected, JReport Designer will validate whether or not values in the XML instance is valid according to the W3C standard and the specified XSD schema. If not, a message - Invalid Value will pop-up.

Time Zone and Locale

Opens the Time Zone and Locale Options dialog to specify the default time zone and locale for the XML instance.

### Modify Schema Properties window

Specifies properties of the XML schema. See the window.

Schema

Lists the corresponding schema structure of the root. stands for elements, stands for the attributes in the XML schema and stands for the references of elements.

Properties

Lists all the properties of the selected elements and attributes in the schema.

- Name
  Displays names of properties of the selected elements or attributes.
- Value
  Specifies values of properties for the selected elements or attributes.

Note: When the property Data Type is specified as Date, Time or DateTime, you can specify the Format Pattern for them to make values of the Data Type display as required. (For details about these properties, see the section Supplementing information for the XML schema).

### Transform XML Schema window

This window allows you to specify an XPath as a transforming start point. All the elements matching with the selected XPath and their attributes will be transformed to the relational schema. See the window.

### Transformed Relational Schema window

This window lists the transformed relational schema structure. It helps you to click Next to confirm the transformation results and go into the Add Table window. See the window.

### Add Table window

Adds tables that are transformed from the relational schema to the connection. See the window.

Schemas

Lists the schemas in the database for you to select.

Tables

Lists the tables transformed from the XML schema.

Added Tables

Lists the tables that you have added from the relational schema.

Generate the default pre-join path

Specifies whether or not to generate the default pre-join path for tables of the XML data source.

###### Related topics:

- XML connections