User guide

Install and Configure the Amazon Redshift ODBC Driver on Microsoft
Windows Operating Systems
System Requirements
You install the Amazon Redshift ODBC driver on client computers accessing an Amazon Redshift data
warehouse. Each computer where you install the driver must meet the following minimum system
requirements:
• Microsoft Windows Vista operating system or later
• 55 MB of available disk space
• Administrator privileges on the client computer
• An Amazon Redshift master user or user account to connect to the database
Installing the Amazon Redshift Driver on Windows Operating Systems
Use the steps in this section to download the Amazon Redshift ODBC drivers for Microsoft Windows
operating systems.You should only use a driver other than these if you are running a third-party application
that is certified for use with Amazon Redshift and that requires a specific driver for that application.
To install the ODBC driver
1. Download one of the following, depending on the system architecture of your SQL client tool or
application:
• 32-bit: https://s3.amazonaws.com/redshift-downloads/drivers/AmazonRedshiftODBC32.msi
The name for this driver is Amazon Redshift (x86).
• 64-bit: https://s3.amazonaws.com/redshift-downloads/drivers/AmazonRedshiftODBC64.msi
The name for this driver is Amazon Redshift (x64).
Note
Download the MSI package that corresponds to the system architecture of your SQL client
tool or application. For example, if your SQL client tool is 64-bit, install the 64-bit driver.
Then download and review the Amazon Redshift ODBC Driver License Agreement. If you need to
distribute these drivers to your customers or other third parties, please email [e-mail]
to arrange an appropriate license.
2. Double-click the .msi file, and then follow the steps in the wizard to install the driver.
Creating a System DSN Entry for an ODBC Connection on Microsoft Windows
After you download and install the ODBC driver, you need to add a data source name (DSN) entry to the
client machine or Amazon EC2 instance. SQL client tools use this data source to connect to the Amazon
Redshift database.
To create a system DSN entry
1. In the Start menu, in your list of programs, locate the driver folder or folders.
Note
If you installed the 32-bit driver, the folder is named Amazon Redshift ODBC Driver (32-bit).
If you installed the 64-bit driver, the folder is named Amazon Redshift ODBC Driver (64-bit).
If you installed both drivers, you'll have a folder for each driver.
2. Click ODBC Administrator, and then type your administrator credentials if you are prompted to do
so.
API Version 2012-12-01
146
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift