Amazon Redshift

The data source name:

Amazon Redshift

The supported driver build version:

Build 25.0.9335

The supported data source versions and environments:

The driver enables standards-based access to Amazon Redshift based on PostgreSQL 8.0.2 with Amazon Redshift SQL.

The JDBC connection string:

jdbc:redshift:

The JDBC driver class name:

cdata.jdbc.redshift.RedshiftDriver

The connector offering type:

Commercial

The Jobserver certification status:

Yes

The Jobserver certification date:

, since before 2022.08

The support for source-driven random sampling:

Yes

The Edge certification status:

Yes

The Edge certification date:

, since before 2022.08

The support for source-driven random sampling:

Yes

The support for multiple database registration:

No

The support for source tag registration:

No

The support for popularity score calculation:

No

The Collibra Marketplace listing URL:

https://marketplace.collibra.com/listings/jdbc-driver-for-amazon-redshift

The connection prerequisites:

  • You have downloaded the JDBC driver of Amazon Redshift as a JAR or ZIP file with a valid Java archive structure from Collibra Marketplace.

    • The driver download and preparation notes:

    Note 
    • The JDBC driver has to be in JAR format.
    • If you downloaded the JDBC driver from Collibra Marketplace, make sure to unzip the downloaded ZIP file before uploading it to Collibra Data Intelligence Cloud.

    The connection configuration notes and requirements:

    Authenticating to Redshift

    Connect Using Standard Authentication

    To authenticate using standard authentication, no additional connection properties are required.

    Connect Using SSL Authentication

    You can leverage SSL authentication to connect to Redshift data via a secure session. Configure the following connection properties to connect to data:

    • SSLClientCert: Set this to the name of the certificate store for the client certificate. Used in the case of 2-way SSL, where truststore and keystore are kept on both the client and server machines.
    • SSLClientCertPassword: If a client certificate store is password-protected, set this value to the store's password.
    • SSLClientCertSubject: The subject of the TLS/SSL client certificate. Used to locate the certificate in the store.
    • SSLClientCertType:; The certificate type of the client store.
    • SSLServerCert: The certificate to be accepted from the server.

    Connect Using SSO Authentication

    Alternatively, you can connect to Redshift data using single sign-on (SSO). Configure the following connection properties to connect to data:

    • SSOProvider: The name of the SSO provider you are trying to authenticate. The following options are available: OKTA, OneLogin, and ADFS.
    • SSOLoginUrl: Set this to the login url associated with the SSO provider.
    • SSOUser: The username of the SSO Provider used to authenticate the user.
    • SSOPassword: The password of the SSO Provider used to authenticate the user.

    The data source display name and icon: