Before You Install Vertica for PPM Content Pack

Before you install the Vertica for PPM Content Pack, make sure the following servers are available for use:

  • A server with the PPM Oracle database installed

    To successfully install the Vertica for PPM Content Pack, you need to have an account of the PPM database with the privilege to read tables in the database.

  • Three servers with the HP Vertica database cluster installed

    The Vertica Database cluster is used to store data that is extracted from the PPM database. A three-node database cluster is required.

    To successfully install the Vertica for PPM Content Pack, you need to either have a Superuser account of the Vertica database or an account with the following privileges:

    • Create Schema
    • Drop Schema
    • Create View
    • Drop View
    • Create Table
    • Drop Table
    • Update Table
    • Select From Table
    • Select From View
    • View V_Catalog

    Make sure the Vertica database server meet the hardware requirements described in the HP Vertica Hardware Planning Guide.

    For details about how to install Vertica databases, refer to the HP Vertica Analytic Database Installation Guide.

    Note: Besides the system requirements listed in the HP Vertica Analytic Database Installation Guide, you also need to install Java SE Runtime Environment (JRE) version 1.7.0_55 or later on the server.

    For information about how to install Java on HP Vertica hosts, refer to Installing Java on HP Vertica Hosts in the Extending HP Vertica Guide.

  • A server where the Vertica for PPM Content Pack can be installed

    You need to prepare a server where the Vertica for PPM Content Pack can be installed. This server will be used to provide service of Vertica for PPM.

    Make sure the server meet the following system requirements before you install the Vertica for PPM Content Pack.

    System requirements
    Components Requirements
    Processor 64-bit; 2 cores (at minimum) or 4 cores (recommended)
    RAM 8 GB (at minimum) or 16 GB (recommended)
    Hard disk 100 GB with proper maintenance; you may need more disk capacity depending on the size of the source data.
    Operating system Red Hat Enterprise Linux 6 (64-bit)
    Java SE Development Kit (JDK) software JRE version 1.7.0_55 or later