JDBC Connection
A JDBC connection connects a catalog in 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 most of the relational databases that support JDBC drivers. Designer also provides connection plug-ins for the commonly used relational databases, such as Oracle, MySQL, MS SQL Server, InterSystems IRIS, and PostgreSQL, to include the JDBC drivers required for these databases for an easy connection setup procedure.
In the following example, we connect a catalog to a MySQL Server database using the connection plug-in.
