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:
- Oracle Berkeley DB XML Database
- eXist XML Database
- IBM DB2 (Enterprise edition only)
- JDBC-ODBC Bridge (Enterprise edition only)
- MarkLogic (Enterprise edition only, XQuery support only)
- Microsoft SQL Server 2005 and Microsoft SQL Server 2008 (Enterprise edition only)
- MySQL
- Oracle 11g (Enterprise edition only)
- PostgreSQL 8.3 (Enterprise edition only)
- Software AG Tamino (Enterprise edition only)
- TigerLogic (Enterprise edition only, XQuery support only)
-
Documentum xDb (X-Hive/DB) 10 XML Database
(Enterprise edition only)
-
Documentum (CMS) 6.5 (Enterprise
edition only)
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 database table in the Table Explorer view;
- handling the values from XML Type columns 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 data to XML
or to generate XML schemas.
- 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 validating 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.