Unsupported Screen Size: The viewport size is too small for the theme to render properly.
Published by Collibra Catalog

JDBC Driver for Netezza

Request Information
Rating
Certified Paid

Overview

The Netezza JDBC driver can be used in the Collibra Catalog in the section ‘Collibra provided drivers’ to register Netezza sources. Leveraging this driver, Collibra Catalog will be able to register database information and extract the structure of the source into its schemas, tables and columns.

Collibra JDBC drivers can retrieve the following technical metadata from the source:

  • Schemas
  • Tables
  • Views
  • Columns
  • Primary keys
  • Foreign keys

Warning: 

This driver is not downloadable from a public website. You will need to retrieve the JDBC Driver available as part of your Netezza server installation. The JDBC driver can be copied from your Netezza database server, the JAR file is typically located in <netezza_installation_directory>/kit/sbin/nzjdbc3.jar (For example, /nz/kit/sbin/nzjdbc3.jar). 

More details

Release Notes

The driver has been certified with the username/password authentication for the following:

  • Ingestion of technical metadata from the source.
  • Profiling of the registered data source and calculate statistics that describe the data.

Data Profiling is not supported for tables with columns of National Character types (NVARCHAR and NCHAR).
Profiling of such tables will fail with an error as follows:
Table 'XXX' profiling/sampling was skipped for an unknown reason. Please check jobServer logs for more details.

Within the JobServer logfile the following detailed error:

job.catalog.DataSourceReader$ - SQLException trying to read table XXX: org.netezza.error.NzFeatureNotSupportedException: netezza.feature.not.supported

Dependencies
  • Collibra Platform 5.7.5 and newer
  • Netezza 7.2 and newer
License and Usage Requirements
  • Collibra Catalog
  • Metadata Connector

No previous versions of this listing is available.

Support is provided for the template as downloaded from the Marketplace, without changes to the way it works. These drivers are designed to only work with Collibra Catalog and cannot be used for other purposes.

Submit a support ticket

Use of this solution requires a license to Collibra Catalog and the purchase of Metadata Connectors at a volume commensurate with desired use. Please contact your sales representative or Customer Success Manager for more information.

Leave a review