The StarRocks data source is used to connect the StarRocks database to the Quick BI. After the connection is successful, you can analyze and display data on the Quick BI. You can connect a Quick BI to a StarRocks database over the Internet or a virtual private cloud (VPC). This topic describes how to add a user-created StarRocks data source.
Prerequisites
Your network meets the following requirements:
If you Quick BI connect to the StarRocks database over the Internet, add the Quick BI IP address to the whitelist of the database. For more information, see Add security group rules.
You can connect your Quick BI to the StarRocks database over an internal network. Use one of the following methods to connect the data source to the Quick BI:
If the StarRocks database is deployed on an Elastic Compute Service (ECS) instance, you can connect the database 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 self-managed StarRocks database is created.
The username and password of the user-created StarRocks database are obtained.
Limits
Version 2.0.1 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 StarRocks data source.
Select User-created Data Source Type.
In the Configure Connection dialog box, configure the following settings based on your business requirements.
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 StarRocks database is deployed, including the IP address or domain name.
Port Number
The corresponding port number of the database.
Instance
The name of the StarRocks database.
Username and Password
The username and password used to log on to the StarRocks 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 StarRocks database is deployed on a ECS and the network type is Alibaba Cloud VPC, select VPC Data Source and configure the following parameters:
Purchaser AccessId: the AccessKey ID that is used to purchase the instance.
Buyer AccessKey: the AccessKey secret that is used to purchase the instance.
Instance ID: the ID of the ECS instance.
Region: the region where the ECS instance is located.
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: Enter the IP address of the jump server.
SSH Username: the username used to log on to the jump server.
SSH Password: the password used to log on to the jump server.
SSH Port: the port of the jump server. Default value: 22.
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 data source is added, click OK.
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 StarRocks database or user-created custom 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.