Platform Deployment Guide › Data Warehouse › Advanced Configuration › Retrospectively Enable the Data Warehouse › Set Credentials for the Reporting User

Set Credentials for the Reporting User

You must specify a Reporting User database account if you enable data warehousing. External reporting applications (such as BusinessObjects Enterprise) use this database account to connect to the Data Warehouse and CMS database.

You can use the Administration console to add or modify credentials for the Reporting User database account. For example, if the password has been changed on the database server (for example, for security reasons), you can supply CA Data Protection with the new password.

To set credentials for the Reporting User

1. Log on to the Administration console using an account that has the 'Admin: Manage security models' privilege.
2. Click Tools, Set Reporting User Credentials.
3. Enter the user name and password in the Set Reporting User Credentials dialog.
4. (Optional) If necessary, provide credentials for an existing Database Administrator account. See below for details.

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

   CREATE SESSION 
   RESOURCE 
   DBA 
   SYSDBA 
   

When must I provide Database Administrator details?

Credentials for the Reporting User are securely stored in the CMS database and in the CMS internal file system. The two sets of credentials must be in sync.

You do not need to provide Database Administrator details if a DBA has already updated the Reporting User credentials in the CMS database. In this situation, CA Data Protection only needs to update the Reporting User credentials stored in the CMS internal file system.

You do need to provide Database Administrator details if the CMS database has not been updated yet. In this situation, CA Data Protection simultaneously adds the Reporting User credentials to the CMS internal file system and the CMS database. CA Data Protection uses the Database Administrator account to log in to SQL Server or Oracle and update the CMS database.

More information:

Configure the Data Warehouse