Supported databases

The Gateway for JDBC is supported for use with the databases listed here.

The gateway is supported for use with the databases and JDBC drivers listed in the following table.
Note: The Gateway for JDBC will support a database once the vendor supplies a suitable JDBC driver that works with the gateway. Drivers not listed in this table are not supported by IBM Software Support, but if a third party JDBC driver does not function correctly due to a fault with the Gateway for JDBC, then IBM Software Support will provide support.
Table 1. Supported databases and JDBC drivers

Database

JDBC Driver

DB2® LUW

DB2 Type 4 Universal Driver (com.ibm.db2.jcc.DB2Driver)

DB2 z/OS®

DB2 Type 4 Universal Driver (com.ibm.db2.jcc.DB2Driver)

Informix®

IBM Informix JDBC Driver (com.informix.jdbc.IfxDriver)

Microsoft SQL Server

Microsoft JDBC Driver for SQL Server (com.microsoft.sqlserver.jdbc.SQLServerDriver)

Note: On OMNIbus installations which are JRE 1.7 based the Microsoft JDBC Driver 4.2 up till 6.4 can be used.. For OMNIbus installations using JRE 1.8, Microsoft JDBC Driver 7.0 and above may be used providing that the driver used is the JRE 1.8 version. For more details on the Microsoft JDBC Driver, please refer to the Microsoft JDBC Driver for SQL Server website. Ensure that multiple versions of the .jar files are not installed in the $CLASSPATH or in the $OMNIHOME/gates/java location simultaneously.

MySQL

MySQL Connector/J (com.mysql.jdbc.Driver)

IBM Netezza data warehouse

Netezza JDBC Driver (org.netezza.Driver)

Oracle

Oracle JDBC Thin Driver (oracle.jdbc.driver.OracleDriver)

Note: When the database connection is enabled with Kerberos authentication, the gateway must be run using Oracle Java. See: Deploying the gateway with non-IBM Java.

Sybase

Sybase jConnect for JDBC (com.sybase.jdbc4.jdbc.SybDriver)