Quick BI:Alibaba Cloud SelectDB data source

Prerequisites

You have created an instance in the ApsaraDB for SelectDB console. For more information, see Create an instance.

Procedure

1. Add IP addresses to the whitelist.

   Before you connect to the Alibaba Cloud SelectDB database over the Internet, add the IP addresses of Quick BI to the database whitelist. For more information, see Configure a whitelist.

2. Log on to the Quick BI console.

3. Go to the Create Data Source page. For more information, see Ways to create a data source.

4. On the Alibaba Cloud Databases tab, select the SelectDB data source.

   

5. In the Configure Connection dialog box, you can configure the following parameters as needed.

   Name	Description
   Display Name	The display name of the data source in the data source list. Enter a name that meets the naming conventions. The name cannot contain special characters or leading or trailing spaces.
   Database Address	The public endpoint of the Alibaba Cloud SelectDB database. If you use a VPC data source, enter the internal endpoint and port of the database. Log on to the ApsaraDB for SelectDB console to obtain the database address from the Network Information section. Example: xxxxxxxxxxxxxxxxxx.selectdbfe.rds.aliyuncs.com.
   Port	The port number of the database. The default value is 9030.
   Database	The name of the database that you want to connect to.
   Username And Password	The username and password of the database account. Make sure the username has the create, insert, update, and delete permissions on the tables in the database.
   VPC Data Source	If the database uses 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 management permissions on the destination SelectDB database. Make sure the account has the read permissions on the destination instance. If the account also has write permissions, the system automatically adds the required IP addresses to the whitelist. Otherwise, you must manually add them. For more information, see Create a custom policy. Log on to the RAM console to obtain the AccessKey ID and AccessKey secret. Instance ID and Region: The ID of the SelectDB instance and the region where it resides. Log on to the ApsaraDB for SelectDB console to obtain the instance ID and region. Note If you select VPC Data Source, enter the internal endpoint and internal port for the database address and port.

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

   

7. After a successful connection test, click OK to add the data source.

What to do next

After you create the data source, you can create a dataset and analyze data.

• You can add tables from your Alibaba Cloud SelectDB database or create custom SQL statements in Quick BI. For more information, see Create a dataset.

• You can add charts to visualize and analyze data. For more information, see Create a dashboard and Overview of charts.

• You can drill down into your data for in-depth analysis. For more information, see Configure and view drill-down data.