Integrations
Breadcrumbs

Generic JDBC - MariaDB

MariaDB

Support

Support from 5.5.3 to 11.0.

Configuration

Vendor

MARIADB

Connection format

The connection URL format is

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

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

Permissions

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

It can also be applied directly to the database or even the entire server, and it will apply to everything it contains.

Metadata extraction

Tables with special 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 extraction for more details.