Administration Guide › Accessing Collected Events with ODBC and JDBC › Example: Preparing to Use ODBC and JDBC Clients with Crystal Reports

Example: Preparing to Use ODBC and JDBC Clients with Crystal Reports

Preparing for ODBC or JDBC client access to CA User Activity Reporting Module events using BusinessObjects Crystal Reports involves the following steps:

1. Create a CA User Activity Reporting Module user to allow access to the database.
2. Verify that the ODBC Service is using SSL encryption and port 17002.
3. Install the ODBC client, or copy the JDBC files to the server where Crystal Reports resides.

   See the Implementation Guide for information about these installations.

4. Configure operating system components:
   1. Create and test an ODBC datasource in the Windows Control Panel.
   2. Edit the Crystal Reports configuration file to use the JDBC client.
5. Create events for collection by CA User Activity Reporting Module.

   If you are sure that the event log store already contains events of the type queried, you can omit this step.

Note: This process and the related example assume that you are familiar with creating basic SQL statements and using Crystal Reports. More information about using Crystal Reports is available in the BusinessObjects online help.