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.
- Place or copy the file vertica.xml to your system.
-
Open a browser and log into the PowerCenter domain's Administration Console.
-
Select the Domain tab, and click Services and Nodes.
-
In the Domain Navigator, click the entry for the repository that you want to connect to Vertica.
-
Under the Properties tab, click Edit to edit the Repository Properties section.
-
In the Operating Mode list box, choose Exclusive, and then click OK.
-
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.
-
Wait until you see the notice, This PowerCenter Repository Service is available.
Register the Plug-in
-
On the Plug-ins tab, click the icon for registering a plug-in.
-
On the Choose a plug-in field, click Browse and select the
vertica.xml
in the folder where you earlier placed the file. -
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. - 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
- On the Properties tab's Repository Properties section, click Edit.
- In the Operating Mode list box, choose Normal.
-
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.