User guide

jdbc:redshift://endpoint:port/database
Note
A JDBC URL specified with the former format of jdbc:postgresql://endpoint:port/database
will still work.
ValueField
The endpoint of the Amazon Redshift cluster.endpoint
The port number that you specified when you launched the cluster. If you have a
firewall, ensure that this port is open for you to use.
port
The database that you created for your cluster.database
The following is an example JDBC URL:
jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev
To obtain your JDBC URL
1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://
console.aws.amazon.com/redshift/.
2. At top right, select the region in which you created your cluster.
If you followed the Amazon Redshift Getting Started, select US West (Oregon).
3. In the left navigation pane, click Clusters, and then click your cluster.
If you followed the Amazon Redshift Getting Started, click examplecluster.
4. On the Configuration tab, under Cluster Database Properties, copy the JDBC URL of the cluster.
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 (p. 173).
API Version 2012-12-01
141
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift