Edit online

Database Connection Support

Oxygen XML Author offers support for a variety of Relational and Native XML database connections. The database drivers and connections for various types of database are configured in the Data Sources preferences page and once configured, the database connections can be viewed and managed in the Data Source Explorer view. Oxygen XML Author also includes a Database perspective that helps you to manage databases.

The database support in Oxygen XML Author offers a variety of capabilities, including:
  • Browsing the structure of databases in the Data Source Explorer view.
  • Viewing relational tables in the Table Explorer view.
  • Executing SQL queries against databases.
  • Calling stored procedures with input and output parameters.
  • XQuery execution with databases.
  • Exporting data from databases to XML.

Relational Database Support

Relational databases use a relational model and are based on tables linked by a common key. Oxygen XML Author offers support for the most commonly used relational databases, including:
  • IBM DB2 (Deprecated)
  • Oracle 11g (Deprecated)
  • Microsoft SQL Server (Deprecated)
  • PostgreSQL (Deprecated)
  • MySQL (Deprecated)

Oxygen XML Author also offers generic support (table browsing and execution of SQL queries) for any JDBC-compliant database (for example, MariaDB).

Native XML Database Support

Native XML databases have an XML-based internal model and their fundamental unit of storage is XML. They use XML as an interface to specify documents as tree structured data that may contain unstructured text, but on disk the data is stored as optimized binary files. This makes query and retrieval processes faster. Oxygen XML Author offers support for the most commonly used native XML databases, including:

  • eXist
  • MarkLogic (Deprecated)
  • Oracle XML DB (Deprecated)
  • Base X