MariaDB

Sync MariaDB data into your Quantive account to create KPIs and automated Key Results

Neli Ivanova avatar
Written by Neli Ivanova
Updated over a week ago

MariaDB is an open-source, multi-threaded, relational database management system. You can connect to any table in any schema in MariaDB and create a Quantive entity based on it.

Prerequisites

If your MariaDB is hosted behind a firewall you must whitelist the Quantive IPs for remote access.

How to connect

  • In Quantive, navigate to Settings > Data Sources screen

  • Click the Select data source button

  • From the Choose a connector dialog, select the Database tab and then MariaDB

Enter the necessary information to connect to your MariaDB database.

  • Host: hostname or IP address of your MariaDB instance

  • Schema: the name of the schema to which you want to connect

  • Username: the name of the user with which you wish to connect

  • Password: the password of the user with which you wish to connect

  • Port: the port where MariaDB is listening. The default is 3306, which is a standard MariaDB port

Click on the Connect button.

  • Choose a table to which you want to connect and click on the Use ... button

  • Give the name of your data source, something that makes sense to you and select the sync schedule (how often you want this data source to be synced automatically)

  • Click on the Add my data source button

What data from MariaDB can I use

You can sync any field from any table in any schema that is accessible to the user with which you connected to the MariaDB database.

Quantive will automatically coerce types for you, so for example date and timestamp can both be mapped to the Quantive date type.

Did this answer your question?