Using the Database
perspective you can browse tables or collections from databases, execute XQuery or SQL
queries, inspect or modify data, specify XML Schemas for the XML fields and
The database support includes many of the popular servers,
operating either as native XML storage: Documentum xDB (X-Hive/DB), MarkLogic, eXist,
Berkeley or mixed, as relational and XML at the same time: DB2, SQLServer, Oracle.
Please note that only eXist, Berkeley and JDBC (limited to table browsing) database
support is included into the oXygen Professional and Academic Editions.
The Database Perspective contains an explorer
over the defined connections (you can define multiple connections at one time and browse
them in parallel), a table component for data inspection/editing and the editor
The database browser shows the database schemas, catalogs, tables, and field names.
You can click on a table and choose to edit the data or export it as XML.
If the table contains a column of the XML type you can double-click it and open its
content into the editing area. Use the normal save action to commit its new value into
the database. Other operations available in the table editor are: delete, insert and
In case of a connection over a native database, the browser shows collections and
documents. You can manage the collections: delete, move, rename them, or you can edit
the XML documents.
Please note that due to redistribution policies for the database drivers, you will
need to download the driver files from your database vendor website.