Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Database

Latest certified and recommended drivers

Dependencies

SQL Server

mssql-jdbc-11.2.0.jre11.jar

For this driver version, you must set the URL property in the Generic Database Account as trustServerCertificate=true

MySQL

mysql-connector-java-5.1.47.jar (MySQL 5.x.x server version)
mysql-connector-j-8.0.17.jar (MySQL 8.x.x server version)

 

Oracle

ojdbc10.jar

 

Snowflake

snowflake-jdbc-3.13.25.jar

 

Redshift

RedshiftJDBC42-1.1.17.1017.jar

 

Postgre SQL

postgresql-42.7.2.jar

 

Vertica

vertica-jdbc-11.0.0-0.jar

 

Teradata

17.20.12

 

Cassandra

v4.11.1

 

Maria DB

mariadb-java-client-2.6.0.jar

 

Informix

ifxjdbc.jar

 

Db2

db2jcc4.jar

 

SAP HANA

ngdbc-2.8.14.jar

 

IBM Db2 i

jt400-20.0.7.jar

 

Sybase

jconn4.jar

 

Athena AWS

AthenaJDBC42_2.0.24.1000.jar

 

Potential Breaking Changes

  • After the jOOQ library upgrade, we recommend that you use the SnapLogic-certified drivers for your target databases. If you do not use the certified drivers, the previously functioning pipelines might be impacted.

  • Additionally, we highly recommend that you migrate to dedicated Database Snap Packs (for example, Oracle, SQL Server, MySQL, Redshift) instead of using the Generic JDBC Snap Pack for your integration needs.

...