# 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 [this ](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)link. 

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://docs.astera.com/projects/centerprise/en/10/_images/image-20200907120016076.png)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fe7Y8jfgg2MubMmJ6NTyk%2F2.png?alt=media\&token=2c4522c6-8d2c-4acf-b9e9-4d17bc771291)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FjlSgs3EKkU58cWhRIbOX%2F3.png?alt=media\&token=252cf209-79a2-4172-b0e8-a584abba6cac)

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 this option if your data contains special characters. Click *Next.*

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F77N7CVCSPJrqbF6jJqOu%2F4.png?alt=media\&token=c5c3a42f-ec92-46e5-80ed-597476ac534f)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FRHsbq9BD7kAq2YFqvxM6%2F5.png?alt=media\&token=7797db7b-13ed-45e6-96d2-e5a1174ff79a)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FfhYji6rs88HygU4hgSPQ%2F6.png?alt=media\&token=e27bfb7e-033e-4305-ae42-8cc7ec9415eb)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F1JXyHTUyHEjhEOwGdv58%2F7.png?alt=media\&token=b72a314e-8e79-4f4e-b5ad-85e31f5a2c8f)

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FgzK4n7cLnpmoTQWwTBk7%2F8.png?alt=media\&token=0b7e510e-2e78-43c6-9721-54eff4367912)

### 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FSdLW3E7wxdjDY0ZhCOuX%2F01-Oracle-Source-Object.png?alt=media\&token=e971e884-5887-495e-b7fb-b439717efcae)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FoJhOJOd9QpjnEUMus5QD%2F10.png?alt=media\&token=0f01c5f6-c650-4d65-948c-8144a3ee7ba3)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FoFhVzPdmiCEZDFmiC3RZ%2F11.png?alt=media\&token=a6b7d2e1-3adb-4e08-abb3-7118c12d34d4)

4. Provide the credentials to your Netezza user account.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fb2TusbmoCLEwg05dZMvD%2F12.png?alt=media\&token=ea60272b-1ee2-4972-833b-d433ac1c2f0b)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FYjmUUpURijYJ4pONXw8I%2F13.png?alt=media\&token=ce93b0c3-7887-4170-bcb0-2c5f19d86408)

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.

This concludes connecting to the Netezza database in Astera.