Installation workflow

  1. Install the Vertica database
  2. Set up the data warehouse through CLI
  3. Apply the Vertica license
  4. Install ITBA
  5. Install SAP BusinessObjects Enterprise

Install the Vertica database

Vertica is an analytics database that handles big data and relevant information from the source system. For details about installing HPE Vertica, see the HPE Vertica Analytic Database Installation Guide.

Set up the data warehouse through CLI

Perform the following steps to create the HPE Vertica database on the HPE Vertica cluster through the command line interface (CLI). You must use itocdb for the HPE ITOC database instance.

In the example, the sample IP address of 16.166.49.118 for three nodes in the HPE Vertica cluster is used.

The database can be configured on any of the nodes, in the cluster visible for one node. Connect to the node in the cluster (or to the cluster VIP) to access the node CLI and then run the following command to create the database on the cluster:

  1. Log in as the database admin user (or switch to the database admin user):

    # su - dbadmin

  2. Enter the following command to open the Vertica Analytics Database 7.x Administration Tools main menu:

    $ /opt/vertica/bin/admintools

  3. Select Configuration Menu:

  4. Click OK.
  5. Select Create Database to create a database. The Create Database wizard opens:

  6. Enter the database name itocdb.

  7. Click OK.
  8. Enter a password for the database.

  9. Click OK.
  10. Reenter the password to confirm.

  11. Click OK.
  12. Select the host for the database.

  13. Click OK.
  14. The Database data directories console opens.

  15. Click OK, and click OK again.

  16. The list of cluster nodes on which the database is being created is displayed. Click Yes to begin creating the database.

The console displays status messages. When the database is created, the following message is displayed:

Apply the Vertica license

Apply the Vertica license. For more information about Vertica license application, see the HPE Vertica Analytic Database Installation Guide.

Install ITBA

The IT Business Analytics Application (ITBA) provides the means to define IT goals and objectives, measure performance, and provides actionable insights into performance improvement plans. It includes the Dashboard, Studio, Explorer, Admin, and Data Warehouse (DWH) modules.

DWH is a repository for key business data that is cleansed, consolidated, and organized to support efficient queries, reports, and populate a variety of business analytics. The contents of the DWH depend on the external HPE applications that generate business data. For example, the data may originate from external applications such as HPE Application Lifecycle Management or HPE Project and Portfolio Management.

For information about how to install the ITBA platform, the BOE platform, and the HPE Vertica Data Warehouse, see the HPE IT Business Analytics Installation Guide.

Install SAP BusinessObjects Enterprise

SAP BusinessObjects Enterprise is a solution that provides reporting, analysis, and information delivery using web applications. This component must be installed separately.

The SAP BusinessObjects Business Intelligence (BI) platform is a flexible, scalable, and reliable solution for delivering powerful, interactive reports to end users through any web application. The BI platform delivers tangible benefits that extend across and beyond the organization. As an integrated suite for reporting, analysis, and information delivery, the platform provides a solution for increasing end-user productivity and reducing administrative efforts.

Server Intelligence is a core component of the BI platform. Changes to server processes applied in the CMC are propagated to corresponding server objects by CMS.

The CMC is a web-based tool that you use to perform administrative tasks (including user, content, and server management) and to configure security settings. Because the CMC is a web-based application, you can perform all of the administrative tasks in a web browser.

For more information about SAP BOE, see the SAP BusinessObjects Business Intelligence site.