MariaDB
Connectivity Summary
An out-of-the-box connector is available for MariaDB databases to support crawling database objects, profiling sample data, and lineage building.
The drivers used by the connector are mentioned below:
Driver/ API: MariaDB JDBC driver
Version: 1.0
Details: Is JDBC 5.1.29 https://mvnrepository.com/artifact/MariaDB/MariaDB-connector-java/5.1.29 Note: Latest version is 8.0.25
Technical Specifications
The following are the connector capabilities mentioned below:
Crawling
Crawling
Tables
Crawling
Table columns
Supported Data types: INT, TINYINT, SMALLINT, MEDIUMINT, BIGINT, FLOAT, DOUBLE, DECIMAL, DATE, DATETIME, TIMESTAMP, TIME, YEAR, CHAR, VARCHAR
Crawling
Views
Crawling
Stored procedures
Crawling
Functions
Crawling
Roles
Crawling
Users
Crawling
Permissions
Crawling
Usage statistics
Profiling
Table Profiling
Row count, Columns count, View sample data
View Profiling
Row count, Columns count, View sample data
View is treated as a table for profiling purposes
Column Profiling
Min, Max, Null count, distinct, top 50 values
Full Profiling
Supported
Sample Profiling
Supported
Lineage Building
Table lineage
Supported
Column lineage
Supported
Lineage Sources
Stored procedures, functions, views, query logs
Querying
Select
Supported
Insert
Not supported, by default.
Update
Not supported, by default.
Delete
Not supported, by default.
Joins within database
Supported
Joins outside database
Not supported
Aggregations
Supported
Group By
Supported
Order By
Supported
By default, the service account provided for the connector will be used for any query operations. If the service account has write privileges, then Insert / Update / Delete queries can be executed.
Pre-requisites
To use the connector, the following need to be available:
Connection details as specified in the following section should be available.
An admin/service account with read privileges.
JDBC driver is provided by default. In case it needs to be changed, add MariaDB client drivers into the OvalEdge Jar path to communicate to the MariaDB database.
Check the Configuration section for further details on how to add the drivers to the jar path.
Connection Details
The following are the connection settings that need to be added for connecting to MariaDB database:
Database Type: MariaDB
License Type: Standard
Connection Name: Select a Connection name for the MariaDB database. The name that you specify is a reference name to easily identify your MariaDB database connection in OvalEdge. Example: MariaDB Connection1
Hostname / IP Address: Database instance URL (on-premises/cloud-based) Example:oval-MariaDB.csklygkwz3dx.us-east-1.rds.amazonaws.com
Port number: 3306
Sid/Database: Name of the database to connect.
Username: User account login credential MariaDB Authentication
Password: Password (only for MariaDB Authentication)
Driver Name: JDBC driver name for Exasol. It will be auto-populated. Example: MariaDBJDBC42-no-awssdk-1.2.41.1065
Connection String: MariaDB connection string. Set the Connection string toggle button to automatic, to get the details automatically from the credentials provided. Alternatively, you can manually enter the string. Format: jdbc:MariaDB://{server}:3306/{sid} Example: jdbc:MariaDB://ovaledge.cpgvvwcraues.us-east-.MariaDB.amazonaws.com:3306;database=customers
Once connectivity is established, additional configurations for Crawling and Profiling can be specified.
Crawler configurations
Tables, views & columns
By default, it is selected true
Relationships
Need to select for crawl relationships
Procedures, functions view, source codes
Need to select for crawl Procedures, functions, view, source codes
Crawler rules
The default include tables regex has regex = (.*), which can crawl all the tables
Profile Settings
Tables and columns
By default, it is selected true
Views and columns
By default, it is selected true
Profile Rules
Default includes tables regex has regex = (.*), which can profile all the tables
Query Log Setting
Copyright © 2025, OvalEdge LLC, Peachtree Corners GA USA
Was this helpful?