Install the Amazon Redshift ODBC Driver on Linux Operating Systems
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:
One of the following Linux distributions (32- and 64-bit editions):
Red Hat Enterprise Linux (RHEL) 5.0/6.0/7.0
SUSE Linux Enterprise Server (SLES) 11
75 MB of available disk space
One of the following ODBC driver managers:
iODBC Driver Manager 3.52.7 or later. For more information about the iODBC driver manager and links to download it, go to the Independent Open Database Connectivity website.
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)
To install the Amazon Redshift ODBC driver
Download one of the following, depending on the system architecture of your SQL client tool or application:
The name for both of these drivers is Amazon Redshift ODBC Driver.
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 firstname.lastname@example.org to arrange an appropriate license.
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
RPMFileNamewith 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:
RPMFileNamewith the RPM package file name. For example, the following command demonstrates installing the 64-bit driver:
zypper install AmazonRedshiftODBC-1.x.x.xxxx-x.x86_64.rpm
When you have finished installing the drivers, configure them for use on your system. For more information on driver configuration, see Configure the ODBC Driver on Linux and Mac OS X Operating Systems.
Previous ODBC Driver Versions
Download a previous version of the Amazon Redshift ODBC driver only if your tool requires a specific version of the driver. For information about the functionality supported in previous versions of the drivers, go to the Amazon Redshift ODBC Driver Release Notes.
The following are the previous versions of the 32–bit driver:
The following are the previous versions of the 64–bit driver: