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.
Running the mssql-create-login-and-user.sql script does the following:
Edit and run the script as follows:
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.
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:
|
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:
|
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. |