Adding the Library File to the Windows Registry

For each PowerCenter client system that you want to use with Vertica, you must install a copy of the verticacli9.dll file in the client binary folder. This folder is named client\bin in the PowerCenter install directory. The following path is typical of a PowerCenter installation for Informatica version 9.5.1:

C:\Informatica\9.5.1\clients\PowerCenterClient\client\bin

Copy and Register the verticacli9.dll

Copy the library file to the client binary directory (i.e., client\bin).

Then, add a registry entry to the Windows registry. Adding this entry tells the PowerCenter Designer to load the plug-in library. Perform one of the following to register the plug-in library.

Note: The registry file is specific to Informatica PowerCenter version 9.5.1. The Vertica Plug-in for Informatica has only been tested with this version. If you want to try to use it with another version of PowerCenter, you will need to manually add configuration information to the Windows registry, as explained below.

Register the verticacli9.dll Using a Registry File for Informatica PowerCenter 9.5.x

  1. Double-click the registry file in Windows Explorer:

    • Use vertica-infa951-x86.reg to register the dll on 32 bit machines.
    • Use vertica-infa951-x64.reg to register the dll on 64 bit machines.
  2. When asked if you want to add the contents of the file to the registry, click Yes.

Register the verticacli9.dll Manually for all Other Versions of Informatica (9.6.x, 10.x, et. al.)

  1. Start the registry editor by typing regedit.exe in the Windows Start menu's command run command box.
  2. Navigate to the correct location in the registry.

    For 32-bit versions of Windows:

    HKEY_LOCAL_MACHINE\SOFTWARE\Informatica\
    PowerMart Client Tools\x.x.x\Plugins\Informatica

    For 64-bit versions of Windows:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\
    Informatica\PowerMart Client Tools\x.x.x\
    Plugins\Informatica

    Where x.x.x is the version of Informatica you are using (for example 9.5.1).

  3. Right-click in the right pane of the Registry Editor window. Select New then select String Value.
  4. Change the name of the string value from New Value #1 to VERTICA.

  5. Double-click the new VERTICA entry. When prompted for a new value, enter verticacli9.dll.
  6. Exit the registry editor.