User guide

3. Select the System DSN tab if you want to configure the driver for all users on the computer, or the
User DSN tab if you want to configure the driver for your user account only.
4. Click Add.The Create New Data Source window opens.
5. Select the Amazon Redshift ODBC driver, and then click Finish.The Amazon Redshift ODBC Driver
DSN Setup window opens.
6. Under Connection Settings, enter the following information:
Data Source Name
Type a name for the data source.You can use any name that you want to identify the data source later
when you create the connection to the cluster. For example, if you followed the Amazon Redshift
Getting Started, you might type exampleclusterdsn to make it easy to remember the cluster that
you will associate with this DSN.
Server
Specify the endpoint for your Amazon Redshift cluster.You can find this information in the Amazon
Redshift console on the cluster’s details page. For more information, see Configuring Connections in
Amazon Redshift (p. 138).
Port
Type the port number that the database uses. By default, Amazon Redshift uses 5439, but you should
use the port that the cluster was configured to use when it was launched.
Database
Type the name of the Amazon Redshift database. If you launched your cluster without specifying a
database name, type dev; otherwise, use the name that you chose during the launch process. If you
followed the Amazon Redshift Getting Started, type dev.
7. Under Credentials, enter the following information:
User
Type the user name for the database user account that you want to use to access the database. If you
followed the Amazon Redshift Getting Started, type masteruser.
Password
Type the password that corresponds to the database user account.
8. Under SSL Settings, specify a value for the following:
SSL Authentication
Select a mode for handling Secure Sockets Layer (SSL). In a test environment, you might use prefer,
but for production environments and when secure data exchange is required, use verify-ca. For
more information about using SSL, see Connect Using SSL (p. 158).
9. Under Additional Options, select one of the following options to specify how to return query results
to your SQL client tool or application:
• Single Row Mode. Select this option if you want query results to be returned one row at a time to
the SQL client tool or application. Use this option if you plan to query for large result sets and don't
want the entire result in memory. Disabling this option improves performance, but it can increase
the number of out-of-memory errors.
• Use Declare/Fetch. Select this option if you want query results to be returned to the SQL client tool
or application in a specified number of rows at a time. Specify the number of rows in Cache Size.
• Use Multiple Statements. Select this option to return results based on multiple SQL statements in
a query.
API Version 2012-12-01
147
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift