Integrations

Generic JDBC - MariaDB

MariaDB

Support

Support from 5.5.3 to 11.0.

Configuration

Vendor

MARIADB

Connection format

The format of the connection URL is

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

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

Permissions

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

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 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.