The Netezza connector

With the Netezza connector, IBM InfoSphere Information Server tools can connect to a Netezza database, import database metadata into the InfoSphere Information Server metadata repository, and access data in the database. The connector provides a single way to work with Netezza data when you design a job.

You can use the Netezza connector to:

• Read, write, and look up data in Netezza database tables.
• Create, drop, and truncate tables.
• Perform normal and sparse lookup operations.
• Import the following metadata into a job:
  • Table and column definitions
  • Lists of Netezza databases
  • Tables
  • Views
  • Database aliases
• Work with all Netezza data types with the exception of interval types.
• Work with national language data.