Connect Quick BI to your Tencent Cloud MySQL database by adding a TencentDB for MySQL data source. After the connection is established, you can analyze and visualize your data in Quick BI.
Prerequisites
You have created a TencentDB for MySQL database.
Limitations
Supported TencentDB for MySQL versions: 5.5, 5.6, 5.7, and 8.0.
Procedure
-
Add IP addresses to the whitelist.
Before you connect to TencentDB for MySQL, you must add the IP addresses of Quick BI to the security group of your TencentDB for MySQL instance. For instructions, see the Tencent Cloud documentation on how to manage cloud database security groups.
-
Test the connection and create the data source.
-
Log on to the Quick BI console.
-
Follow these steps to add the data source:
-
Go to the page for creating a data source. For instructions, see Create a data source.
-
On the Tencent Cloud Databases tab, select TencentDB for MySQL.
-
-
In the Configure Connection dialog box, specify the following parameters.
Parameter
Description
Data source type
MySQL data sources support Alibaba Cloud, Tencent Cloud, HUAWEI CLOUD, Microsoft Azure, AWS, and self-hosted databases.
In this example, select Tencent Cloud.
Display name
The display name of the data source.
The name cannot contain special characters or leading or trailing spaces.
Database address and Port
The public endpoint of your MySQL database. To obtain it, log on to the TencentDB for MySQL console, go to the instance details page, enable public network access, and find the endpoint in the basic information section.
For more information, see the Tencent Cloud documentation.
Database
The name of the database to connect to.
Username and Password
The username and password for the MySQL database.
NoteEnsure that the database user has the create, insert, update, and delete permissions on the tables in the database.
Database version
The version of your MySQL database.
If your database version is 5.7 or earlier, select 5.7. If your database version is 8.0, select 8.0.
SSL
Encrypts data in transit. Select this option if your data source is configured with SSL.
Initial SQL
Runs specified SQL statements immediately after a connection is established. Only SET statements are allowed.
Separate multiple statements with semicolons (;).
Enable file upload
Allows file uploads to the data source.
-
Click Test Connection to verify the connection.
-
If the connection test is successful, click OK to add the data source.
-
Next steps
After the data source is created, you can create a dataset and start analyzing your data.
-
To add tables or custom SQL queries from your MySQL data source to a dataset, see Create a dataset.
-
To add visualizations and analyze data, see Create a dashboard and Overview of visualizations.
-
To drill down and perform in-depth data analysis, see Step 3: Configure and display drill-down.