Platform Deployment Guide › Data Warehouse › Advanced Configuration › Retrospectively Enable the Data Warehouse › Specify the Data Warehouse User

Specify the Data Warehouse User

(If you only want to use the iConsole dashboard, but not BusinessObjects reports, skip this step. You do not need to specify a data warehouse user.)

Before you enable the Data Warehouse, specify the Data Warehouse User database account. External reporting applications (such as BusinessObjects Enterprise) use this database account to connect to the Data Warehouse and CMS database.

To specify an existing Data Warehouse User

Run the following command from a command prompt in the \system subfolder of the CA DataMinder installation folder on the CMS:

wgninfra -localexec wigan/schema/Schema SetUser Reporting <DWuser_Name> <DWuser_Password>

Where <DWuser_Name> and <DWuser_Password> specify the username and password for the Data Warehouse User database account.

To create and specify a new Data Warehouse User

If this database account does not already exist, you must create it. You can run a variation of the previous command to create the account and set this account to be the Data Warehouse User.

Run the following command from a command prompt in the \system subfolder of the CA DataMinder installation folder on the CMS:

wgninfra -localexec wigan/schema/Schema SetUser Reporting <DWuser_Name> <DWuser_Password> Create [<DBA_Name> <DBA_Password> <Tablespace>]

Where:

• <DBA_Name> and <DBA_Password> specify the username and password for a Database Administrator account that CA DataMinder can use to log in to SQL Server or Oracle to create the Data Warehouse User.

  For Oracle databases, this Database Administrator account must have the following system privileges:

  CREATE SESSION 
  RESOURCE 
  DBA 
  SYSDBA 
  

• <Tablespace> specifies the default tablespace for the Data Warehouse User.

  Important! The tablespace parameter is only used by Oracle databases. However, you must always supply this parameter, even if the data warehouse is hosted in a SQL Server database. The SetUser command requires this parameter, even though the actual value is disregarded by SQL Server databases.

Oracle Example

The following command creates a Data Warehouse User named WgnDWUser with a password of DWq74gsr. The command assigns the Data Warehouse User to the Users tablespace and specifies a DBA named sa with a password of DBAzr94x.

wgninfra -localexec wigan/schema/Schema SetUser Reporting WgnDWUser DWq74gsr Create sys DBAzr94x Users

SQL Server Example

The following command creates a Data Warehouse User named WgnDWUser with a password of DWyu8bls. The command specifies a DBA named sys with a password of DBAd23cz. The command includes a tablespace parameter (set to null) to satisfy the SetUser syntax requirements, even though SQL Server databases disregard this parameter.

wgninfra -localexec wigan/schema/Schema SetUser Reporting WgnDWUser DWyu8b1s Create sa DBAd23cz null