When you install an IBM Netezza ODBC driver, the installation program creates an entry for a system data source called NZSQL. You then configure that data source to connect to a Netezza appliance data source. You can also configure a user data source.

The JDBC driver processes the JDBC API interfaces, classes, and methods in the Java application. The driver also returns results to the Java virtual machine. Installing the JDBC driver (UNIX and Linux) You can have only one JDBC driver installed on your system at a time.

You can connect to Netezza from WinSQL using ODBC, as follows:

1. Confirm that you have the Netezza ODBC driver for Windows installed.
2. Launch WinSQL.
3. If it is not already selected, select MS Access Database from the pull-down as the Data Source Name.
4. Click the Specify connection string radio button.

First, locate the installation of the Netezza driver. Under the Netezza installation, the following directories appear – /bin, /lib, /license, /sys, and /tmp. Navigate to the bin directory by typing: cd bin. From the bin folder, you can retrieve the Netezza driver version by typing: ./nzrev.

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

1. Open the folder in which the ODBC data source file is installed.
2. Run the. odbcad32.exe. file.
3. System DSN. . The.
4. Add. . The.
5. Select. NetezzaSQL. and click.
6. Configure. .
7. Specify the following DSN properties: Property.
8. Click. OK.

On a new IBM Netezza appliance, there is one main database, SYSTEM, and a database template, MASTER_DB. IBM Netezza uses the MASTER_DB as a template for all other user databases that are created on the system.

WinSQL Configuration

1. Create a query.
2. Select. File. New Connection. . The. ODBC Data Source.
3. Enter the ODBC data source properties. The following table describes the ODBC data source properties that you can enter: Option. Description. Data Source Name. Select the ODBC data source name for the SQL data service.
4. Click. OK. .

From the Windows taskbar, click Start and then select Programs, Administrative Tools, Data Sources (ODBC). Click the System DSN tab and then click Add. Select Pervasive ODBC Client Interface and then click Finish.

IBM Netezza is a powerful and highly parallelized Data Warehousing system that is simple to administer and to maintain. This system is an appliance that is purpose-built for data warehousing.