Installation and Upgrade Guides › Policy Server Installation Guide › Installing Reports › How to Configure an Audit Database › Register the Audit Database with the Administrative UI

Register the Audit Database with the Administrative UI

You register the audit database with the Administrative UI to create a trusted connection between the components. Registering the audit database with the Administrative UI lets SiteMinder administrators create and manage audit-based reports.

Note: The Administrative UI can have a trusted relationship with one or more Policy Servers. However, each trusted relationship only allows one audit database connection. If you must connect to a new audit database, either delete the current connection or connect to another Policy Server to configure the connection.

To register the audit database with the Administrative UI

1. Log into the Administrative UI.
2. Click Administration, Admin UI.
3. Click Report Connections, Create Audit Report Connection.

   The Create Audit Report Connection pane appears.

   Note: Click Help for descriptions of settings and controls, including their respective requirements and limits.

4. Select the database vendor from the Database Vendor drop-down list.

   Vendor-specific fields appear.

5. Type the name of the connection in the Connection Name field.
6. Enter the audit database host system name or IP address in the Database Server Host field.
7. Enter the audit database data source information in the DSN field:
   • Oracle—Enter the Oracle Net Service name you specified when creating the audit database DSN.

     Note: The service name must be associated with the DSN you entered in the Data Tab of the Policy Server Management Console when configuring the audit database connection to the Policy Server.

   • SQL Server—Enter the DSN.

     Note: The DSN name must match the DSN you specified in the Data Tab of the Policy Server Management Console when configuring the audit database connection to the Policy Server.

8. Enter the port on which the audit database server is listening in the Database Server Port field.
9. Complete one of the following:
   • Oracle—Re–enter the Oracle Net Service Name in the Service Name field.
   • SQL Server—Enter the audit database name in the Database Name field.
10. Enter administrator credentials for the audit database in the respective fields.

    Note: The administrator credentials must match the credentials you specified in the Data tab of the Policy Server Management Console when configuring the audit database connection to the Policy Server.

11. Click Submit.

    The audit database is registered with the Administrative UI.

Audit Database and Report Server Connectivity

A Report Server connects to a SiteMinder audit database to create audit-based reports. When an audit-based report is scheduled in the Administrative UI, the Administrative UI passes the following connection information to the Report Server:

• (Oracle) The Oracle Net Service Name that identifies the audit database
• (Microsoft SQL Server) The name of the:
  • Audit database
  • Data source used to connect to audit database
• The user account credentials required to access the audit database

To configure connectivity between the audit database and the Report Server, do one of the following:

• (Oracle) Be sure that the:
  • Oracle Net client is installed to the Report Server host system.
  • Oracle Net Service Name that identifies the audit database is present in the tnsnames.ora file on the Report Server host system.
• (Microsoft SQL Server) Be sure that the data source used to connect to the audit database is present on the Report Server host system.

Note: For more information about supported database drivers, see the r12.5 SiteMinder Platform Support Matrix.

More information:

Locate the Platform Support Matrix