Skip to main content

MariaDB

MariaDB is a popular open-source relational database management system that is a fork of MySQL. It offers enhanced performance, stability, and features while maintaining compatibility with MySQL. MariaDB is widely used for web-based applications due to its reliability and ease of use.

Timbr + MariaDB

Integrating MariaDB with Timbr allows you to leverage Timbr's semantic graph capabilities while maintaining MariaDB's robust data management features. This integration enables advanced features like semantic querying, data virtualization, and integrated data management, providing powerful insights and efficiencies.

Getting Started with MariaDB​

If you haven't yet set up MariaDB, follow these steps to get started:

To connect Timbr to your MariaDB datasource, you need to use the MariaDB JDBC driver. For information on the MariaDB JDBC driver and how to set it up, refer to the MariaDB JDBC Driver documentation.

Connecting Timbr to MariaDB in the Timbr Platform​

Once you've set up MariaDB and have the JDBC driver ready, it's time to connect Timbr to MariaDB. Follow the steps below for a detailed tutorial on connecting Timbr to MariaDB:

  1. Navigate to Manage Datasources: From the Timbr interface, click on the Manage tab and select Datasources.

  2. Add New Datasource: On the top right, click the Add New Datasource button. Alternatively, you can click the big add button beneath the knowledge graphs and datasources tabs.

Add new datasource

  1. Fill in Connection Details: A pop-up window will appear where you need to provide the relevant connection details to connect MariaDB to Timbr.

There are two options in Timbr to enter the connection information: Simple or JDBC Url.

On the top right of the pop-up window , the toggle can be switched from Simple to JDBC Url in order to connect the datasource using the relevant JDBC URL.

Simple Tab Connection Configuration​

  1. Select Simple Tab: Ensure the Simple tab is selected.

  2. Fill in the Following Details:

    • Database Type: Select MariaDB.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • Hostname / IP: Enter the hostname or IP address of your MariaDB datasource.
    • Port: Enter the port number.
    • Username: Enter your MariaDB username.
    • Password: Enter your MariaDB password.
    • Database Name: Specify the name of the database.
    • Additional Parameters: Add any additional connection parameters using ; as separators.

JDBC URL Tab Configuration​

  1. Select JDBC URL Tab: Ensure the JDBC URL tab is selected.

  2. Fill in the Following Details:

    • Database Type: Select MariaDB.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • Username: Enter your MariaDB username.
    • Password: Enter your MariaDB password.
    • JDBC URL: Enter the JDBC connection URL (e.g., jdbc:mariadb://hostname:port/database).

Save and Test Connection​

  1. After entering the details, click the Save button to save the information, connecting the MariaDB datasource to the Timbr environment.
  2. Once saved, on the top right, click the Test connection button to verify the datasource’s connectivity, ensuring it is active and responsive.

For a comprehensive guide on connecting Timbr to various datasources, refer to the detailed documentation: