1. Using the Netezza Adapter with Oracle Integration 3
  2. Create a Netezza Adapter Connection
  3. Prerequisites for Creating a Connection

Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the Netezza Adapter:

Netezza Database Prerequisites

  • Ensure that you have write permissions on the database.

  • Ensure that you have the required permissions to run SQL statements against the Netezza database.

  • Know the database hostname or IP address and the port number.

  • Know the database name.

  • Know the user name and password for connecting to the database.

  • Install the connectivity agent. The connectivity agent is required to connect Oracle Integration with a Netezza on-premises database. See Configure the Endpoint Access Type.

  • Download a Java Database Connectivity (JDBC) .jar file and place it in the third-party lib folder while configuring the connectivity agent. A JDBC driver enables a Java application to interact with a database. See Installing and uninstalling the client tools software and Installing and configuring JDBC.

Bulk Data Import Operation Prerequisites

  • Ensure that you have admin privileges.
  • Ensure that you have read, write, create, and delete file permissions for the mount location.
  • Ensure that the mount path is local to the Netezza database and accessible by the Netezza database.
  • Ensure that file header names match with target table fields and the order of fields is the same.