Getting the ODBC URL

Amazon Redshift displays the ODBC URL for your cluster in the Amazon Redshift console. This URL contains the information to set up the connection between your client computer and the database.

An ODBC URL has the following format: Driver={driver};Server=endpoint;Database=database_name;UID=user_name;PWD=password;Port=port_number

The fields of the format shown preceding have the following values.

The fields in the preceding tables can contain the following special characters:

[]{}(),;?*=!@ 

If you use these special characters you must enclose the value in curly braces. For example, the password value Your;password123 in a connection string is represented as PWD={Your;password123};.

Since Field=value pairs are separated by semicolon, the combination of } and ; with any number of spaces in between is considered the end of a Field={value}; pair. We recommend you avoid the sequence }; in your field values. For example, if you set your password value as PWD={This is a passwor} ;d};, your password would be This is a passwor} ; and the URL would error out.

The following is an example ODBC URL.

Driver={Amazon Redshift (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 about how to get your ODBC connection, see Finding your cluster connection string.