Registering the Plug-in's MetaData

The PowerCenter repository needs information about the Vertica plug-in in order to enable clients to use it. This information is supplied in an XML-format file named vertica.xml.

Perform the following to register the plug-in's metadata.

Switch to Exclusive Mode

Before you can register the plug-in's metadata, you must logon to PowerCenter and switch to exclusive mode to ensure that the repository does not change while you are registering the plug-in.

  1. Place or copy the file vertica.xml to your system.
  2. Open a browser and log into the PowerCenter domain's Administration Console.

  3. Select the Domain tab, and click Services and Nodes.

  4. In the Domain Navigator, click the entry for the repository that you want to connect to Vertica.

  5. Under the Properties tab, click Edit to edit the Repository Properties section.

  6. In the Operating Mode list box, choose Exclusive, and then click OK.

  7. In the Restart Service prompt, click OK to confirm switching to exclusive mode.

    The Repository Service may take from a few moments to several minutes to restart and re-enable itself.

  8. Wait until you see the notice, This PowerCenter Repository Service is available.

Register the Plug-in

  1. On the Plug-ins tab, click the icon for registering a plug-in.

  2. On the Choose a plug-in field, click Browse and select the vertica.xml in the folder where you earlier placed the file.

  3. Under the Repository Authentication section, enter your repository username and password.

    Note: If you are upgrading from a previously installed plug-in version, select the checkbox, Update existing plug-in registration. Otherwise leave the box cleared.
  4. Click OK to upload the metadata file. The PowerCenter Administration Console uploads the metadata file and registers the Vertica plug-in data.

Switch Back to Normal Mode

  1. On the Properties tab's Repository Properties section, click Edit.
  2. In the Operating Mode list box, choose Normal.
  3. In the Restart Service prompt, click OK to to confirm switching to normal mode.

    The Repository Service may take from a few moments to several minutes to restart and re-enable itself.