This topic guides you through the process of adding a DaMeng data source in Quick BI to establish a connection with the DaMeng database. Once connected, you can perform data analysis and visualization in Quick BI. Quick BI supports connections to the DaMeng database via both the public network and Alibaba Cloud VPC.
Prerequisites
Ensure your network connectivity:
For public network connections, add Quick BI's IP address to the database whitelist. For more information, see adding a security group rule.
For internal network connections, ensure connectivity between the data source and Quick BI using one of the following methods:
If the DaMeng database is hosted on Alibaba Cloud ECS, establish a connection through Alibaba Cloud VPC.
Alternatively, deploy a jump server and set up an SSH tunnel to access the database.
The DaMeng database must be user-created.
Retrieve the username and password for the user-created DaMeng database.
Limits
Supports DaMeng database versions 7.0 and 8.0.
Procedure
Log on to the Quick BI console.
Follow the steps illustrated below to add a data source:
Access the data source creation interface via the data source creation entry.
Click Show more.
Select the DaMeng data source.
In the Configure Connection dialog box, configure the connection settings according to your business needs.
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 DaMeng database is deployed, including the IP or domain name.
Port
The corresponding port number of the database.
Database
The custom database name when the DaMeng database is deployed.
Username and Password
The username and password to log on to the DaMeng database. Ensure that the username has create, insert, update, and delete permissions on tables in the database.
VPC Data Source
Only select VPC Data Source and configure the following parameters if the DaMeng database is deployed on Alibaba Cloud ECS and the network type is Alibaba Cloud VPC network:
Purchaser Accessid: The AccessKey ID of the purchaser of this instance.
For more information, see obtain AccessKey.
NoteEnsure that the AccessKey ID has Read permission on the destination instance. Additionally, if it has 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 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.
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 adding the data source, you can proceed to create datasets and analyze data.
To incorporate data tables from the DaMeng database or create custom SQL in Quick BI, refer to creating and managing datasets.
For adding visualization charts and data analysis, see creating a dashboard and visualization chart overview.
To delve deeper into data analysis, refer to drill settings and display.