2021.10
Collibra DIC Integration
Powered By GitBook
Connectivity to Redshift

Example URL

1
jdbc:redshift://redshift-cluster-name.kdkcis9g8.us-east-1.redshift.amazonaws.com:5439/dev
Copied!

Driver Name

1
com.amazon.redshift.jdbc.Driver
Copied!
Amazon Redshift offers drivers for tools that are compatible with the JDBC 4.2 API. For information about the functionality supported by these drivers, see the Amazon Redshift JDBC driver release notes.
For detailed information about how to install the JDBC driver version 1.0, reference the JDBC driver libraries, and register the driver class, see Amazon Redshift JDBC driver installation and configuration guide.
For each computer where you use the Amazon Redshift JDBC driver, make sure that Java Runtime Environment (JRE) 8.0 is installed.
If you use the Amazon Redshift JDBC driver for database authentication, make sure that you have AWS SDK for Java 1.11.118 or later in your Java class path. If you don't have AWS SDK for Java installed, download the ZIP file with JDBC 4.2–compatible driver (without the AWS SDK) and driver dependent libraries for the AWS SDK:
For more information about previous driver versions, see Use previous JDBC driver versions with the AWS SDK for Java.
If your tool requires a specific previous version of a driver, see Use previous JDBC driver version 1.0 driver versions in certain cases.

Getting the JDBC URL

Before you can connect to your Amazon Redshift cluster from a SQL client tool, you need to know the JDBC URL of your cluster. The JDBC URL has the following format: jdbc:redshift://endpoint:port/database.Note
A JDBC URL specified with the former format of jdbc:postgresql://endpoint:port/database still works.
The fields of the format shown preceding have the following values.
Field
Value
jdbc
The protocol for the connection.
redshift
The subprotocol that specifies to use the Amazon Redshift driver to connect to the database.
endpoint
The endpoint of the Amazon Redshift cluster.
port
The port number that you specified when you launched the cluster. If you have a firewall, make sure that this port is open for you to use.
database
The database that you created for your cluster.
The following is an example JDBC URL: jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev
For information about how to get your JDBC connection, see Finding your cluster connection string.
If the client computer fails to connect to the database, you can troubleshoot possible issues. For more information, see Troubleshooting connection issues in Amazon Redshift.
Last modified 20d ago