PowerExchange for PostgreSQL User Guide for PowerCenter

Back Next

Configuring PostgreSQL ODBC Connection on Windows

Before you establish an ODBC connection to connect to PostgreSQL on Windows, you must configure the ODBC connection.

Perform the following steps to configure an ODBC connection on Windows:

Run the

odbcad32.exe

file.

The

ODBC Data Sources Administrator

dialog box appears.

Click

System DSN

The following image shows the

System DSN

tab on the

ODBC Data Sources Administrator

dialog box:

Click

Add

On the

Create New Data Source

dialog box, select the PostgreSQL driver.

On the

ODBC PostgreSQL Wire Protocol Driver Setup

dialog box, specify the following connection properties:

Property	Description
Data Source Name	Name of the data source.
Description	Description of the data source.
Host Name	Name of the PostgreSQL server.
Port Number	Port number of the PostgreSQL server.
Database Name	Name of the PostgreSQL database.

The following image shows the connection properties configured for the ODBC connection:

Click

Test Connect

to test the connection that you configured.

On the

Logon to PostgreSQL Wire Protocol

dialog box, specify the credentials of your PostgreSQL database.

Click

The PostgreSQL ODBC connection is configured successfully on Windows.

After you configure the PostgreSQL ODBC connection, you must create an ODBC connection to connect to PostgreSQL.