IBM Netezza Sources > Before you begin > Create a connection
  

Create a connection

Create a Netezza connection object in Administrator with the connection details of the IBM Netezza source system.
Before you can use Netezza Connector, install the Netezza client on Windows or Linux. Ensure that you have access to the Secure Agent directory that contains the success and error files. This directory path must be the same on each Secure Agent machine in the runtime environment selected for your connection. Before you create a Netezza connection, be sure to configure the Netezza ODBC and JDBC drivers.
    1In Administrator, select Connections.
    2Click New Connection.
    3Enter the following basic connection details:
    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.
    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.
    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.
    Note:
    If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
    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.
    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.
    4Enter the following advanced connection details:
    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.
    5Click Test Connection.
    6Click Save.