JDBC Driver for Netezza
Overview
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 /kit/sbin/nzjdbc3.jar (For example, /nz/kit/sbin/nzjdbc3.jar).
This Netezza JDBC driver is provided by Netezza and can be used in Collibra Catalog.
To register Netezza-provided sources, use the section ‘Collibra provided drivers’ in Collibra Catalog. 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.
JDBC drivers can retrieve the following database components:
-
- Schemas
- Tables
- Views
- Columns
- Primary keys
- Foreign keys
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 calculation of 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
Compatibility
- Netezza 7.2 and newer
- Collibra Data Intelligence Cloud
- Collibra 5.7.5 and newer
Dependency
- N/A
License and Usage Requirements
- Collibra Catalog
Release History
No previous versions of this listing is available.
Use of this solution requires a license to Collibra Data Intelligence Cloud and the purchase of Metadata Integrations at a volume commensurate with desired use. Please contact your sales representative or Customer Success Manager for more information.
