MariaDB walkthrough
You can integrate data from a MariaDB database into a cloud Target using Data Integration. This supports various MariaDB versions and offers flexible extraction methods, all managed through simple configuration, scheduling, and monitoring features."
This connector also supports AWS Aurora with MariaDB compatibility.
Working with MariaDB
Procedure
Step 1: establishing a connection
Make sure you have appropriate credentials for establishing a connection with a MariaDB database server.
Step 2: choosing the River mode
Once you have successfully established a connection to MariaDB, select the River mode to load data into a Target.
There are three available options for you to choose:
By clicking on the highlighted modes, you will be redirected to a relevant page that offers a comprehensive explanation and presents a Product Tour, showcasing the available features in MariaDB.
- Multi-Tables: Simultaneously load multiple tables from MariaDB to your desired Target.
- Standard Extraction - This River mode maps, transforms, and loads data from multiple tables into a unified schema. It uses SQL queries for transformations and can be scheduled or manually triggered.
- System versioning - This mode offers an effective tracking mechanism that records alterations made to rows in your tables, including inserts, deletes, and updates. To use this mode, you must enable system versioning for each table.
- Custom Query: Create a customized query and import it into your designated Target.
- Legacy River: Select a sole Source table for loading into a Target.
Step 3: running the river
Once you have successfully configured the River mode, selected the extraction method, and set up the scheduling, you are ready to initiate the River and start its operation.
