PowerExchange for Amazon Redshift User Guide for PowerCenter

Back Next

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:

Download the Amazon Redshift ODBC drivers from the AWS website.

You must download the 32-bit or 64-bit driver based on your Linux system.

Install the Amazon Redshift ODBC drivers on the machine that hosts the PowerCenter Integration Service.

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

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.

Add the

odbc.ini

file path in your source file in the following format:

ODBCINI=/<odbc.ini file path>/odbc.ini

Restart the PowerCenter Server.

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 Amazon Redshift ODBC Connection