Versions Compared

Version Old Version 20 New Version 21
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 driver only until November 2023, after which SnapLogic will not provide support for issues with the PostgreSQL JDBC driver. Therefore, we recommend you to for such scenarios you must migrate from the PostgreSQL JDBC driver to the Redshift JDBC driver before November 2023.

...

Info

  • For the JDBC URL, default indicate the Snap generated URL, while the manual indicates the URL that the user providesyou provide.

  • For the JDBC driver, default indicates the driver that is bundled with the Snap pack, while the manual indicates the driver that the user uploadsyou upload.

JDBC Driver JAR

JDBC Driver Class

JDBC URL

Authentication

Redshift (default)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default/manual)

Authenticates successfully.

Redshift (manual upload)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default/manual)

Authenticates successfully using the manually uploaded JAR file.

PostgreSQL (default)

org.postgresql.Driver

jdbc:postgresql (default/manual)

Authenticates successfully.

PostgreSQL (Manual)

org.postgresql.Driver

jdbc:postgresql (default/manual)

Authenticates successfully using the manually uploaded JAR file.

Redshift JAR

org.postgresql.Driver

jdbc:postgresql (default/manual)

Authenticates successfully using the default PostgreSQL JAR file.

PostgreSQL JAR

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default/manual)

Authenticates successfully using the default Redshift JAR file.

...