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.

Video Tutorials
Upcoming Events
oXygen Users Meetup Prague 2015
oXygen Users Meetup Prague 2015
February 13, 2015
Prague, Czech Republic
" oXygen XML Editor is the premier text editor for XML geeks, and an indispensable tool for O'Reilly's Production group. My team uses oXygen XML Editor for everything from simple XML editing to Schema validation and XSLT transformations. The digital production staff especially loves oXygen's built-in EPUB support, which eliminates a great deal of the grunt work that is usually entailed in editing EPUB files. The more we use oXygen, the more realize what a powerful tool it can be in digital and XML-based workflows."
Adam Witwer
Director of Content and Publishing Operations
O'Reilly Media