Configuring pushdown optimization for Amazon Redshift using the ODBC Connector

Back Next

Create an Amazon Redshift 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:

Configure the following connection details in the

Connection Details

section:

Property	Description
Connection Name	Name of the ODBC connection. For example, Redshift ODBC.
Description	Description of the connection.
Type	Type of the connection. Select the type of the connection as ODBC .

Configure the following connection details in the

Connection Properties

section:

Property	Description
Runtime Environment	Runtime environment that contains the Secure Agent you can use to access the system.
User Name	User name to log in to Amazon Redshift.
Password	Password to log in to Amazon Redshift.
Data Source Name	Enter the name of the ODBC data source name that you created for the Amazon Redshift database.
Schema	Name of the Amazon Redshift schema.
Code Page	The code page of the database server or flat file defined in the connection.
ODBC Subtype	Enter the value of the ODBC Subtype field as Redshift .
Driver Manger for Linux	The driver that the Amazon Redshift ODBC driver manager sends database calls to.

You can use the configured connection in a mapping. You can then enable pushdown optimization on the Schedule tab in the mapping task.