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 in the Cloud or 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, Type, Connection name, Connection port, Connection server

Extended metadata: Owner, Created time

Schema

Name

Extended metadata: Owner, Created time

Table

Name, Description, Primary keys

Extended metadata: Owner, Created time

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

Extended metadata: Owner, Created time, Return type, Argument Signature

Stored Procedure

Name, Description

Extended metadata: Owner, Created time, Return type, Argument signature, Definition



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

Any lineage for SQL Statements defined via variable statements are not supported.

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

Stored 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.

Note: The following stored procedures are not supported:

  • Stored procedures with multitable inserts. However, multiple separate insert statements that insert into one table are supported.

  • Stored procedure with multiple SELECT and INSERT statements not separated by a semicolon delimiter.

  • Stored procedures used to create tables or any transient tables created during the execution scope of a stored procedure.



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.

In this section: