User guide

ValueField
The user name of a user account that has permission to connect to the database.
This value is a database permission, not an Amazon Redshift permission, although
you can use the master user account that you set up when you launched the cluster.
UID
The password for the user account to connect to the database.PWD
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 following is an example ODBC URL: Driver={Amazon Redshift (x64)};
Server=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com;
Database=dev; UID=masteruser; PWD=insert_your_master_user_password_here;
Port=5439
To obtain your ODBC 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 ODBC URL of the cluster.
API Version 2012-12-01
145
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift