Installation and Configuration on the PPM Server

You need to perform tasks described in this topic so that the PPM server can leverage the Vertica for PPM function.

Installing the Vertica for PPM Patch

To install the Vertica for PPM patch on PPM, follow these steps:

  1. Copy Vertica_For_PPM_Reporting_Content_Pack.jar from the unzipped package to the PPM server (under <PPM_Home>).
  2. Under the <PPM_HOME>/bin directory of the PPM server, run the following command:

    sh kDeploy.sh -hotfix Vertica_For_PPM_Reporting_Content_Pack.jar

    For more information about the kDeploy.sh script, refer to "Appendix B" of the Installation and Administration Guide.

Note: You can install the patch only when the PPM server is stopped. For information about how to start and stop the PPM server, see the "Starting and Stopping the PPM Server" section in the Installation and Administration Guide.

Configuring server.xml

To leverage the Vertica for PPM Excel reports from PPM, add the following data resource and resource link into the server.xml file in the <PPM_HOME>/server/<Instance Name>/conf/ directory.

  1. Under the GlobalNamingResources tag, add the following data source:

    <Resource maxIdle="10" driverClassName="com.vertica.jdbc.Driver"type="javax.sql.DataSource" auth="Container" name="VerticaDS" url="jdbc:vertica://<host_name>:<port>/<database_name>?<search_path=schemaname>" username="<username>" password="<password>" maxActive="60" validationQuery="select 1 from dual" maxWait="180000" minEvictableIdleTimeMillis="3600000"/>

    Replace <host_name>:<port>/<database_name>?<search_path=schemaname> with the Vertica database server address, and replace <username> and <password> with the user name and password of the Vertica database respectively, as shown in the following example:

    Example: <Resource maxIdle="10" driverClassName="com.vertica.jdbc.Driver" type="javax.sql.DataSource" auth="Container" name="VerticaDS" url="jdbc:vertica://16.186.75.16:5433/PPM?search_path=vdwtarget_report" username="dbadmin" password="password" maxActive="60" validationQuery="select 1 from dual" maxWait="180000" minEvictableIdleTimeMillis="3600000"/>
  2. Under the docBase="itg.war" context tag, add the following resource link:

    <ResourceLink type="javax.sql.DataSource" name="VerticaDS" global="VerticaDS"/>

    For example:

    Example: <Context docBase="itg.war" path="/itg" antiJARLocking="true">
      <Listener className="com.mercury.itg.core.debug.monitor.PPMTomcatMonitor"/>
      <ResourceLink type="javax.sql.DataSource" name="ItgDS" global="ItgDS"/>
      <!--DS_LINK_POSITION_BEGIN-->
      <ResourceLink type="javax.sql.DataSource" name="VerticaDS" global="VerticaDS"/>
      <!--DS_LINK_POSITION_END-->
    </Context>
    
  3. Under the docBase="dashboard.war" context tag, also add the following resource link:

    <ResourceLink type="javax.sql.DataSource" name="VerticaDS" global="VerticaDS"/>

    For example:

    Example: <Context docBase="dashboard.war" path="/dashboard" antiJARLocking="true">
        <Listener className="com.mercury.itg.core.debug.monitor.PPMTomcatMonitor"/>
        <ResourceLink type="javax.sql.DataSource" name="ItgDS" global="ItgDS"/>
        <!--DS_LINK_POSITION2_BEGIN-->
        <ResourceLink type="javax.sql.DataSource" name="VerticaDS" global="VerticaDS"/>
        <!--DS_LINK_POSITION2_END-->
     </Context>
    
  4. Save the changes.
  5. Go to the <PPM_HOME>/bin directory and restart the PPM server with the following command:

    sh kStop.sh -now
    sh kStart.sh