<oXygen/> Database perspective

The Database perspective is similar to the Editor perspective. It allows you to manage a database, offering support for browsing multiple connections at the same time, both relational and native XML databases, SQL execution, XQuery execution and data export to XML.

This perspective offers database specific support for:

The XML capabilities of the databases marked in this list with "Enterprise edition only" are available only in the Enterprise edition of <oXygen/>. The non-XML capabilities of any database listed here are available also in the Academic and Professional editions of <oXygen/> by registering the database driver as a generic JDBC driver (the Generic JDBC type in the list of driver types) when defining the data source for accessing the database in <oXygen/>. The non-XML capabilities are browsing the structure of the database instance, opening a table in the Table Explorer view, handling the values from columns of type XML Type as String values. The XML capabilities are: displaying an XML Schema node in the tree of the database structure (for databases with such an XML specific structure) with actions for opening/editing/validating the schemas in an <oXygen/> editor panel, handling the values from columns of type XML Type as XML instance documents that can be opened and edited in an <oXygen/> editor panel, validating an XML instance document added to an XML Type column of a table, etc.

For a detailed feature matrix that compares the Academic, Professional and Enterprise editions of <oXygen/> please go to the <oXygen/> website.

Note

Only connections configured on relational data sources can be used to import to XML or to generate XML schemas.

Figure 3.8. Database perspective

Database perspective

Main menu

Provides menu driven access to all the features and functions available within <oXygen/>.

Main toolbar

Provides easy access to common and frequently used functions. Each icon is a button that acts as a shortcut to a related function.

Editor panel

The place where you spend most of your time, reading, editing, applying markup and checking the validity and form of your documents.

Data Source explorer

Provides browsing support for the configured connections.

Table explorer

Provides table content editing support: insert a new row, delete a table row, cell value editing, export to XML file.