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

Creating an ODBC connection

Creating an ODBC connection

You must create an ODBC connection to connect to Amazon Redshift after you configure the ODBC connection.
Perform the following steps to create an Amazon Redshift ODBC connection on the
Connections
page:
  1. Configure the following connection details in the
    Connection Details
    section:
    Property
    Description
    Connection Name
    Name of the ODBC connection.
    Description
    Description of the connection.
    Type
    Type of the connection.
    Select the type of the connection as
    ODBC
    .
  2. Configure the following connection details in the
    Connection Properties
    section:
    Property
    Description
    Runtime Environment
    The name of the runtime environment where you want to run the tasks.
    User Name
    User name of the Amazon Redshift account.
    Password
    Password for the Amazon Redshift account.
    Data Source Name
    Enter the name of the ODBC data source name that you created for the Amazon Redshift database.
    Schema
    Amazon Redshift schema name.
    Code Page
    Select the code page that the Secure Agent must use to read or write data.
    ODBC Subtype
    Enter the value of the
    ODBC Subtype
    field as
    Redshift
    .
    The Amazon Redshift ODBC connection is created successfully.