Previous Topic: API Access

Next Topic: Product Update

ODBC and JDBC Access

You can use the ODBC and JDBC drivers to access event data in the CA Enterprise Log Manager 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 Enterprise Log Manager.

Solution:

CA Enterprise Log Manager 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 Enterprise Log Manager

ODBC Client Prerequisites

Installing the ODBC Client

Creating ODBC and JDBC Queries for Use with CA Enterprise Log Manager

How Queries are Processed

For examples, see:

Create a CA Enterprise Log Manager 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 Enterprise Log Manager.

Solution:

CA Enterprise Log Manager 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 Enterprise Log Manager

JDBC Client Prerequisites

Installing the JDBC Client

Creating ODBC and JDBC Queries for Use with CA Enterprise Log Manager

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