User-created MariaDB data source

Prerequisites

• Create a user-created MariaDB database.

• Obtain the username and password for the user-created MariaDB database.

Limitations

Only MariaDB version 10.3 is supported.

Procedure

1. Add IP addresses to a whitelist.

   Before connecting to the user-created MariaDB data source, add the IP addresses of Quick BI to the data source's whitelist.

2. Log in to the Quick BI console.

3. Go to the page for creating data sources. For more information, see Create a data source.

4. On the User-Created tab, select MariaDB.

   

5. In the Configure Connection dialog box, configure the following parameters.

   Parameter	Description
   Display name	The display name of the data source. Enter a valid name. Do not use special characters or include leading or trailing spaces.
   Database address	The endpoint of the MariaDB database, which can be an IP address or a domain name.
   Port	The port number of the database.
   Database	The name of the database you want to connect to.
   Username and password	The username and password used to connect to the database. The user must have the CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
   Initial SQL	When enabled, Quick BI runs the specified SQL statements automatically after the connection is established. Only SET statements are allowed. Separate multiple statements with a semicolon (;).

6. Click Test Connection.

   

7. After the connection test succeeds, click OK.