Installing the Vertica Plug-in for PowerCenter

You must download and install a client and a server component for the Vertica Plug-in for Informatica.

As a first step, download both the client and server components of the plug-in from the myVertica portal.

The client portion of the plug-in (vertica-informatica-client-2.0.1.zip) includes the following files:

The server portion includes the file vertica-informatica-plugin-server.jar.

Note: Each server type requires the Java 6.0 run-time environment.

Installing the Vertica plug-in is a multi-step process. The following sections explain these steps in greater detail, using a simple example.

  1. Register the plug-in's metadata with the PowerCenter Repository Service with which you want to access Vertica. Follow the procedures in Registering the Plug-in's Metadata.
  2. Add the verticacli9.dll library file to the Windows registry. Follow the procedures in Adding the Library File to the Windows Registry.
  3. Copy the server plug-in to the PowerCenter server javalib directory. Follow the procedures in Copying the Plug-in Library on the Server.