To connect the Apache Doris database with Quick BI, add an Apache Doris data source. This enables data analysis and visualization within Quick BI. Connections to the Apache Doris database can be established through the public network or Alibaba Cloud VPC. This data source also supports connections to SelectDB and StarRocks. This topic describes the process of adding a user-created Apache Doris data source.
Prerequisites
Ensure your network meets the following requirements:
For connections over the public network, add Quick BI's IP address to the database whitelist. For more information, see adding a security group rule.
For internal network connections, use one of the following methods:
Connect through Alibaba Cloud VPC if the Apache Doris database is deployed on Alibaba Cloud ECS.
Deploy a jump server and access the database via an SSH tunnel.
The Apache Doris database must be already created.
Obtain the username and password for the user-created Apache Doris database.
Limits
Support is provided for version 1.2.4.
Procedure
Log on to the Quick BI console.
Follow the steps in the figure below to add a data source.
Navigate to the data source creation interface via the data source creation entry.
Click Show more
Select the Apache Doris data source.
In the Configure Connection dialog box, configure the connection based on your specific business scenario.
Name
Description
Name
Description
Display Name
The display name in the datasource config 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 IP or domain name.
Port
The port corresponding to the address where the Apache Doris database is deployed.
Database
The database name customized when the Apache Doris database is deployed.
Username and Password
The username and password to log on to the Apache Doris database. Ensure that the username has create, insert, update, and delete permissions on tables in the database.
VPC Data Source
Only when the Apache Doris database is deployed on Alibaba Cloud ECS and the network type is Alibaba Cloud VPC, select VPC Data Source and configure the following parameters:
Purchaser Accessid: The AccessKey ID of the purchaser of this instance.
For more information, see obtain AccessKey.
Ensure that the AccessKey ID has Read permission on the destination instance. Additionally, if you have Write permission on the corresponding security group, the system will automatically add the whitelist. Otherwise, you need to manually add it. For more information, see create a custom policy.
Purchaser Accesskey: The AccessKey Secret of the purchaser of this instance.
For more information, see obtain AccessKey.
Instance ID: The ECS instance ID. Log on to the ECS console and obtain the instance ID on the instance tab.
For more information, see view instance information.
Area: The area where the ECS instance is located.
For more information, see view instance information.
SSH
If you select SSH, you need to configure the following parameters:
You can deploy a jump server and connect to the database over an SSH tunnel. To obtain the jump server information, contact O&M personnel or system administrators.
SSH Host: Enter the IP address of the jump server.
SSH Username: The username to log on to the jump server.
SSH Password: The password corresponding to the username to log on to the jump server.
SSH Port: The port of the jump server. Default value: 22.
For more information, see log on to a Linux instance by using password authentication.
Enable file upload entry
After enabling, file upload is supported.
Click Connection Test to verify the data source connectivity.
Once the test is successful, click OK to finalize the addition of the data source.
What to Do next
After the data source is created, proceed with dataset creation and data analysis.
To add data tables from the Apache Doris database or custom SQL to Quick BI, refer to creating and managing datasets.
For adding visualization charts and data analysis, refer to creating a dashboard and an overview of visualization charts.
For in-depth data analysis and drilling, refer to drill settings and display.