Centerprise provides connectivity with Netezza database appliance. Before you can connect to Netezza using Centerprise, you need to install and configure the ODBC driver for Netezza. This article explains the steps to install the Netezza ODBC driver.
Note: You can find the Netezza ODBC driver on IBM’s website. For your convenience, you can use this link. You need to have a valid IBM login ID to access the installation package for the driver.
Once you have the installer zip file, follow the steps below to install the driver:
1. Run the nzodbcsetup.exe setup and the following screen will appear. Select your preferred language and click OK.
2. The next screen will guide you through the next steps in the installation process. Click Next.
3. On the next screen, select the bit size of the driver. This needs to match the Centerprise client bitness. I’ll leave it as default (64-bit).
4. On the Character Translation Option screen, you can check the box next to the provided option if you want to convert your character data and optimize it. If you have special characters in your data, leave the option unchecked.
5. On the next step you will be asked if you want to install C++ libraries. Select Install and click Next.
6. Installation summary will be shown to you on the next screen. Click Install.
7. You will be directed to the following screen when the installation is successfully completed. Click Done.
8. To read data from IBM Netezza database in Centerprise, open the dataflow window in Centerprise and drag-and-drop the Database Source object.
9. Double-click on the dropped object and go to the Properties. On the Database Connection screen, select Netezza from the drop-down list next to the data provider.
10. Fill in the required details to establish the connection with the database.
11. Now when you configure and test Netezza’s connection in Centerprise, you should see the following message.
To get more information on how to work with Netezza in Centerprise, read this article on working with database sources.
Was this article helpful? Let us know in the comments section below.