Netezza Connector

Back Next

Configuring the Netezza ODBC driver on Windows

Before you establish an ODBC connection to connect to Netezza on Windows, you must configure the Netezza ODBC driver and create the Netezza data source name.

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

Open the folder in which the ODBC data source file is installed.

Run the

odbcad32.exe

file.

The

ODBC Data Source Administrator

dialog box appears.

Click

System DSN

The

System DSN

tab appears.

The following image shows the System DSN

tab

on the ODBC Data Source Administrator (64-bit) dialog box:

Click

Add

The

Create New Data Source

dialog appears.

The following image shows the Create New Data Source dialog box where you can select the Netezza data source:

Select

NetezzaSQL

and click

Finish

Click

Configure

The Netezza Configuration dialog box appears.

The following image shows the DSN options tab:

In the Netezza Configuration dialog box, you can configure the DSN properties.

Specify the following DSN properties:

Property	Description
Data Source	Name of the data source.
Description	Description for the data source.
Server	Domain name of your Netezza account.
Port	Port number used to connect to Netezza.
Database	Name of the Netezza database.
Schema	Name of the Netezza schema.
User Name	Username to access the Netezza database.
Password	Password to access the Netezza database.