Installing Vertica for PPM Content Pack

Installing Vertica-Data-Warehouse1.0.bin

To install the Vertica for PPM Content Pack, follow these steps:

  1. Unzip the Vertica_for_PPM_Install_Bundle_1.0.zip file that is downloaded from the Micro Focus Marketplace, as described in Obtaining Installation Bundle of Vertica for PPM Content Pack 1.0
  2. Copy Vertica-Data-Warehouse1.0.bin to any directory on the server where you want the Vertica for PPM Content Pack to be installed.
  3. Go to the directory that contains Vertica-Data-Warehouse1.0.bin and run the following command:

    sh Vertica-Data-Warehouse1.0.bin

  4. Type in a directory where you want to install the Vertica for PPM Content Pack, for example, /HOME/PPMVDW, and press Enter.

    Note: Make sure that the capacity of the directory is 10 GB at minimum and that you have Read and Write access to the directory.

Vertica-Data-Warehouse1.0.bin is installed.

Configuring Vertica for PPM Data Warehouse

After you have installed the data warehouse, you need to configure the Vertica for PPM data warehouse as the system prompts, so as to associate it with the Vertica database cluster and the PPM database. Detailed steps are listed below.

Step Action Note
For Vertica database cluster
1 Type in the IP address of the Vertica database server Only IPv4 addresses are supported.
2 Type in the port number of the Vertica database  
3 Type in the Vertica database name  
4 Type in the user name of the Vertica database  
5 Type in the password of Vertica database  
6 Provide a name for the schema that contains metadata

Type in a meaningful name, for example, VDWMETADATA, for the schema. The following tables are generated in the schema after installation:

  • CONTENT_PACK
  • ETL_METADATA
  • ETL_STREAM

See the Data Model Guide for details about this tables.

7 Provide a name for the schema that contains management tables

Type in a meaningful name, for example, VDWMANAGING, for the schema. The following tables are generated in the schema after installation:

  • DATA_SOURCE_CDC_STAMP
  • DW_CONFIG
  • ETL_GENERATED_ARTIFACT
  • SOURCE_PRODUCT_CONFIG
  • SOURCE_PRODUCT_CONN_PARAMETERS
  • TIMEZONE_INFO

See the Data Model Guide for details about this tables.

8 Provide a name for the schema that contains staging tables Type in a meaningful name, for example, VDWSTAGING, for the schema.
9 Provide a name for the schema that contains target data and tables for reporting Type in a meaningful name, for example, VDWTARGET, for the schema.
For Vertica for PPM data warehouse
10 Type in the timezone of the Vertica data warehouse By default, the timezone is UTC. To use the default timezone, press Enter.
11 Type in the start date of the Vertica data warehouse The format is YYYYMMDD; for example, 20141107.
12 Type in the end date of the Vertica data warehouse The format is YYYYMMDD; for example, 20141107.
For the PPM instance
13 Provide the PPM instance with a name Provide the PPM instance with a meaningful name. This name will be used when the instancename parameter is needed.
14 Type in the IP address of the PPM database instance Only IPv4 addresses are supported.
15 Type in the port number of the PPM database instance  
16 Type in the PPM database instance name  
17 Type in the schema name of the PPM database instance  
18 Type in the user name of the PPM database instance  
19 Type in the password of the PPM database instance  
20 Type in the timezone of the PPM database instance By default, the timezone is UTC. To use the default timezone, press Enter.
21 Type in the initial load period of the instance

Only positive integers are supported.

Specify a time period (the number of months) of which you want the data to be loaded from the PPM database instance.

For example, if you want to extract data in the last two years, type in 24.

Taking VDW_HOME into Effect

To take the VDW_HOME variable into effect, do either of the following after you complete the previous steps:

  • Run the following command:

    source ~/.bash_profile
  • Log out and log in the system again.

Scheduling ETL with crontab

You also need to schedule the ETL job to run at a certain time by using the crontab command:

echo "<mm hh> * * * $VDW_HOME/bin/vdwetljob.sh --cpname PPM --instancename <instance_name> " | crontab

Replace <mm hh> with the time that you want the ETL job to be started, in which, <mm> indicates the minute and <hh> indicates the hour. For example, 00 01 means 01:00 am.

The following table describes the supported parameters.

Parameter

Mandatory?

Sample Value

Description

instancename

Yes

PPM01

Should be the same when you register the PPM instance

cpname

Yes PPM Content pack name

For example, if you want the system to start the ETL job for the PPM01 instance everyday at 1:00 am, run the following command:

echo "00 01 * * * $VDW_HOME/bin/vdwetljob.sh --cpname PPM --instancename PPM01" | crontab

For details about the vdwetljob.sh command, see Extracting and Loading Data with vdwetljob.sh