Installation and Upgrade Guides › Policy Server Installation Guide › Prerequisites for Running Reports Using Crystal Reports › Next Steps › Configure an Oracle ODBC Logs Data Source

Previous Topic: Next Steps

Next Topic: Configure a SQL Server ODBC Logs Data Source
Configure an Oracle ODBC Logs Data Source

The SiteMinder Logs Data Source allows the Policy Server to write logging messages to an Oracle database. Crystal Reports reads messages from this database to create reports.

To create and configure the SiteMinder Logs Data Source

  1. Select Programs, Administrative Tools, Data Sources (ODBC) to access the ODBC Data Source Administrator.
  2. Click the System DSN tab and click Add. The Create New Data Source dialog box appears.
  3. Scroll down and select SiteMinder Oracle Wire Protocol and click Finish. The ODBC Oracle Wire Protocol Driver Setup dialog appears.
  4. Under the General tab, do the following:
    1. In the Data Source Name field, enter any name you want.

      Example: SiteMinder Logs Data Source.

      Note: Take note of this name, as you will need it when you configure the database to store audit logs.

    2. (Optional) In the Description field, enter a description of the Oracle wire protocol logs data source.
    3. In the Host field, enter the machine name where the Oracle database is installed.
    4. In the Port Number field, enter the port number where Oracle is listening on the machine.
    5. In the SID field, enter the service name of the Oracle instance that you want to connect, which you specified in the tnsnames.ora file. The SID is the system identifier for the database instance.

      The tnsnames.ora file contains service names and details that Oracle uses to identify and connect to Oracle instances. For example, if the tnsnames.ora file contains the following entry for an Oracle instance, enter instance1 in the SID field.

    6. instance1 =

        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(Host = myhost)(Port =1521))
        (CONNECT_DATA = (SID = SIDofinstance1))
        )

    7. Test the connection with the database by clicking Test Connect.
  5. Click OK to save the selections and exit the ODBC Oracle Wire Protocol Driver Setup.
  6. Configure the database to store audit logs.

More Information:

Configure a Database to Store Audit Logs