HP Intelligent Management Center Standard Software Platform - Manual (Page 733)

• Crystal Reports layer
• ODBC translation layer
• ODBC layer
• DBMS translation (ODBC data source) layer
• Database layer
By using the Structured Query Language (SQL), all five layers can
conveniently pass data from the database to your report.
Crystal Reports layer
When working with ODBC data, Crystal Reports generates an SQL statement
that requests the appropriate data from ODBC. The powerful SQL generator
built into Crystal Reports is designed to create an SQL statement that will
let the ODBC data source or ODBC itself do as much of the report generation
as possible, returning only the data needed to produce the report.
ODBC translation layer
Crystal Reports uses the Dynamic Link Library crdb_odbc.dll to communicate
with ODBC. This file is unique to Crystal Reports environment and provides
your report with access to any ODBC data source. This is the driver that
actually passes data to and from ODBC.
ODBC layer
ODBC is a set of several DLLs and INI files built into the Windows
environment that act as a gateway through which database requests and
data can pass. Any database file or format that is to be used via ODBC must
be set up as an ODBC data source.
Although information regarding data sources is recorded in Odbc.ini and
Odbcinst.ini, 32-bit ODBC uses the Windows Registry database to retrieve
information about individual data sources.
Note:
For more information on ODBC and the ODBC files, see the Microsoft ODBC
documentation.
Crystal Reports 2008 SP3 User's Guide 733
26 Accessing Data Sources
ODBC data sources