Skip to main content

About the Netezza collector

Use this collector to harvest metadata from Netezza Performance Server. It collects metadata for database information, schemas, tables, views, materialized views, functions, stored procedures, and columns. It also supports Lineage for views, materialized views, and procedures.

Important

Before you begin, make sure you have obtained the Netezza JDBC driver from IBM.

Important

The Netezza collector can be run on-premise using Docker or Jar files.

What is cataloged

The collector catalogs the following information.

Note

The collector harvests all versions of overloaded functions and stored procedures. Each version has its own title/name in the catalog, but a distinct identifier.

Table 1.

Object

Information cataloged

Database

Identifier, Created time, Owner, Created time, Type, Connection name, Connection port, Connection server

Schema

Name, Created time, Schema owner

Table

Name, Created time, Description, Owner, Primary keys

View

Name, Definition

Materialized View

Name, Definition

Column

Name, JDBC type, Type, Type Name, Is Nullable, Default value, Key type (Primary, Foreign), Size, Index

Function

Name, Description, Owner, Created time, Return type

Stored Procedure

Name, Definition, Owner, Description, Created time, Return type, Argument signature



Relationship between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.

Table 2.

Resource page

Relationship

Schema

Contains Tables and Views/Materialized views. Has Stored Procedures and Functions

Table

Part of schema. Contains columns. Was generated by Stored Procedures

View/Materialized View

Part of schema

Column

Part of Table or View/Materialized view



Lineage for Netezza

Table 3.

Object

Lineage available

View/Materialized View

The collector identifies the associated column in an upstream view or table:

  • Where the data is sourced from

  • That filter the rows via WHERE/HAVING

Procedures

The collector identifies:

  • The associated column in an upstream view/Materialized view or table:

    • Where the data is sourced from

    • That sort the rows via ORDER BY

    • That filter the rows via WHERE/HAVING

    • That aggregate the rows via GROUP BY

  • The downstream table that has its tables updated.



Netezza version supported

The collector supports the following Netezza version:

  • Netezza Performance Server 11.2.2.1

Authentication supported

The Netezza collector supports username and password authentication.