PowerExchange for Amazon Redshift User Guide

Back Next

Configuring a System DSN on Linux

Configure a System DSN on Linux to use ODBC connection to connect to Amazon Redshift.

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 Data Integration Service.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.