Amazon Redshift Connectors

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 Amazon Redshift ODBC 64-bit driver.

Install the Amazon Redshift ODBC drivers on the machine where the Secure Agent is installed.

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.

Set the following environment variables for the operating system:

Variable	Description
LD_LIBRARY_PATH	Directory where the Amazon Redshift ODBC driver is installed.
ODBCINI	Directory that contains the odbc.ini file.
ODBCHROME	ODBC installation directory.

Run the following command to export the

odbc.ini

file.

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

Restart the Secure Agent.

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 ODBC connection