User guide

• unixODBC 2.3.0 or later. For more information about the unixODBC driver manager and links to
download it, go to the unixODBC website.
• An Amazon Redshift master user or user account to connect to the database
Installing the Amazon Redshift Driver on Linux Operating Systems
Use the steps in this section to download and install the Amazon Redshift ODBC drivers on a supported
Linux distribution.The installation process will install the driver files in the following directories:
• /opt/amazon/redshiftodbc/lib/32 (for a 32-bit driver)
• /opt/amazon/redshiftodbc/lib/64 (for a 64-bit driver)
• /opt/amazon/redshiftodbc/ErrorMessages
• /opt/amazon/redshiftodbc/Setup
To install the Amazon Redshift ODBC driver
1. Download one of the following, depending on the system architecture of your SQL client tool or
application:
• 32-bit .rpm: https://s3.amazonaws.com/redshift-downloads/drivers/
AmazonRedshiftODBC-32bit-1.1.0.0000-1.i686.rpm
• 64-bit .rpm: https://s3.amazonaws.com/redshift-downloads/drivers/
AmazonRedshiftODBC-64bit-1.1.0.0000-1.x86_64.rpm
The name for both of these drivers is Amazon Redshift ODBC Driver.
Note
Download the package that corresponds to the system architecture of your SQL client tool
or application. For example, if your client tool is 64-bit, install a 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. Navigate to the location where you downloaded the package, and then run one of the following
commands. Use the command that corresponds to your Linux distribution.
• On RHEL 5.0/6.0 and CentOS 5.0/6.0 operating systems, run this command:
yum --nogpgcheck localinstall RPMFileName
Replace RPMFileName with the RPM package file name. For example, the following command
demonstrates installing the 32-bit driver:
yum --nogpgcheck localinstall AmazonRedshiftODBC-32bit-1.x.x.xxxx-x.i686.rpm
• On SLES 11, run this command:
zypper install RPMFileName
Replace RPMFileName with the RPM package file name. For example, the following command
demonstrates installing the 64-bit driver:
API Version 2012-12-01
149
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift