Use the port that the cluster was configured to use PortĮnter the port number that the database uses. More information, see Configuring connections in Amazon Redshift. Information in the Amazon Redshift console on the cluster's details page.

Specify the endpoint for your Amazon Redshift cluster. For example, if you followed theĪmazon Redshift Getting Started Guide, you might typeĮxampleclusterdsn to make it easy to remember theĬluster that you associate with this DSN. Want to identify the data source later when you create theĬonnection to the cluster. Under Connection Settings, enter the followingĮnter a name for the data source. Third-party application that is certified for use with Amazon Redshift and thatĬhoose the System DSN tab to configure theĭriver for all users on the computer, or the UserĭSN tab to configure the driver for your user accountĬhoose the Amazon Redshift ODBC driver, and then chooseįinish. Only use a driver other than these if you're running a Use the following procedure to download the Amazon Redshift ODBC drivers for Windows See the Amazon Redshift ODBC connector installation and configuration guide. For information about minimum system requirements, Each computer where you install the driver must meet a list of You install the Amazon Redshift ODBC driver on client computers accessing an Amazon Redshiftĭata warehouse. Install and configure the Amazon Redshift

PWD= insert_your_admin_user_password_here įor information about how to get your ODBC connection, see Finding your cluster connection

If you want to use an ODBC connection, take the following steps. įor installation and configuration information for Amazon Redshift ODBC drivers, see the Amazon Redshift ODBC connector installation and configuration guide. Further updates will not be released, except for urgent security patches.įor the latest information about ODBC driver functionality and prerequisites, see Amazon Redshift ODBC driver release notes. The 32-bit ODBC drivers are discontinued. However, if your client tool doesn't support JDBC,įollow the steps in this section to configure an ODBC connection.Īmazon Redshift provides 64-bit ODBC drivers for Linux, Windows, and macOS X operating systems. If your client tool supports JDBC, you mightĬhoose to use that type of connection rather than ODBC due to the ease ofĬonfiguration that JDBC provides. Your client computer or Amazon EC2 instance. Third-party SQL client tools and applications. You can use an ODBC connection to connect to your Amazon Redshift cluster from many

Weird West for mac instal