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. 

MariaDB

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

Feature Supported Objects Remarks
Crawling Tables  
Table columns Supported Data types:
INT, TINYINT, SMALLINT, MEDIUMINT, BIGINT, FLOAT, DOUBLE, DECIMAL, DATE, DATETIME, TIMESTAMP, TIME, YEAR, CHAR, VARCHAR
Views  
Stored procedures  
Functions  
Roles  
Users  
Permissions  
Usage statistics  

Profiling

See this article Profile Data to know more about Profiling.

Feature Support Remarks
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

Lineage Entities Details
Table lineage Supported
Column lineage Supported
Lineage Sources Stored procedures, functions, views, query logs

Querying 

Operation Details
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:

ConnectionInfo

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

Property

Details

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

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