You can obtain the Server and Port values in the AWS Management Console:
Password: Set this to the password you want to use to authenticate to the Server.User: Set this to the username you want to use to authenticate to the Server.Or, leave this blank to use the default database of the authenticated user. Database: Set this to the name of the database.Port: Set this to the port of the cluster.Server: Set this to the host name or IP address of the cluster hosting the Database you want to connect to.To connect to Redshift, set the following: See the Getting Started section in the CData driver documentation for a guide to creating a DSN on your OS. You can now connect with an ODBC connection string or a DSN.