Database Perspective

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 collections.

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 area.

Database Perspective

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.

Relational Database Browser

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 duplicate rows.

Table Editor

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.

XML Database Browser

Please note that due to redistribution policies for the database drivers, you will need to download the driver files from your database vendor website.