Versions Compared

Version Old Version 24 New Version 25
Changes made by

Kalpana Malladi

Kalpana Malladi

Saved on

Key

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

...

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

Panel
bgColor#DEEBFF

  • For the JDBC Driver:

    • Default JAR indicates the driver that is bundled with the Snap pack, while manual indicates the driver that you upload.

  • For the JDBC URL:

    • Default JAR indicate the Snap generated URL, while manual indicates the URL that you provide.

JDBC Driver JAR

JDBC Driver Class

JDBC URL

Authentication

Redshift (default JAR/manual upload)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default JAR)

Authenticates successfully.

Redshift (manual upload)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (manual upload)

Authenticates successfully using the manually uploaded JAR file.

PostgreSQL (default JAR/manual upload)

org.postgresql.Driver

jdbc:postgresql (default JAR)

Authenticates successfully.

PostgreSQL (manual upload)

org.postgresql.Driver

jdbc:postgresql (default JAR/manual upload)

Authenticates successfully using the manually uploaded JAR file.

Redshift (manual upload)

org.postgresql.Driver

jdbc:postgresql (default JAR/manual upload)

Authenticates successfully using the default PostgreSQL JAR file.

PostgreSQL (manual upload)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default JAR/manual upload)

Authenticates successfully using the default Redshift JAR file.

...