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, 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
- 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)
-
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 XML Developer plugin
. The non-XML
capabilities of any database listed here are available also in the Academic and
Professional editions of
Oxygen XML Developer plugin
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 XML Developer plugin
.
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 XML Developer plugin
editor
panel;
- handling the values from columns of type XML Type as XML instance documents that
can be opened and edited in an
Oxygen XML Developer plugin
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 XML Developer plugin
please
go to the
Oxygen XML Developer plugin
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 access to all the features and functions available within
Oxygen XML Developer plugin
.
- 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 area - 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 for inserting new rows,
deleting table rows, cell value editing, export to XML file.