IT Executive Scorecard Installation and Configuration Guide

Data Warehouse - Create the Staging Database

This wizard page enables you to create the Data Warehouse Staging database, and to configure connection and authentication parameters. The Staging database contains tables and snapshots that are critical to the ETL process. Executive Scorecard processes data in the Staging database before loading it into the relevant tables in the Target database.

To access On the Windows taskbar, click Start > All Programs > HP Executive Scorecard > Administration > Configuration Wizard.

Enter the details of the Staging database area:

UI Element

Description
Host name

The fully qualified domain name (FQDN), or IP address of the server hosting the Staging database.

Note: You must not use localhost as the host name.

Port The port of the MS SQL server listener. The default port is 1433. For more information about ports, see the Support Matrix document available from the Support Site (http://h20230.www2.hp.com/selfsolve/manuals or from the Installation DVD).
Database name

The database name of the Staging database.

It is recommended that you use the following database naming convention:

databasename_stg

Login Name

The MS SQL login name used to create or connect to the database.

The user must have the administrator permissions.

Note: Do not use XS as a new database user name because the XS user name is already used internally.

SQL Server authentication area:

UI Element

Description
Login Name

The MS SQL login name used to create or connect to the database.

The user must have the administrator permissions.

Note: Do not use XS as a new database user name because the XS user name is already used internally.

Password

The password for the specified login.

 

Set common password for users: dwabc, dwmetadata, dws, dwst, xrefgen area:

The wizard creates the Staging database with the following login names, and identical database user names; dwabc, dwmetadata, dws, dwst, xrefgen.

Enter the common password for these users.

UI Element

Description
Password

The MS SQL login and database user password for the dwabc, dwmetadata, dws, dwst, xrefgen users.

These users must always have the same password.

Note:

  • The password can comprise alphanumeric characters and an underscore.
  • It is important that you save the password in a safe place as it may be required in certain disaster recovery scenarios.
  • This password must also be used when creating the dwt user on the Create Target Database page.
Confirm Password Confirm the common password.