User guide

DescriptionDefault
Value
Matching
Postgr-
eSQL Op-
tion Ex-
ists?
JDBC Option
The user name to use to connect to the Amazon Red-
shift server.
YesUID
Configure an ODBC Connection
You can use an ODBC connection to connect to your Amazon Redshift cluster from many third-party SQL
client tools and applications.To do this, you need to set up the connection on your client computer or
Amazon EC2 instance. If your client tool supports JDBC, you might choose to use that type of connection
rather than ODBC due to the ease of configuration that JDBC provides. However, if your client tool doesn't
support JDBC, follow the steps in this section to configure an ODBC connection.
Amazon Redshift provides ODBC drivers for Linux, Windows, and Mac OS X operating systems. Before
you install an ODBC driver, you need to determine whether your SQL client tool is 32-bit or 64-bit.You
should install the ODBC driver that matches the requirements of your SQL client tool; otherwise, the
connection will not work. If you use more than one SQL client tool on the same computer or instance,
make sure that you download the appropriate drivers.You might need to install both the 32-bit and the
64-bit drivers if the tools differ in their system architecture.
Topics
• Obtain the ODBC URL for Your Cluster (p. 144)
• Install and Configure the Amazon Redshift ODBC Driver on Microsoft Windows Operating
Systems (p. 146)
• Install the Amazon Redshift ODBC Driver on Linux Operating Systems (p. 148)
• Install the Amazon Redshift ODBC Driver on Mac OS X (p. 150)
• Configure the ODBC Driver on Linux and Mac OS X Operating Systems (p. 151)
• ODBC Driver Configuration Options (p. 155)
Obtain the ODBC URL for Your Cluster
Amazon Redshift displays the ODBC URL for your cluster in the Amazon Redshift console. This URL
contains the information that you need 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
ValueField
The name of the ODBC driver to use. Depending on the driver you download for
your architecture, values will be Amazon Redshift (x86) (for the 32-bit driver) or
Amazon Redshift (x64) (for the 64-bit driver).
Driver
The endpoint of the Amazon Redshift cluster.Server
The database that you created for your cluster.Database
API Version 2012-12-01
144
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift