JDBC Connection
A JDBC connection connects Designer to a relational database via a JDBC driver. 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. Designer supports all of the current mainstream databases and most databases which support JDBC drivers. Designer also provides connection plug-ins for the most commonly used relational databases: Oracle, MySQL, SQL Server, InterSystems IRIS, and PostgreSQL, to include the JDBC drivers required for these databases for an easy connection setup procedure.
The following example connects a Report catalog data source to a MySQL Server database via the connection plug-in Designer provides.
Back to top