Versions Compared

Version Old Version 31 New Version Current
Changes made by

Kalpana Malladi

Cindy Hall (Unlicensed)

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. Therefore, we recommend that you migrate from the PostgreSQL JDBC driver to the Redshift JDBC driver by November 2023.

Multiexcerpt include macro
nameRedshift limitation with PostgreSQL driver
templateData[]
pageRedshift - Execute
addpanelfalse

Migrating to the Amazon Redshift JDBC driver

...

Your pipelines might use a combination of JDBC drivers, classes, and URLs of either the PostgreSQL or the Amazon Redshift JDBC. Here are the configuration scenarios that are authenticated successfully.

...

JDBC Driver JAR

JDBC Driver Class

JDBC URL

Authentication

Redshift (default/manual)

com.amazon.redshift.jdbc42.driver

jdbc:redshift (default)

Authenticates successfully when the:

  • Default URL is used.

  • Default Amazon Redshift JAR file that is bundled with the Snap Pack is used.

  • Manually uploaded JAR file is used to connect to the database.

Redshift (manual)

com.amazon.redshift.jdbc42.driver

jdbc:redshift (manual)

Authenticates successfully using the manually uploaded JAR file and manually specified JDBC URL.

PostgreSQL (default/manual)

org.postgresql.driver

jdbc:postgresql (default)

Authenticates successfully when the:

  • Default URL is used.

  • Default PostgreSQL JAR that is bundled with the Snap Pack is used.

  • Manually uploaded JAR file is used to connect to the database.

PostgreSQL (manual)

org.postgresql.driver

jdbc:postgresql (default/manual)

Authenticates successfully using the manually uploaded JAR file and manually specified JDBC URL.

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.

...

The behavior of the Snap remains the same when you select the Match data types checkbox, regardleess regardless of using the PostgreSQL or the Redshift driver—the label names are displayed as configured in the Snap settings.