Integrations

Generic JDBC - MySQL

Support

Support for MySQL 5.7 and 8.0.

Configuration

Vendor

MYSQL

Connection format

The connection URL format is

jdbc:mysql://<database_host>:<port>/<database>.

For the MySQL driver, schemas are catalogs and vice versa; that is, to create schemas you must set the using-catalogs property to true and using-schemas to false.

Permissions

User or role with SELECT permissions on the tables or views from which metadata is to be extracted or a data sample is to be obtained.

Metadata extraction

Tables with characters in the name

This technology allows characters such as “/” in the name; if they are being used, the path-separator must be configured with a character other than “/”. See File extraction for more details.