Add a DM data source to connect your DM database to Quick BI for data analysis and visualization. Quick BI supports connections to DM databases over the public network or through an Alibaba Cloud VPC.
Prerequisites
Ensure network connectivity:
If you connect Quick BI to your DM database over the public network, add the IP addresses of Quick BI to the database whitelist. For more information, see Security groups.
If you connect Quick BI to your DM database over an internal network, use one of the following methods to connect:
If your DM database is hosted on an Alibaba Cloud ECS instance, you can connect through an Alibaba Cloud VPC.
You can also set up a bastion host and use an SSH tunnel to access the database.
You have created a DM database.
You have the username and password for your DM database.
Limitations
DM 7.0 and 8.0 are supported.
Only MySQL-compatible mode is supported.
Procedure
Log on to the Quick BI console.
Add a data source as follows:
Go to the data source creation page.
On the User-created data source tab, select DM.
In the Configure Connection dialog box, set the parameters as needed.
Parameter
Description
Display Name
The display name of the data source.
The name must not contain special characters or leading or trailing spaces.
Database Address
The IP address or domain name of the DM database host.
Port
The port number of the database.
Database
The name of the database specified at deployment.
Username and Password
The username and password for the DM database. Ensure that this user has the
create,insert,update, anddeletepermissions on the tables in the database.VPC data source
If your DM database is hosted on an Alibaba Cloud ECS instance in an Alibaba Cloud VPC, select VPC data source and configure the following parameters:
AccessKey ID: The AccessKey ID of the instance owner's account.
For more information, see Create an AccessKey.
NoteEnsure that the AccessKey ID has the
Readpermission for the target instance. If the AccessKey ID also has theWritepermission for the corresponding security group, the system automatically adds the required IP addresses to the whitelist. Otherwise, you must add them manually. For more information, see Create a custom policy.AccessKey Secret: The AccessKey Secret of the instance owner's account.
For more information, see Create an AccessKey.
Instance ID: The ID of the ECS instance. Log on to the ECS console and obtain the instance ID from the Instances page.
For more information, see View instance information.
Region: The region of the ECS instance.
For more information, see View instance information.
SSH
If you select SSH, configure the following parameters:
Set up a bastion host and use an SSH tunnel to access the database. Contact your O&M engineer or system administrator for the bastion host information.
SSH Host: The IP address of the bastion host.
SSH Username: The username for the bastion host.
SSH Password: The password for the specified SSH username.
SSH Port: The port on the bastion host. The default is 22.
For more information, see Use OpenSSH or Xshell.
Click Test Connection to verify the connection.
After a successful connection test, click OK to add the data source.
Next steps
After you add the data source, you can create datasets and analyze your data.
Add tables from the DM database or use custom SQL to create datasets in Quick BI. For more information, see Create and manage a dataset.
Create visualization charts to analyze data. For more information, see Create a dashboard and Overview of visualization charts.
Drill down into data for in-depth analysis. For more information, see Step 3: Configure and display drill-down data.