Add an RDS for MariaDB data source

Prerequisites

• An RDS for MariaDB database is created.

• You have the username and password for the RDS for MariaDB database.

Limitations

MariaDB 10.3 is supported.

Procedure

1. Configure an IP whitelist.

   Before you connect to the RDS for MariaDB instance, you must add the IP addresses of Quick BI to the IP whitelist of the instance.

2. Log on to the Quick BI console.

3. From an entry point for creating a data source, go to the data source creation page.

4. On the Alibaba Cloud Databases tab, select RDS for MariaDB.

   

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

   Parameter	Description
   Display name	The name to display for the data source in the data source list. Enter a valid name without special characters or leading or trailing spaces.
   Database address	The public endpoint of the MariaDB database. Log on to the ApsaraDB for MariaDB console and find the database address in the Network Information section.
   Port	The port number of the database.
   Database	The database name specified when you created the MariaDB instance.
   Username and password	The username and password for the database. Ensure that the user has CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
   VPC data source	If your database is in an Alibaba Cloud VPC, select VPC data source and configure the following parameters: AccessKey ID and AccessKey Secret: The AccessKey ID and AccessKey Secret of an account that has permissions to manage the target MariaDB database. Ensure that this account has at least Read permissions for the target instance. If the account also has Write permissions, Quick BI automatically updates the IP whitelist. Otherwise, you must manually add the IP addresses. For more information, see Create a custom RAM policy. Log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. Note The AccessKey Secret is available only at the time of creation. Instance ID and region: The ID of the MariaDB instance and the region where the instance is located. Log on to the RDS console and find the instance ID in the Basic Information section. Note If you select VPC data source, you must enter the private endpoint and private port in the Database address and Port fields, respectively.
   SSL	If SSL encryption is enabled for the data source, select this option to encrypt data in transit.
   Initialization SQL	Configures SQL statements to run automatically after a connection is established. Only SET statements are allowed. Separate multiple statements with a semicolon (;).

6. Click Test Connection to test the connection.

   

7. If the connection test is successful, click OK.