BusinessObjects Enterprise Administrator's Guide

Changing database information

Note:    This feature does not apply to Desktop Intelligence and Web Intelligence document objects.

You can select your database type and set the default database logon information on the Database page for a report object. The Database page displays the data source or data sources for your report object and its instances. You can choose to prompt the user for a logon name and password when he or she views a report instance.

To change database settings

1. In the Objects management area of the CMC, select a report object by clicking its link.
2. Click the Process tab, and then click the database link.

The Database page appears.

 

3. In the Data Source(s) list, select the data source.
4. Select Use original database logon information from the report or Use custom database logon information specified here.

If you select the first option, you can specify a user name and password to be used with the original report database.

If you select the second option, you can specify a server name (or a DSN in the case of an ODBC data source), a database name, a user name, and a password for a number of predefined database drivers, or for a custom database driver that you've specified. If you've changed the default table prefix in your database, specify a custom table prefix here.

For a complete list of supported databases and drivers, refer to the platform.txt file included with your installation.

5. Select the database logon option you want.
• Prompt the user for database logon

  The system will prompt users for a password when they refresh a report.

  Note:    This option has no effect on a scheduled instance. Also, BusinessObjects Enterprise only prompts users when they first refresh a report; that is, if they refresh the report a second time, they will not be prompted.

• Use SSO context for database logon

  The system will use the user's security context, that is, the user's logon and password, to log on to the database.

  Note:    For this option to work, you must have your system configured for end-to-end single sign-on, or for single sign-on to the database. For more information, see "Configuring Kerberos single sign-on" on page 290.

• Use same database logon as when report is run

  The system will use the same database logon information as was used when the report was run on the job server.

6. Click Update.