Connecting 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 as well as 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 got via the connections, and run the Model Wizard to import data via OOJDBC data sources.
Designer also provides connection plug-ins for the most commonly used relational databases: Oracle, MySQL, SQL Server, InterSystems IRIS, and PostgreSQL, for an easy connection setup procedure.
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.