beautypg.com

Dbms translation (jdbc data source) layer, Database layer, Supported jdbc database formats – HP Intelligent Management Center Standard Software Platform User Manual

Page 742

background image

this feature of JDBC is transparent, but more advanced users often take
advantage of the features of the SQL language used by JDBC.

DBMS translation (JDBC data source) layer

This layer consists of one or more drivers provided by a DBMS that allow
JDBC to communicate with the database. If you are unsure whether you can
use an JDBC driver to access the data in your database, refer to the
documentation for your DBMS application.

Database layer

The database file which the JDBC data source refers to can be located
anywhere on a system. Once the JDBC data source is set up, Crystal Reports
does not need to know the actual location and format of the data. Thus, the
database can have any format and can be located anywhere on a network,
as long as JDBC can communicate with it through the JDBC data source.

Supported JDBC database formats

There are many different SQL Database Management Systems available on
the market, and many of them can be accessed through JDBC. Crystal
Reports communicates with JDBC through the crdb_jdbc.dll translation
file, which has been designed to work with any fully JDBC-compliant driver.
Crystal Reports officially supports third-party JDBC-compliant database
drivers provided with:

IBM DB2

Oracle

Microsoft SQL Server

BEA LiquidData for WebLogic

Note:

Check the Release Notes in the Crystal Reports product distribution for
specific version requirements and for updates to this list; more database
drivers may be added as testing progresses.

742

Crystal Reports 2008 SP3 User's Guide

Accessing Data Sources

26

JDBC data sources