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