This wizard appears when you select XML and click OK in the New Data Source dialog, or in the Catalog Browser right-click a data source and select Add XML Connection from the shortcut menu or right-click an existing XML connection and select Edit XML Instance Source 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 screens:
Back
Goes back to the previous screen.
Next
Goes to the next screen.
Finish
Finishes confirming to transform an XML schema to a relational schema.
Cancel
Does not retain changes and closes this wizard.
Help
Displays the help document about this feature.
Specifies the necessary information to import XML schema. See the screen.
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:
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.
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.
Refresh
Available only when you edit an existing XML connection. Once you make some change in the wizard and click the Refresh button, the XML schema information will be reloaded according to what you have changed.
Specifies properties of the XML schema. See the screen.
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.
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 displayed in the required format. For details about these properties, see the section Supplementing information for the XML schema.
This screen 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 screen.
This screen lists the transformed relational schema structure. It helps you to click Next to confirm the transformation results and go into the Add Table screen. See the screen.
Adds tables that are transformed from the relational schema to the connection. This screen is not available when you edit an existing XML connection. See the screen.
Schema
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.
Adds the selected tables.
Removes the selected tables from the Added Tables box.
Generate the default pre-join path
Specifies whether or not to generate the default pre-join path for tables of the XML data source.