# Connecting to Netezza Database

Netezza is a data warehouse and analytics platform that caters to a wide variety of data-related business needs. It offers meaningful and sophisticated insights on large data volumes that are crucial to enterprises of all kinds.

Astera offers in-built connectivity to Netezza databases using a range of objects available in the toolbox. The connection can be established primarily via the *Database Table Source* and *Destination* objects.

Moreover, the Netezza database can also be accessed through and used in *Database Lookup* and *SQL Statement Lookup* in Transformations, *SQL Script Task* in a workflow, and *Database Diff Processor* Database Write Strategies.

In this article, we will be looking at how Netezza can be configured as a database in Astera. However, before doing so, we will need to install the ODBC driver for Netezza.

## **Installing the ODBC Driver for Netezza**

1. The Netezza ODBC driver is available on IBM’s website and can be downloaded from [here](https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=PureData%20System%20for%20Analytics\&product=ibm/Information+Management/Netezza+NPS+Software+and+Clients\&release=NPS_7.2.1\&platform=All\&function=all). To access the installation package, you will require a valid IBM login ID.
2. Once you have acquired the installer zip file, run the *nzodbcsetup.exe* setup. The installer window will appear. Select a language and click *OK*.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FdRZkM4bPW2TSU13yphQm%2F0.jpeg?alt=media)

3. The next screen will provide some guidelines on the installation process. Click *Next.*

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2Fn9XV9QHITFh5tGD5jct3%2F1.jpeg?alt=media)

4. On the next screen, choose an appropriate bit size for the driver according to your target OS. Click *Next.*

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FCfDDsitw3Y2uODsZS1iA%2F2.jpeg?alt=media)

5. The *Optimize for ASCII character set* option can be selected on the *Character Translation* screen if you wish to convert and optimize your character data. Do not select the option if your data contains special characters. Click *Next.*

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2F3e1tTCimjrZg0HSvAG1k%2F3.jpeg?alt=media)

6. The next screen will provide the option to install C++ libraries. Select *Install,* and click *Next*.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FkGnrIeribEFiSw6lhD4V%2F4.jpeg?alt=media)

7. The *Pre-Installation Summary* screen gives a brief overview of the product being installed. Click *Install*.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FJ5Tzng1jFJiH6NWhXG4s%2F5.jpeg?alt=media)

8. Wait for the installation process to successfully complete. On the final screen, click *Done.*

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FKxep2Yyee305U81avZHk%2F6.png?alt=media)

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2F6Lw3vXVCsvdAbRgUQCqB%2F7.jpeg?alt=media)

## **Using Netezza in Database Table Source in Astera**

1. We will be using a [*Database Table Source*](https://documentation.astera.com/astera-data-stack-v9/dataflows/sources/database-table-source) object to establish a connection with the Netezza database. To configure the properties of the object, right-click on its header and select *Properties.*

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2Fq6Ui7Z68icS9YIGXRQUU%2F8.png?alt=media)

2. A *Database Connection* window will appear as soon as you click *Properties.*

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FkGZ01d5cBXqjDwk4aPJi%2F9.png?alt=media)

3. On the *Database Connection* window, select Netezza in the *Data Provider* drop-down list.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FUlKUXX7354xEgBjN5G4p%2F10.jpeg?alt=media)

4. Provide the credentials to your Netezza user account.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FpO7VOIhtBjMYDkA0eBIc%2F11.png?alt=media)

5. *Test Connection* to ensure that your connection is successful. When the connection is established, click *Next.*

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FMmKWM30nXA6b8uLqGsSQ%2F12.jpeg?alt=media)

The connection to the Netezza database has been successfully established. You can now pick a table from the Netezza database and use the data in your dataflow.

To learn more about how to pick a table from a database source and specify other reading options, click [here](https://documentation.astera.com/astera-data-stack-v9/dataflows/sources/database-table-source#database-table-options).

This concludes connecting to the Netezza database in Astera.