Database Perspective

Using the Database perspective, you can browse tables or collections from databases, execute XQuery or SQL queries, inspect or modify data, and 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 in the oXygen Professional and Academic Editions. For other databases, you need the Enterprise license edition.

The Database Perspective contains a Data Source Explorer view for browsing and managing the defined connections (you can define multiple connections at one time and browse them in parallel), a Table Explorer view component for data inspection, the main editor area, and some helper views.

Database Perspective

The Data Source Explorer view shows the database connections, 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 an 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 Explorer include delete, insert, and duplicate rows.

Table Editor

For connections over native databases, the browser shows collections and documents. You can manage the collections with actions such as delete, move, and rename, 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.