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.
Database |
JDBC Driver |
---|---|
DB2® LUW |
DB2 Type
4 Universal Driver ( |
DB2 z/OS® |
DB2 Type
4 Universal Driver ( |
Informix® |
IBM Informix JDBC Driver ( |
Microsoft SQL Server |
Microsoft JDBC Driver for SQL Server
( 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 ( |
IBM Netezza data warehouse |
Netezza JDBC Driver ( |
Oracle |
Oracle JDBC Thin Driver ( 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 ( |