Previous Topic: API AccessNext Topic: Product Update


ODBC and JDBC Access

You can use the ODBC and JDBC drivers to access event data in the CA User Activity Reporting Module databases from a variety of applications. These include correlation engines and third-party reporting tools.

Accessing Events from a Reporting Tool with ODBC

Problem:

Suppose you need to use ODBC with your existing BusinessObjects Crystal Reports implementation to create custom reports using event data collected by CA User Activity Reporting Module.

Solution:

CA User Activity Reporting Module provides an ODBC client that you can use that client to get the query results into Crystal Reports.

Procedure

More Information

Configure the ODBC Server Service

Install the ODBC Client on Windows Systems

Create an ODBC Data Source on Windows Systems

Test the ODBC Server's Retrieval from the Database

 

 

 

 

For background information, see:

About ODBC/JDBC Access in CA User Activity Reporting Module

ODBC Client Prerequisites

Installing the ODBC Client

Creating ODBC and JDBC Queries for Use with CA User Activity Reporting Module

How Queries are Processed

For examples, see:

Create a CA User Activity Reporting Module User for ODBC or JDBC Access

Configure the ODBC Service Settings

Create an "elm" ODBC Data Source

Create Events for the ODBC Example

Use Crystal Reports to Access the Event Log Store with ODBC

 

Accessing Events from a Reporting Tool with JDBC

Problem:

Suppose you need to use JDBC with your existing BusinessObjects Crystal Reports implementation to create custom reports using event data collected by CA User Activity Reporting Module.

Solution:

CA User Activity Reporting Module provides a JDBC client that you can use that client to get the query results into Crystal Reports.

Procedure

More Information

Install the JDBC Client on Windows Systems

Install the JDBC Client on UNIX Systems

For background information, see:

About ODBC/JDBC Access in CA User Activity Reporting Module

JDBC Client Prerequisites

Installing the JDBC Client

Creating ODBC and JDBC Queries for Use with CA User Activity Reporting Module

How Queries are Processed

For examples, see:

Copy the JDBC Driver JAR Files

Edit the Crystal Reports Configuration File

JDBC Connection Parameters

JDBC URL Considerations

Use Crystal Reports to Access the Event Log Store with JDBC