MariaDB connection

MariaDB is a powerful open-source relational database management system (RDBMS). You can seamlessly integrate MariaDB with Data Integration, which enhances your abilities in data management and decision-making.

You can leverage the synergies between MariaDB and Data Integration boosting your organization's data efficiency and gaining valuable insights.

MariaDB compatibility versions

River modes	Versions supported	Support for managing schema drift
Multi-Tables (Standard Extraction)	Versions 10.0 and Above	Yes
Multi-Tables (System Versioning)	Versions 10.0 and Above	Yes
Custom Query	Versions 10.0 and Above	Yes

You can establish a connection to a MariaDB database using Data Integration platform. The prerequisites, connection setup process, SSL options, and the recommended method of using SSH tunneling for secure connections.

Prerequisites

• Set up Database credentials in MariaDB.
• Knowledge of the host, port, database name, username, and password for the MariaDB server.
• Understanding of the IP whitelisting process for Data Integration IPs on the Database Firewall, especially for EU server configurations.

Configuring MariaDB for Data Integration

Creating a user for Data Integration

To extract data, you must create a new user in the MariaDB database for Data Integration.

For MariaDB versions <= 8.0.3:

CREATE USER '`<Data_Integration Username>`'@'%' IDENTIFIED BY '`<password>`';

For MariaDB versions >= 8.0.4:

CREATE USER '`<Data_Integration Username>`'@'localhost' IDENTIFIED WITH mariadb_native_password BY '`<password>`';

Grant privileges

Grant the following privileges to the created username in the MariaDB Database:

GRANT SELECT, SHOW DATABASES, SHOW VIEW, EXECUTE ON *.* TO '`<Data_Integration Username>`';

Open Data Integration IPs in the MariaDB database firewall

To establish a successful connection, open Data Integration IPs in the MariaDB server firewall. Open the IPs for the desired MariaDB port or SSH tunnel ports.

Whitelist our IPs.

Establishing a connection

Procedure

1. Navigate to the Data Integration Account.
2. Click Connections and select + New Connection.
3. Choose MariaDB.
4. Enter your Connection Name.
5. Enter Host.
6. Fill in the Port Number.
7. Enter your Username and Password.
8. Click Test Connection to verify if your connection is up to the task. If the connection succeeded, you can use this connection in Data Integration.

Configuring SSL options

In addition to providing basic credentials, you can connect to MariaDB using an SSL pem file.

• In the MariaDB Connection form, locate the SSL section.
• Upload the SSL pem file in the corresponding section.

SSH tunneling

For enhanced security and flexibility, Data Integration recommends using SSH tunneling when connecting to on-premise database servers.

Procedure

1. Configure an SSH Tunnel server in your network capable of accepting SSH connections from Data Integration IPs.
2. Ensure the SSH server can connect to your database server using the internal IP address.
3. Data Integration connects to the SSH server using a private key for authentication.

To connect via SSH Tunnel, refer to Creating SSH Tunnel using aut-generated public key topic.