Add an Apache Doris data source to connect the Apache Doris database to the Quick BI. After the connection is successful, you can analyze and display data on the Quick BI. Quick BI allows you to connect to an Apache Doris database over the Internet or in a VPC. This data source supports connection to SelectDB and StarRocks data sources. This topic describes how to add a user-created Apache Doris data source.
Prerequisites
Your network meets the following requirements:
If you Quick BI connect to the Apache Doris database over the Internet, add the Quick BI IP address to the whitelist of the database. For more information, see Add security group rules.
If you want to connect your Quick BI to the Apache Doris database over an internal network, use one of the following methods to connect the data source to the Quick BI:
If the Apache Doris database is built on an Elastic Compute Service (ECS) instance of Alibaba Cloud, you can connect to the database by using a virtual private cloud (VPC).
You can deploy a jump server and access the database over an SSH tunnel.
A user-created Apache Doris database is created.
The username and password of the user-created Apache Doris database are obtained.
Limits
Version 1.2.4 is supported.
Procedure
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add a user-created MongoDB data source.
Go to the Create Data Source page.
Click Show More.
Select the Apache Doris data source.
In the Configure Connection dialog box, configure the following parameters based on your business scenario.
Feature
Description
Name
The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.
Database address
The address where the Apache Doris database is deployed, including the IP address or domain name.
Port Number
The port where the Apache Doris database is deployed.
Instance
The custom database name when deploying the Apache Doris database.
Username and Password
The username and password used to log on to the Apache Doris database. Make sure that the username has the create, insert, update, and delete permissions on the tables in the database.
VPC Data Source
If the Apache Doris database is deployed on a ECS and the network type is Alibaba Cloud VPC, select VPC Data Source and configure the following parameters:
AccessKey ID: the AccessKey ID that is used to purchase the instance.
For more information, see Obtain an AccessKey pair.
AccessKey: the AccessKey secret that is used to purchase the instance.
For more information, see Obtain an AccessKey pair.
Instance ID: the ID of the ECS instance.
Region: the region in which the ECS instance is deployed.
SSH
If you select SSH, you must configure the following parameters:
You can deploy a jump server and access the database over an SSH tunnel. To obtain the jump server information, contact O&M personnel or system administrators.
SSH Host: the IP address of the jump server.
SSH Username: the username that is used to log on to the jump server.
SSH Password: the password that is used to log on to the jump server.
SSH Port Number: the port number that is used to connect to the jump server. Default value: 22.
For more information, see Connect to a Linux instance by using a password.
Enable the file upload portal
You can upload files after you enable this function.
Click Test Connection to verify that the data source can be connected.
After the connectivity test is passed, click OK. Then, the ApsaraDB for SelectDB instance is added as a data source.
What to do next
After you add a data source, you can create a dataset and analyze data.
For more information about how to add data tables in the Apache Doris database or user-created SQL statements to the Quick BI, see Create and manage datasets.
You can add charts for data analysis. For more information, see Create a dashboard and Overview of visualization charts.
Drill down the data for in-depth data analysis. For more information, see the Configure the drilling feature section of the "Drilling" topic.