Administration Guide › Accessing Collected Events with ODBC and JDBC › Creating ODBC and JDBC Queries for Use with CA User Activity Reporting Module

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

Support for ODBC and JDBC in CA User Activity Reporting Module is limited to read-only queries using SELECT statements on the following tables:

• VIEW_EVENT - contains events from the Event Database
• VIEW_INCIDENT - contains incidents from the Incident Database
• VIEW_INCIDENTEVENT_BYID - contains incident component events from the Incident Event Database

Build your SELECT statements using ANSI SQL format and rules. The server-side components contain a SQL parsing engine. The parser implements a large portion of the entry level SQL as defined in the X3.135-1992, "Database Language SQL" specification. The parser also supports SQL features from ANSI SQL99 and commercial databases like Microsoft SQL Server and Oracle. The parser is also compliant with the ODBC minimal grammar specification.

The common event grammar serves as the schema for this table. See the CEG Reference Guide for details on the schema.