Netezza Integration Requirements

The following are the prerequisites necessary for IBM Automatic Data Lineage to connect to this third-party system, which you may choose to do at your sole discretion. Note that while these are usually sufficient to connect to this third-party system, we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including for their performance.

• IBM PureData System for Analytics: version 7.2 or newer (remote)

• User having the following rights for each extracted database:

  • LIST — for connecting to the database

  • SELECT on the following system tables / views (granted to every user by default, unless explicitly revoked):

    • _t_environ with value set for HOSTNAME or manually defined User-set host name in the connection form
    • _v_database
    • _v_schema
    • _v_table
    • _v_extobject
    • _v_view
    • _v_relation_column
    • _v_relation_keydata
    • _v_procedure
    • _v_function
    • _v_aggregate
    • _v_sequence
    • _v_synonym

  • In each extracted schema:

    • LIST — to access the schema
    • SELECT on the following management table (must be explicitly granted):
      • _vt_sequence
    • LIST on all relevant object types:
      • GRANT LIST ON <db>.<schema>.SEQUENCE TO <manta user>;
      • GRANT LIST ON <db>.<schema>.SYNONYM TO <manta user>;
      • GRANT LIST ON <db>.<schema>.TABLE TO <manta user>;
      • GRANT LIST ON <db>.<schema>.EXTERNAL TABLE TO <manta user>;
      • GRANT LIST ON <db>.<schema>.FUNCTION TO <manta user>;
      • GRANT LIST ON <db>.<schema>.AGGREGATE TO <manta user>;
      • GRANT LIST ON <db>.<schema>.PROCEDURE TO <manta user>;
      • GRANT LIST ON <db>.<schema>.VIEW TO <manta user>;
      • GRANT LIST ON <db>.<schema>.MATERIALIZED VIEW TO <manta user>;

• Connection parameters:

  • Name or IP address of the Netezza database
  • Port on which the Netezza database listens for JDBC connections (default is 5480)
  • Initial database (can be any of the extracted databases)
  • User name
  • User password

• Database must be accessible via network

• For netezza.sqlextensions.database and netezza.sqlextensions.schema properties name of the database and schema where IBM SQL Extensions toolkit is installed

Known Unsupported Features

Automatic Data Lineage does not support the following Netezza features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.

• Lineage through dynamically executed code through EXECUTE IMMEDIATE
• Lineage through external tables
• Synonyms are included in the data lineage visualization only if they are referenced in the SQL queries, procedures, or functions. If they are not referenced, they will not appear in either the flow viewer or the object list.
• When synonym of the table is used within the SELECT statement, attributes of the synonym should be specified with the respective schema, otherwise such attribute will be marked as deduced. E.g. instead of "SELECT syn_name.col_name ..." use "SELECT schema_name.syn_name.col_name ..."
• Synonyms for built-in routines and functions from Netezza Extension toolkit are not supported and produce warning in the log.