Menu
Amazon Redshift
Management Guide (API Version 2012-12-01)

Install the Amazon Redshift ODBC Driver on Linux 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:

  • One of the following Linux distributions (32- and 64-bit editions):

    • Red Hat Enterprise Linux (RHEL) 5.0/6.0/7.0

    • CentOS 5.0/6.0/7.0

    • Debian 7

    • SUSE Linux Enterprise Server (SLES) 11

  • 75 MB of available disk space

  • One of the following ODBC driver managers:

  • 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:

    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 redshift-pm@amazon.com 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:

      Copy
      yum --nogpgcheck localinstall RPMFileName

      Replace RPMFileName with the RPM package file name. For example, the following command demonstrates installing the 32-bit driver:

      Copy
      yum --nogpgcheck localinstall AmazonRedshiftODBC-32bit-1.x.x.xxxx-x.i686.rpm
    • On SLES 11, run this command:

      Copy
      zypper install RPMFileName

      Replace RPMFileName with the RPM package file name. For example, the following command demonstrates installing the 64-bit driver:

      Copy
      zypper install AmazonRedshiftODBC-1.x.x.xxxx-x.x86_64.rpm

Important

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: