Installation and Upgrade Guides › Policy Server Installation Guide › Prerequisites for Running Reports Using Crystal Reports › How to Configure the Policy Server for Crystal Reports

How to Configure the Policy Server for Crystal Reports

To configure Crystal Reports to run SiteMinder reports:

1. Create a logging database schema. The Policy Server generates audit logs and stores the necessary reporting information in a SQL Server or Oracle database.
   • Create the Oracle Database Schema For Logging.
   • Create the SQL Server Database Schema For Logging.
2. Create the stored procedures database schema.
   • Create the Oracle Database Schema For Stored Procedures.
   • Create the SQL Server Database Schema For Stored Procedures.
3. Create an ODBC logs data source to write to the logging database.
   • Configure an Oracle ODBC Logs Data Source.
   • Configure a SQL Server ODBC Logs Data Source.
4. Create an ODBC Crystal Reports data source to read from the logging database.
   • Configure an Oracle ODBC Crystal Reports Data Source.
   • Configure a SQL Server ODBC Crystal Reports Data Source.
5. Configure a Database to Store Audit Logs.
6. Modify SiteMinder Reports to Use the Crystal Reports Data Source