IBM Netezza
IBM Netezza is a data warehouse and advanced analytics platform designed for high-performance querying and analysis of large datasets. It uses a massively parallel processing (MPP) architecture with specialized hardware (including FPGA acceleration) to deliver fast query execution and simplified data management.
Prerequisites
The following prerequisites must be met for a user to create and test a successful connection.
- IBM Netezza server must be accessible from the iceDQ server.
- Valid credentials to access the database.
- IBM Netezza JDBC version 7.0 or above.
Authentication Mechanism
The following authentication mechanism is supported.
- Username & Password
Connection Properties
Use the following properties to create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Sales_Prod_conn |
| Driver * | Driver used to establish the connection. By default, one driver is available. | Netezza Native JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format supported by the driver: jdbc:netezza://[host]:[port]/[database] | jdbc:netezza://192.168.44.31:5480/prod_db |
| Host * | IP address or hostname of the Netezza database server. | netezza.acme.com or 192.168.44.31 |
| Port * | Port on which the server listens. Default is 5480 for Netezza. | 5480 |
| Database * | Name of the target database in Netezza. | prod_db |
| Type * | The connection type – either System Connection or User Connection. Refer Connections for more details. | System or User |
| Username * | Database login username with necessary privileges. | john_doe |
| Password * | Password associated with the specified username. | nz_password |
Custom Properties
Custom properties are optional connection parameters in the Netezza driver, allowing customization of settings like timeouts and proxy configurations. A list of supported properties is available here. The availability and behavior of custom connection properties may vary depending on the version of the Netezza JDBC driver in use.