skip to main content
Quick Start: Progress DataDirect for ODBC for Amazon Redshift Wire Protocol Driver for UNIX/Linux : Configuring a Data Source
  

Try DataDirect Drivers Now

Configuring a Data Source

The default odbc.ini file installed in the installation directory is a template in which you create data source definitions. You enter your site-specific database connection information using a text editor. Each data source definition must include the keyword Driver=, which is the full path to the driver.
The following examples show the minimum connection string options that must be set to complete a test connection, where xx represents iv for 32-bit or dd for 64-bit drivers, and yy represents the extension. The values for the options are samples and are not necessarily the ones you would use.
[ODBC Data Sources]
Amazon Redshift Wire Protocol=DataDirect 8.0 Amazon Redshift Wire Protocol Driver
[Amazon Redshift Wire Protocol]
Driver=ODBCHOME/lib/xxrsftyy.zz
Database=Redshiftdb1
HostName=RedshiftServer
PortNumber=5439
Connection Option Descriptions:
*Database: The name of the database to which you want to connect by default.
*HostName: The endpoint for the Amazon Redshift cluster to which you want to connect.
*Port Number: The port number of the server listener. The default is 5439.