Next, in the "Select database table" choose the connection you want to use.
![[Note]](img/note.gif) | Note |
|---|---|
Only connections configured on relational data sources can be used to import to XML or to generate schemas. |
You can edit, delete or add a new data source and connection: click on the "Configure Database Sources" button and the "Preferences" dialog will open at the Data Sources section. Click Connect.
- Format
Enables you to choose a format for the structure.
Flat - Generates an XML Schema according to the ISO-ANSI Working draft (Part 14: XML Related Specifications SQL/XML).
Hierarchical - Represents the database structure as a tree hierarchy taking into account the relationship between tables.
- Criterion
The Criterion options allow the user to specify the name of the selected database column and also how it should be converted into XML. The following options are available:
Element: When checked the selected column will be converted into an XML element.
Attribute: If checked the selected column will be converted into an XML attribute.
Skipped: Is to be selected if the intention is to skip that column from being imported.
Name: Allows you to specify the name of the column to be imported. Implicitly <oXygen/> suggests an import name that is according to SQL/XML Specification.
Type: Displays the data type of the imported column.