Quick BI:Add a RDS for MariaDB Data Source

Prerequisites

• You have created an Alibaba Cloud MariaDB database.

• You have obtained the username and password for the Alibaba Cloud MariaDB database.

Limits

Only version 10.3 is supported.

Procedure

1. Add the IP address of Quick BI to the whitelist.

   Before connecting to Alibaba Cloud MariaDB, you must add the IP address of Quick BI to the MariaDB whitelist.

2. Log on to the or the international Quick BI console.

3. Navigate to the data source creation page via the data source creation entry.

4. On the Alibaba Cloud Database tab, select the MariaDB data source.

   

5. In the Configure Connection dialog box, complete the configurations according to your business needs.

   Name	Description
   Display name	The name displayed in the data source configuration list. The name cannot contain special characters or start or end with spaces.
   Database address	The public address where the MariaDB database is deployed. Log on to the ApsaraDB MariaDB console to obtain the database address in the network information area.
   Port	The port number corresponding to the database.
   Database	The custom database name specified when the MariaDB database is deployed.
   Username and Password	The username and password that are used to access the database. Ensure that the username has the create, insert, update, and delete permissions on the tables in the database.
   VPC data source	If you use the Alibaba Cloud VPC network, select VPC Data Source and configure the following parameters: Accesskey ID Of The Purchaser and Accesskey Secret Of The Purchaser: The AccessKey ID and AccessKey Secret that have management permissions on the target MariaDB database. Ensure that the account has Read permissions on the destination instance. If the account also has Write permissions, the system automatically adds the whitelist. Otherwise, you need to manually add it. For more information, see Create a custom policy. Log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. Note The AccessKey Secret is provided only when it is created. Instance ID and Region: The instance ID and region of the MariaDB database. Log on to the RDS management console to obtain the instance ID in the basic information area. Note If you select VPC data source, you must specify the internal address and internal port for the database address and port.
   Initialization SQL	After this option is enabled, you can configure the SQL statements that are executed to initialize the data source connection. Only SET statements are allowed for the SQL statements executed after each data source connection. Separate the statements with periods.

6. Click Connection Test to verify the data source connectivity.

   

7. Once the test is successful, click OK.