Data Integration Connections > Connection properties > Netezza connection properties
  

Netezza connection properties

When you set up a Netezza connection, you must configure the connection properties.
The following table describes the Netezza connection properties:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
Database
The name of the Netezza database.
Schemaname
The schema used for the Netezza source or target.
Servername
The Netezza database host name.
Port
Network port number used to connect to the database server.
Default is 1521.
Driver
The Netezza ODBC driver name, NetezzaSQL, used to connect to the Netezza database.
Runtime Additional Connection Configuration
Additional run-time attributes required to fetch data.
For example, securityLevel=preferredUnSecured;caCertFile =
Metadata Additional Connection Configuration
The values to set the optional properties of the JDBC driver to fetch the metadata.
Username
Database user name with the appropriate read and write database permissions to access the database.
Password
Password for the database user name.