The Dameng data source is used to connect the Dameng database to the Quick BI. After the connection is successful, you can analyze and display data on the Quick BI. You can Quick BI connect to Dameng Database over the Internet or a virtual private cloud (VPC). This topic describes how to add a user-created Dameng data source.
Prerequisites
Your network meets the following requirements:
If you want to connect your Quick BI to the Damon 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 use one of the following methods to connect the data source to the Damon database by connecting the Quick BI to the Quick BI over an internal network:
If the Dameng 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 self-managed Dameng database is created.
The username and password of the user-created Dameng database are obtained.
Limits
Supports 7.0 and 8.0 versions.
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 Dameng data source.
In the Configure Connection dialog box, configure the following parameters 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 Dameng database is deployed, including the IP address or domain name.
Port Number
The corresponding port number of the database.
Instance
The custom database name when you deploy the Dameng database.
Username and Password
The username and password used to log on to the Damon 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 Damon 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: Enter the IP address of the springboard machine.
SSH Username: the username used to log on to the jump server.
SSH Password: the password that is used to log on to the jump server.
SSH Port: the port of the jump server. Default value: 22.
For more information, see Connect to a Linux instance by using a password.
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 Dameng 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.