Netezza is IBM's database that is able to run SQL queries. You can use SQL commands to create and manage your Netezza databases, user access, and permissions for the databases, as well as to query and modify the contents of the databases.

Prerequisites

Preparing Netezza DB

Set up your Netezza database accordingly.

Uploading the Database Driver

Set up the database driver in the 'Admin' tab.

Configuring Netezza DB as a Connection

To configure Netezza DB as a connector:

  1. Click the "+" button and select "Connection" or right-click in the File Browser and select "Create New" → "Connection". The "New Connection" tab appears in the menu bar.
     or 
  2. Select "Netezza" from the drop-down and confirm with "Next". The type is displayed in the drop-down.
     
  3. Enter the connection string from the database driver and select the connection usage from the drop-down. 
     
  4. Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next". The 'Save Connection' tab opens.
     
  5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.
     
  6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Netezza connection is finished. 

Importing Data with a Netezza Connector 

Find how to import from Netezza here.

Exporting Data with a Netezza Connector

Find how to export to Netezza here.