# 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://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FnNb86lUtOkwGNFyoEdER%2F0.jpeg?alt=media)

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

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FFiX5hMQ5ZqhyBeyg67h3%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://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2F70On0QBDj5qgS81Pl5FA%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://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2Fn4rYxmpl8onx9jTXFn9k%2F3.jpeg?alt=media)

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

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

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

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FgBq0Rp8L3UOAt09JdejT%2F5.png?alt=media)

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

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

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2F5JSEFwdGGKAbvxXnfrPL%2F7.png?alt=media)

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

1. We will be using a *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://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FRhl9IvOkVG0yyw1uLCFP%2F8.png?alt=media)

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

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

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

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FttPOIs6tSN5J0addt0gN%2F10.png?alt=media)

4. Provide the credentials to your Netezza user account.

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

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

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2Fu02KbuahiF4Nf0nUF8Gl%2F12.png?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/v/astera-data-stack-v8/dataflows/sources/database-table-source).

This concludes connecting to the Netezza database in Astera.