Integrations
Breadcrumbs

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, the using-catalogs property must be set to true and using-schemas to false.

Permissions

User or role with SELECT permissions on the tables or views for which metadata extraction or data sampling is desired.

Metadata extraction

Tables with characters in their 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 metadata extraction for more details.