Search

Netezza Connector

Netezza Connector

Back Next

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
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Type	Netezza.
Runtime Environment	The name of the runtime environment where you want to run tasks. Specify a Secure Agent, Hosted Agent, or serverless runtime environment.
Database	The name of the Netezza database.
Schemaname	The schema used for the Netezza source or target . Schema name is case sensitive.
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.

Connections for Netezza

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.