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:
|
Confirm Password | Confirm the dwt user password. |