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.
Note: Only type 4 JDBC drivers are supported.
Table 1. Supported JDBC drivers for EnterpriseDb
Settings Value
Driver class com.edb.Driver
Supported Versions
  • EnterpriseDB JDBC Driver 42.2
  • EnterpriseDB JDBC Driver 42.5
JDBC URL Pattern jdbc:edb://[host]:[port]/[database]

JDBC Driver JAR File
  • 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, Aeon production track and innovation track
JDBC URL Pattern jdbc:postgresql://[host]:[YSQL port]/yugabyte

JDBC Driver JAR File

 postgresql-42.7.2.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.15.0, 3.24.1, 3.25.1
JDBC URL Pattern jdbc:snowflake://account_identifier.snowflakecomputing.com/?connection_parameters

JDBC Driver JAR File

 snowflake-jdbc-3.15.0.jar, snowflake-jdbc-3.24.1.jar, snowflake-jdbc-3.25.1.jar
Location This driver is shipped with the database.
Notes Example JDBC URL: jdbc:snowflake://xy1234.snowflakecomputing.com/?db=DEMODB
Table 7. Supported JDBC drivers for Databricks
Settings Value
Driver class com.databricks.client.jdbc.Driver
Supported Versions Simba Driver (version 2.7.1 or 2.7.3) and OSS Driver (version 2.7.1 or 2.7.3)
JDBC URL Pattern jdbc:databricks://[hostname]:[port]/[schema][;property=value[;...]]

JDBC Driver JAR File

 DatabricksJDBC*.jar
Location Download the appropriate driver from the Databricks website.
Notes Example JDBC URL: jdbc:databricks://adb-2945880371306113.13.azuredatabricks.net:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/b28338c62ba57585 You can run Databricks on any cloud platform and access it through the JDBC driver. Complete the Additional requirements for Databricks after creating an instance.
Username "token"
Password Personal access token for CDC user
Schema Schema in the default catalog for the CDC user where CDC can create metadata tables. This schema can contain tables to be replicated.
Table 8. Supported JDBC drivers for Presto
Settings Value
Driver class com.facebook.presto.jdbc.PrestoDriver
Supported Versions 0.292 and 0.293
JDBC URL Pattern presto://:/<catalog_name>?[property1=value1[&property2=value2][&...]]

JDBC Driver JAR File

 presto-jdbc-0.292.jar
Location This driver is shipped with the database.
Notes Example JDBC URL: jdbc:databricks://adb-2945880371306113.13.azuredatabricks.net:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/b28338c62ba57585 Complete the Additional requirements for Presto after creating an instance.

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.