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.
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