Getting the ODBC URL
Amazon Redshift displays the ODBC URL for your cluster in the Amazon Redshift console. This URL contains the information required to set up the connection between your client computer and the database.
An ODBC URL has the following format:
Driver={
driver
}; Server=endpoint_host
; Database=database_name
; UID=user_name
; PWD=password
; Port=port_number
The preceding format's fields have the following values:
Field | Value |
---|---|
|
The name of the 64-bit ODBC driver to use: Amazon Redshift ODBC Driver (x64) |
|
The endpoint host of the Amazon Redshift cluster. |
|
The database that you created for your cluster. |
|
The user name of a database user account that has permission to connect to the database. Although this value is a database-level permission and not a cluster-level permission, you can use the Redshift admin user account that you set up when you launched the cluster. |
|
The password for the database user account to connect to the database. |
|
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. |
The following is an example ODBC URL:
Driver={Amazon Redshift ODBC Driver (x64)}; Server=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com; Database=dev; UID=adminuser; PWD=insert_your_admin_user_password_here; Port=5439
For information on where to find the ODBC URL, see Finding your cluster connection string.