IT Executive Scorecard Installation and Configuration Guide

Data Warehouse - Create the SAP BusinessObjects Data Services for HP XS Database

This wizard page enables you to create the SAP BusinessObjects Data Services for IT Executive Scorecard database, and to configure connection and authentication parameters.

SAP BusinessObjects Data Services for IT Executive Scorecard enables you to have data integration and data quality processes in one runtime environment. The database holds the SAP BusinessObjects Data Services for IT Executive Scorecard metadata.

If the SAP BusinessObjects Data Services for IT Executive Scorecard database was created, but the new login could not be created, you receive a Database Exists message box. Ensure that you create a new SAP BusinessObjects Data Services for IT Executive Scorecard login name by editing and running the mssql-create-login-and-user.sql, before you click OK to continue.

Note:  If running the post-install wizard fails after the SAP BusinessObjects Data Services for IT Executive Scorecard installation and before the Data Warehouse installation, you must uninstall SAP BusinessObjects Data Services for IT Executive Scorecard and then re-install it.

Edit and Run the mssql-create-login-and-user.sql Script

Running the mssql-create-login-and-user.sql script does the following:

Edit and run the script as follows:

  1. Open the <Installdir>\agora\confwizard\conf\scripts\database\mssql\mssql-create-login-and-user.sql script.
  2. Make the following changes:

    Replace the ${mappedUsername} string with the new login name.

    Replace the ${mappedUserPassword} string with the password of the new login name.

    Replace the ${dbName} string with the name of the SAP BusinessObjects Data Services for IT Executive Scorecard database.

  3. Run the <Installdir>\agora\confwizard\conf\scripts\database\mssql\mssql-create-login-and-user.sql script.

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

UI Element

Description
Host name

The fully qualified domain name (FQDN) or IP address of the MS SQL Server hosting the SAP BusinessObjects Data Services for IT Executive Scorecard database.

Note:

  • You must not use localhost as the host name.
  • The character length of the Host name FQDN + the SAP BusinessObjects Data Services for IT Executive Scorecard database name + the Login Name must not exceed 63 characters.
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 SAP BusinessObjects Data Services for IT Executive Scorecard database.

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

databasename_bods

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 of the specified login.
New Login name

A new MS SQL login created for the SAP BusinessObjects Data Services for IT Executive Scorecard database.

A SAP BusinessObjects Data Services for IT Executive Scorecard database user account with the same name is automatically created.

Note: The Login Name can only comprise alphanumeric characters and if required an underscore.

Password

The password for the new login.

The same password is also applied to the database user account.

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.
Confirm Password Confirm the password for the new login.
Installation directory

The location where you want to install SAP BusinessObjects Data Services for IT Executive Scorecard.

The maximum allowable path length is 69 characters. In addition, the Installation directory field does not support multi-byte characters. To install the software on a system with a multi-byte locale, you must specify the installation directory with single-byte characters or use the default location.

Note: To run the Designer, a user requires both read and write access to the installation directory.