Supported JDBC drivers

To successfully run CDC Replication, you need to ensure that a supported JDBC driver is installed.

The following table indicates the JDBC drivers that are supported for use with IBM® CDC FlexRep. Be aware that only type 4 JDBC drivers are supported.

Table 1. Supported JDBC drivers for EnterpriseDb
Settings Value
Driver class com.edb.Driver
Supported Versions
  • Postgres Plus Advanced Server 9.1 (9.1.2.2)
  • EDB Postgres Advanced Server 9.6 (9.4.1212.0)
  • EnterpriseDB JDBC Driver 42.2
JDBC URL Pattern jdbc:edb://[host]:[port]/[database]

JDBC Driver JAR File
  • edb-jdbc16.jar
  • edb-jdbc17.jar
  • edb-jdbc18.jar
Location This driver is shipped with the database.
Table 2. Supported JDBC drivers for SingleStoreDB
Settings Value
Driver class com.singlestore.jdbc.Driver
Supported Versions SingleStoreDB Cloud, 7.8 and 8.0
JDBC URL Pattern jdbc:singlestore://[host]:[port]

JDBC Driver JAR File

 singlestore-jdbc-client-1.1.5.jar
Location This driver is shipped with the database.
Table 3. Supported JDBC drivers for YugabyteDB
Settings Value
Driver class org.postgresql.Driver
Supported Versions v2.14, v2.16, v2.17
JDBC URL Pattern jdbc:postgresql://[host]:[YSQL port]/yugabyte

JDBC Driver JAR File

 postgresql-42.5.1.jar
Location This driver is installed with the IBM CDC FlexRep software and is located in the /lib folder of the installation directory.
Table 4. Supported JDBC drivers for MySQL
Settings Value
Driver class com.ibm.replication.jdbc.mysql.MySQLDriver
Supported Versions
  • 5.1.1.000050 (F000075.U000035)
  • 5.1.4.000223 (F000438.U000209)
JDBC URL Pattern jdbc:ibm:replication:mysql://[hostname]:[port][;property=value[;...]]

JDBC Driver JAR File
  • CImysql.jar
  • CImysql-5.1.4.000223.jar
Location This driver is installed with the IBM CDC FlexRep software and is located in the /lib folder of the installation directory.
Table 5. Supported JDBC drivers for Amazon Redshift
Settings Value
Driver class com.ibm.replication.jdbc.redshift.RedshiftDriver
Supported Versions 5.1.4.000088 (F000362.U000179)
JDBC URL Pattern 
jdbc:ibm:replication:redshift://[host]:[port];
DatabaseName=database_name;
sslmode=require;
EncryptionMethod=SSL;
ValidateServerCertificate=false;
AuthMech=REQUIRE;
ssl=TRUE[;property=value[;...]]

JDBC Driver JAR File

 CIredshift-5.1.4.000088.jar
Location This driver is installed with the IBM CDC FlexRep software and is located in the /lib folder of the installation directory.
Notes Set mirror_batch_apply_check to CHECK_ROWS_AFFECTED_UPDATE_DELETE.

You can configure the encryption profile to be either enabled or disabled. Enabled is recommended.
Table 6. Supported JDBC drivers for Snowflake
Settings Value
Driver class net.snowflake.client.jdbc.SnowflakeDriver
Supported Versions 3.13.15
JDBC URL Pattern jdbc:snowflake://account_identifier.snowflakecomputing.com/?connection_parameters

JDBC Driver JAR File

 snowflake-jdbc-3.13.15.jar
Location This driver is shipped with the database.
Notes Example JDBC URL: jdbc:snowflake://xy1234.snowflakecomputing.com/?db=DEMODB

IBM officially supports JDBC drivers that have been tested and documented by IBM for use with IBM CDC FlexRep. IBM CDC FlexRep can also be configured to use third-party JDBC drivers. However, if problems arise when using third-party JDBC drivers, customers may contact IBM technical support to request assistance. For such cases, IBM Support will help isolate and diagnose issues by following normal support processes. Customers might need to provide information for problem determination, but IBM will retain sole discretion to determine if an issue is third party related. If the issue is determined to be related to a third-party JDBC driver, customers can then share the diagnosis with the provider of the third-party JDBC driver for their usage in changing their driver. IBM will not be obligated to make product changes in order to make IBM CDC FlexRep compatible with any third-party JDBC driver.