Direct Database Request

You can create and issue a direct database request directly to a physical back-end database.

Setting Privileges for Direct Requests:

1. Login to the Analytics Editor
2. Select Manage Privileges from the Administration page.

3. In Answers, Edit the properties for Edit Direct Database Analysis, Execute Direct Database Analaysis

4. In RPD, open identity manager from Manage
5. Select the user and click on permission

6. Select the Query limits tab

7. Set the Execute Direct database request property to Allow

8. Click OK and save the Rpd.

Executing a Direct Database Request

1. Login to analytics editor
2. Select new analysis and select Create Direct Database Request

3. Give the connectionpool name and write the sql query and click on validate SQL retrieve columns

4. Click on the results tab to view the results