Siebel Analytics User Guide > Basics of Working with Requests in Siebel Answers >

Executing a Direct Database Request in Siebel Answers

Users with the appropriate permissions can create and issue a direct database request directly to a physical back-end database. The results of the request can be displayed and manipulated within Siebel Answers, and subsequently incorporated into Siebel Intelligence Dashboards and Siebel Delivers.

The following permission settings in Siebel Analytics Web Administration control whether you can create and issue physical requests:

• Edit Direct Database Requests

  If this permission is set for you, you can create direct database requests. By default, this permission is set only for users defined as Siebel Analytics Web administrators.

• Execute Direct Database Requests

  If this permission is set for you, you can issue physical requests. By default, this permission is not enabled for anyone. It can be changed by a Siebel Analytics Web administrator.

To execute a direct database request

1. At the Siebel Answers start page, click the following link:

   Create Direct Request

   The Criteria tab opens.

2. Follow the on-screen instructions to specify the name of the connection pool for the database defined in the physical layer of the Siebel Analytics Server Administration Tool.

   For information about connection pools, see Siebel Analytics Server Administration Guide.

3. Follow the on-screen instructions to create the physical request.

   CAUTION:  Siebel Analytics Server security rules are bypassed and cannot be applied when direct database requests are issued from Siebel Answers.

4. To bypass the Siebel Analytics Web cache, click the bypass option.
5. To issue the request, click the Results tab.

   The results, if any, are displayed in the workspace.