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
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.
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.
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.
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.
Please note that due to redistribution policies for the database drivers, you will
need to download the driver files from your database vendor website.