Versions Compared

Version Old Version 32 New Version 33
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 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.

...