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:
vertica.xml
contains the metadata definition needed by the PowerCenter repository to allow communication between PowerCenter and Vertica.
-
verticacli9.dll
is a library file you add to your Windows registry. vertica-infa951-x86.reg
is a registry file you can use to register the dll on 32-bit machines for Informatica PowerCenter 9.5.1.vertica-infa951-x64.reg
is a registry file you can use to register the dll on 64-bit machines for Informatica PowerCenter 9.5.1.
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.
- 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.
- Add the
verticacli9.dll
library file to the Windows registry. Follow the procedures in Adding the Library File to the Windows Registry. - Copy the server plug-in to the PowerCenter server
javalib
directory. Follow the procedures in Copying the Plug-in Library on the Server.