Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Configuring Amazon Redshift ODBC connection on Linux

Configuring Amazon Redshift ODBC connection on Linux

Before you establish an ODBC connection to connect to Amazon Redshift on Linux, you must configure the ODBC connection.
Perform the following steps to configure an ODBC connection on Linux:
  1. Download the Amazon Redshift ODBC drivers from the AWS website.
    You must download the Amazon Redshift ODBC 64-bit driver.
  2. Install the Amazon Redshift ODBC drivers on the machine where the Secure Agent is installed.
  3. Configure the
    odbc.ini
    file properties in the following format:
    [ODBC Data Sources] driver_name=dsn_name [dsn_name] Driver=path/driver_file Host=cluster_endpoint Port=port_number Database=database_name
  4. Specify the following properties in the
    odbc.ini
    file:
    Property
    Description
    ODBC Data Sources
    Name of the data source.
    Driver
    Location of the Amazon Redshift ODBC driver file.
    Host
    Location of the Amazon Redshift host.
    Port
    Port number of the Amazon Redshift server.
    Database
    Name of the Amazon Redshift database.
    You must specify the
    Host
    ,
    Port
    , and
    Database
    values from the JDBC URL.
  5. Run the following command to export the
    odbc.ini
    file.
    Export ODBCINI=/<odbc.ini file path>/odbc.ini
  6. Restart the Secure Agent.
    The Amazon Redshift ODBC connection on Linux is configured successfully.
After you configure the Amazon Redshift ODBC connection, you must create an ODBC connection to connect to Amazon Redshift.
For more information about how to create an ODBC connection to connect to Amazon Redshift, see Creating an ODBC connection