Search

Welcome to Datagrid
Welcome to Datagrid
MariaDB

MariaDB

MariaDB Server is one of the most popular open source relational databases. By connecting MariaDB to Datagrid, you can seamlessly integrate your database information with other business-critical data, enabling enhanced reporting, analytics, and decision-making.

1. How-to

1. Prerequisites

To configure the MariaDB connector, follow these steps:

  • A MariaDB database server with the necessary databases and tables.
  • MariaDB username and password with appropriate privileges.
  • Ensure that your MariaDB instance allows connections from Datagrid's IP addresses. You may need to configure the firewall rules accordingly.
  • Select the data you want to import into Datagrid

2. Connect

Creating a dataset from the MariaDB connector involves selecting the specific data you want to import:

  1. Connect MariaDB App: a. Click on the "+ Create” Button on the top left of the screen. b. Select the "Connect Apps" item. c. Search for the MariaDB connector from the list. d. Enter your MariaDB instance details, including server name, database name, username, and password. e. Click on the “Next” button.
  2. Pick your Data: a. Pick the MariaDB data you want to include in your dataset (e.g., Tables, Views, Stored Procedures). b. Click on the “Start First Import” Button to start syncing your MariaDB dataset.

3. Set Up a Schedule:

Scheduling regular data pulls ensures your Datagrid datasets remain up-to-date with the latest information from MariaDB:

  1. Navigate to MariaDB Dataset: a. Go to the left side panel and locate and click on the MariaDB dataset you created.
  2. Schedule Settings: a. Click on the “...” on the top right of the dataset. b. Click on “Edit Pipeline” to edit your connector's name. c. Click the “Schedule” button on the right, beside the “Import Configuration” button.
  3. Configure Schedule: a. Set the desired frequency for data pulls (e.g., daily, weekly, monthly). b. Specify the time of day for the data pull to occur. c. Specify downtime if needed – when the sync should not happen. d. Click the “Update” button to update the new configuration.

4. Data Access

  • Databases
  • Tables
  • Views
  • Stored Procedures
  • Functions
  • Users

5. Use Cases

  • Business Intelligence: Import data from MariaDB into Datagrid to create dashboards and reports that provide insights into key business metrics.
  • Data Analysis: Analyze data from MariaDB in Datagrid to identify trends, patterns, and anomalies.
  • Application Development: Use Datagrid to access and transform data from MariaDB for use in custom applications.
  • Data Migration: Migrate data from MariaDB to other data sources using Datagrid's data integration capabilities.
  • E-commerce Platforms: Many e-commerce platforms rely on MariaDB databases for storing product catalogs, customer information, and order details.
  • Content Management Systems (CMS): WordPress, Drupal, and Joomla are popular CMS platforms that often use MariaDB as their underlying database.

6. FAQ

Q: What is MariaDB? A: MariaDB Server is one of the most popular open source relational databases. It’s made by the original developers of MySQL and guaranteed to stay open source.

Q: What type of data can I import from MariaDB? A: You can import tables, views, stored procedures, and other database objects.

Q: How do I ensure secure connections to my MariaDB instance? A: You can configure SSL/TLS encryption for connections to your MariaDB instance. Additionally, you can use firewall rules to restrict access to your MariaDB instance from unauthorized networks.

7. Support & Additional Resources