IT Executive Scorecard Installation and Configuration Guide

Data Warehouse - Create the Target Database

This wizard page enables you to create the Data Warehouse Target database, and to configure connection and authentication parameters. The Target database contains models that describe the format of the data that produces business intelligent analytics.

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 target 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 name of the target database.

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

databasename_trg

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 that creates the Target database.

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

The wizard creates the Target database, a dwt login name, and an identical database user name. Enter the common password for the dwt login name.

UI Element

Description
Password

The password for the dwt MS SQL login and database user name. The dwt login name is mapped to the dwt database user name.

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 be identical to the password used when creating the dwabc, dwmetadata, dws, dwst, xrefgen logins on the Create Staging Database page.
Confirm Password Confirm the dwt user password.