PowerExchange for Amazon Redshift User Guide

Back Next

Creating an Amazon Redshift ODBC Connection

Create an Amazon Redshift ODBC connections to access Amazon Redshift read and write data objects.

In the Developer tool, click

New Connections

The

Select a Connection Category

box appears.

Select

Connections

Specify the name, description, and location for the connection.

Select

Type

ODBC

and click

Configure the following connection properties:

Relational Connection Property	Description
User Name	Enter the user name to connect to the Amazon Redshift database.
Password	Enter the password to connect to the Amazon Redshift database.
Connection String	Enter the name of the ODBC data source that you created for teh Amazon Redshift database on the Data Integration Service host machine. For example: AmazonRSDW_ODBC_SERVER
Code Page	Select the code page that the Data Integration Service uses to read or write data.
ODBC Provider	Select AWS Redshift .