Relational Database Support

| | Learn More

DataDirect XQuery can efficiently query and update relational data, which is particularly helpful for XML Publishing and Reporting, Data Integration, and ETL applications (which require efficent XML shredding and transparent relational database updates.

DataDirect XQuery 4.0 supports the following databases:

DB2

DataDirect XQuery supports these DB2 versions:

• DB2 V9.5 for Linux, UNIX, and Windows
• DB2 V9.1 for Linux, UNIX, and Windows
• DB2 V9.1 for z/OS
• DB2 UDB v8.x for Linux, UNIX, and Windows
• DB2 UDB 8.1 for z/OS
• DB2 UDB V5R2, V5R3 for iSeries

Informix

DataDirect XQuery supports these Informix versions:

• Informix 11
• Informix 10
• Informix 9.4

Microsoft SQL Server

DataDirect XQuery supports these Microsoft SQL Server versions:

• MS SQL Server 2005
• MS SQL Server 2000
• MS SQL Server 2000 Desktop Engine (MSDE 2000)
• MS SQL Server 2000 Enterprise Edition (64-bit)

MySQL

DataDirect XQuery supports these MySQL versions:

• MySQL Enterprise 5.0.x

Oracle

DataDirect XQuery supports these Oracle versions:

• Oracle 11g
• Oracle 10g (R1 and R2)
• Oracle 9i (R1 and R2)

PostgreSQL

DataDirect XQuery supports these PostgreSQL versions:

• PostgresSQL 8.2 and, 8.1 (requires the PostgreSQL JDBC driver)

Sybase

DataDirect XQuery supports these Sybase versions:

• Sybase Adaptive Server Enterprise 15.0
• Sybase Adaptive Server Enterprise 12.5.x