Connect MariaDB

The MariaDB source reads tables and views from a MariaDB server into the Lake. Use this page to fill in each field of the MariaDB form. The steps shared by every SQL engine are on Connect a SQL database.

---

Prerequisites

• A MariaDB user with read access to the databases and tables you want to load.
• The server accepts connections from DataMind on its port, usually 3306.
• Create/Edit Lake Objects in DataMind. See Who can do what in the Lake.

---

Add the source

1. Open Lake and click Add datasource, or open the New menu in the toolbar above the tree.
2. Choose MariaDB in the picker.
3. Fill in the General, Connection and Datetime steps as described below.
4. Click Add.

---

Connection settings

General step

Name (Mandatory)

• The name the source carries in the Lake.
• At least 3 characters. The field reads Enter name until you type.

Code (Mandatory)

• A short code, at least 2 characters, made of letters and numbers only.
• It becomes the prefix of the table names the source forms. It fills in from Name while you type; edit it to set your own.
• Name and Code cannot be changed after the source is created.

Folder (Optional)

• The Lake folder the source is filed under. Leave it empty to keep the source at the top level.

Connection step: Address

Paste connection string (Optional)

• Click Paste connection string, paste a JDBC URL or a URI, and click Fill.
• Example: jdbc:mariadb://<server>:3306/sales.
• The string fills Host, Port and Database. A password inside it is never read.

Host (Mandatory)

• The server name or IP address of the MariaDB server.

Port (Mandatory)

• The port MariaDB listens on.
• Default: 3306. A whole number from 1 to 65535.

Database (Optional)

• The database to read from.
• Leave it empty to load all databases the user can read. The placeholder reads All databases.
• With a database entered, the Lake lists that database only.

Connection step: Authentication

Username (Mandatory)

• The MariaDB user the source signs in with.

Password (Mandatory)

• The password of that user.
• After you save, the field reads Stored password with Replace beside it. The password is never shown again.

Connection step: Security

SSL/TLS (Optional)

• Encrypts the connection between DataMind and the server.
• Default: off.
• The server certificate is not validated, so a self-signed certificate works.

Datetime step

Timezone (Optional)

• The IANA timezone the server writes its datetime values in, for example Europe/Berlin.
• Leave it empty when the server runs in the same timezone as the platform.

Datetime values (Optional)

• Keep as written (wall clock) (default) stores each value exactly as the server shows it.
• The other option converts each value from the source timezone into platform time on load.

Timezones and datetime values explains both settings in full.

---

Test and save

1. On the Connection step, click Test connection. The button reads Testing… while it runs.
2. Connection test passed means DataMind reached the server and signed in. Connection test failed shows the server's message with a copy button; fix the settings and test again.
3. On Datetime, check the summary: Name, Server, Database (or All databases), Username and Security.
4. Click Add. Then import its tables.

The test is optional and never saves the source. To edit or duplicate the source later, see Connect a SQL database.

---

Questions, answered

Should I choose the MariaDB card or the MySQL card?

Choose the card that matches your server. Both forms have the same fields and both start on port 3306, but each source is recorded with its own engine. For a MySQL server, see Connect MySQL.

Where do my MariaDB databases appear in the Lake?

Each database appears as a database in the Lake tree with one schema named default, because MariaDB has no schemas inside a database. Your tables sit under that schema.

What happens if I leave Database empty?

The Lake lists every database the user can read, and you pick tables from any of them when you import. Enter a database name to keep the source to that one database.

Do I need to upload a certificate for SSL/TLS?

No. The MariaDB form has no certificate field. With SSL/TLS on, the connection is encrypted and the server certificate is not validated.

Can I send data back to MariaDB?

Yes. MariaDB is also offered as a Writeback destination, with the same connection fields. See Add and manage destinations.