Add an Apache Doris data source to connect your Apache Doris database with Quick BI. After a successful connection, you can analyze and visualize data in Quick BI. Quick BI supports connecting to your Apache Doris database over the public internet or through an Alibaba Cloud VPC. This topic describes how to add a self-managed Apache Doris data source.
Prerequisites
Ensure network connectivity:
If you connect Quick BI to your Apache Doris database over the public internet, add Quick BI's IP addresses to your database whitelist. For more information, see Use security groups.
If you connect Quick BI to your Apache Doris database over a private network, use one of the following methods to establish network connectivity between your data source and Quick BI:
If your Apache Doris database runs on an Alibaba Cloud ECS instance, connect using an Alibaba Cloud VPC.
Alternatively, set up a jump server and access the database through an SSH tunnel.
You have deployed a self-managed Apache Doris database.
You have obtained the username and password for your self-managed Apache Doris database.
Limits
Version 1.2.4 is supported.
Procedure
Log on to the Quick BI console.
Add a data source as follows.
Go to the data source creation page from the Create data source entry.
On the Self-managed data sources tab, select the Apache Doris data source.
In the Configure Connection dialog box, complete the following settings based on your scenario.
Name
Description
Display name
The display name for the data source in the configuration list. Enter a valid name without special characters. Do not include leading or trailing spaces.
Database address
The address where your Apache Doris database is deployed, such as an IP address or domain name.
Port
The port corresponding to your Apache Doris database address.
Database
The custom database name you defined when deploying Apache Doris.
Username and Password
The username and password for logging on to your Apache Doris database. Ensure this user has create, insert, update, and delete permissions on tables in the database.
VPC data source
If your database requires connectivity through an Alibaba Cloud VPC, select VPC data source and configure the parameters below. If you select VPC data source, enter the internal IP address and internal port for the database address and port.
If your database runs on an Alibaba Cloud ECS instance, select Instance. If you access it through a Classic Load Balancer (CLB), select CLB.
Instance
Owner AccessKey ID: The AccessKey ID of the account that purchased the instance.
NoteEnsure this AccessKey ID has read permissions on the destination instance. If it also has write permissions on the associated security group, the system automatically adds the required whitelist entries. Otherwise, add them manually. For more information, see Create a custom policy.
For more information, see Create an AccessKey.
Owner AccessKey Secret: The AccessKey Secret of the account that purchased the instance.
For more information, see Create an AccessKey.
Instance ID: The ECS instance ID. Log on to the ECS console and find the instance ID on the Instances tab.
For more information, see View instance information.
Region: The region where the ECS instance resides. Log on to the ECS console and check the region in the upper-left corner.
For more information, see View instance information.
CLB
Owner AccessKey ID: The AccessKey ID of the account that purchased the CLB instance. Ensure this account has read permissions on the CLB instance. Log on to the RAM console to obtain the AccessKey ID.
NoteEnsure this account has read permissions on the CLB instance.
For more information, see View AccessKey information for a RAM user.
Owner AccessKey Secret: The AccessKey Secret corresponding to the AccessKey ID. The AccessKey Secret appears only once during creation. If lost, create a new AccessKey.
Instance ID: The CLB instance ID. Log on to the Server Load Balancer console and find the instance ID in the instance list.
Region: The region where the instance resides. Log on to the Server Load Balancer console and check the region in the upper-left corner of the instance management page.
SSH
If you select SSH, configure the following parameters:
You can set up a jump server and access the database through an SSH tunnel. Obtain the jump server details from your O&M team or system administrator.
SSH Host: Enter the IP address of the jump server.
SSH username: The username for logging on to the jump server.
SSH password: The password for the SSH username.
SSH port: The port of the jump server. Default is 22.
For more information, see Use OpenSSH/XShell to remotely connect to a Linux instance.
Enable file upload
When enabled, file upload is supported.
Click Test Connection to verify connectivity to the data source.
After a successful test, click OK to complete adding the data source.
What to do next
After creating the data source, you can create datasets and analyze data.
Add tables from your Apache Doris database or custom SQL statements to Quick BI. For more information, see Create and Manage Datasets.
Add visual charts and analyze data. For more information, see Create a Dashboard and Overview of visual charts.
Drill down for in-depth data analysis. For more information, see Step 3: Configure and display drilling.