Configuring the PPM Server to Use the Excel Reports

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

Parameter Name Description Add
GlobalNamingResources Defines the data source, user name, and password

<Resource maxIdle="10" driverClassName="com.vertica.jdbc.Driver"

type="javax.sql.DataSource" auth="Container"

name="VerticaDS" url="<vertica_db_url>"

username="<username>"

password="<password>" maxActive="60" validationQuery="select 1 from dual" maxWait="180000" minEvictableIdleTimeMillis="3600000"/

Note: You need to replace <vertica_db_url>, <username>, and <password> with the Vertica database server address, user name, and password of the Vertica database account respectively.

docBase="itg.war" Defines the resource link <ResourceLink type="javax.sql.DataSource" name="VerticaDS" global="VerticaDS"/>
docBase="dashboard.war"

Note: You need to restart the PPM server after you made these changes.