Connections > Netezza connection properties > Connect to Netezza
  

Connect to Netezza

Let's configure the Netezza connection properties to connect to Netezza.

Before you begin

Before you get started, you need to get Netezza database and authentication details from your Netetzza account. You also need to install Netezza client and drivers.
Check out Prerequisites to learn more about the tasks you must perform.

Connection details

The following table describes the basic connection properties:
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.
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
This property is not supported by Data Ingestion and Replication.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
For information about how to configure and use a secrets manager, see Secrets manager configuration.
Runtime Environment
The name of the runtime environment where you want to run tasks.
Specify a Secure Agent, Hosted Agent, or serverless runtime environment.
Specify a Secure Agent.
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.
Username
Database user name with the appropriate read and write database permissions to access the database.
Password
Password for the database user name.

Advanced settings

The following table describes the advanced connection properties:
Property
Description
Driver
The Netezza ODBC driver name that is used to connect to the Netezza database.
The Netezza ODBC driver name is NetezzaSQL.
Runtime Additional Connection Configuration
Additional runtime 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.