Before you begin

Before you create a catalog source, ensure that you have the information required to connect to the source system.

Perform the following tasks:

•Verify permissions.

•Create a Netezza connection to connect to the IBM Netezza source system.

•Download the NetezzaSQL driver from the IBM website.

•Copy the NetezzaSQL driver JAR file to the following location on the Secure Agent machine:

<Informatica Secure Agent installation directory>/apps/Data_Integration_Server/ext/deploy_to_main/bin/rdtm-extra/Netezza

•After you have copied the NetezzaSQL driver JAR file, restart the Data Integration Service.

Verify permissions

To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.

Permissions for metadata extraction

To extract IBM Netezza metadata, you need account access and permissions to the IBM Netezza source system.

Verify that the administrator grants the View Definition permission to perform the following operations on the IBM Netezza database:

•select on _V_OBJECTS

•select on _V_PROCEDURE

•select on _V_SCHEMA

•select on _V_SEQUENCE

•select on _V_SYNONYM

•select on _V_VIEW

•select on _V_RELATION_COLUMN

•select on _V_RELATION_KEYDATA

•select on _V_DATABASE

•select on _V_JDBC_COLUMNS1

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.
Type	Netezza.
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.

Create endpoint catalog sources for connection assignment

An endpoint catalog source represents a source system that the catalog source references. Before you perform connection assignment, create endpoint catalog sources and run the catalog source jobs.

You can then perform connection assignment to reference source systems to view complete lineage with source system objects.