Versions Compared

Version Old Version 29 New Version 30
Changes made by

Kalpana Malladi

Kalpana Malladi

Saved on

Key

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

...

Important:

  • SnapLogic will support providing fixes for the issues you might encounter with accounts that use the PostgreSQL JDBC driver only until November 2023, after which SnapLogic will not provide support for issues with the PostgreSQL JDBC driver. Therefore, we recommend that you migrate from the PostgreSQL JDBC driver to the Redshift JDBC driver by November 2023.

...

Panel
bgColor#DEEBFF

  • For the JDBC Driver:

    • Default JAR indicates the driver that is bundled with the Snap Pack, and manual indicates the driver that you manually upload.

  • For the JDBC URL:

    • Default JAR indicate the Snap-generated URL, and manual indicates the URL that you manually uploadspecify.

JDBC Driver JAR

JDBC Driver Class

JDBC URL

Authentication

Redshift (default/manual)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default)

Authenticates successfully.

Redshift (manual)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (manual)

Authenticates successfully using the manually uploaded JAR file.

PostgreSQL (default/manual)

org.postgresql.Driver

jdbc:postgresql (default)

Authenticates successfully.

PostgreSQL (manual)

org.postgresql.Driver

jdbc:postgresql (default/manual)

Authenticates successfully using the manually uploaded JAR file.

Redshift (manual)

org.postgresql.Driver

jdbc:postgresql (default/manual)

Authenticates successfully using the default PostgreSQL JAR file.

PostgreSQL (manual)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default/manual)

Authenticates successfully using the default Redshift JAR file.


If your account configuration uses one of the following combination combinations of JAR files, driver classes, and JDBC URLs, then your accounts account cannot be authenticated because of the misaligned JDBC driver class and JDBC URL.

...