Previous Topic  Next Topic

Accessing Data via JDBC Connections

JDBC is a Java API for executing SQL statements. It consists of a set of classes and interfaces written in the Java programming language, which enables SQL statements to be executed against virtually any relational database and other types of data that also support JDBC. This topic introduces how you can set up JDBC connections in a catalog to retrieve data from relational databases for your reports, use the connection plug-ins to create connections in an easy way, work with the DBMS objects obtained through the connections, and run the Model Wizard to import data via OOJDBC data sources.

Select the following links to view the topics:

• Setting Up JDBC Connections in a Catalog
• Creating JDBC Connections via Plug-ins
• Using the DBMS Objects via JDBC Connections
• Using Data Sources via OOJDBC in a Catalog

You cannot use all the data types supported by JDBC in Designer. The data types Designer supports are: Bit, Tinyint, Smallint, Integer, Bigint, Float, Real, Double, Numeric, Decimal, Char, VarChar, LongVarChar, Date, Time, Timestamp, Binary, LongVarBinary, Blob, Clob, Array, and nVarChar. For the Blob, Clob, and Array types, you cannot browse their data in the Catalog Manager. However, you can use the Blob data type to display images.

Previous Topic  Next Topic