This topic explains how to add a PolarDB for MySQL data source to DataV, including details on the relevant parameter configurations. PolarDB is a cloud-native relational database from Alibaba that is fully compatible with MySQL syntax.
Prerequisites
You must have a PolarDB for MySQL data source ready to add.
You must first add the whitelist IP address of the corresponding area to your data source whitelist to ensure that DataV-Board can access your database normally. For more information, see configure database whitelist.
Limits
Supports only Enterprise Edition or higher.
Add a data source through the intranet
Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
-
Select PolarDB for MySQL from the Type list.
-
Choose Intranet and select the region where your PolarDB instance is located.
-
Enter the database information.
Parameter
Description
Name
The display name of the data source. You can specify a custom name.
VPC ID
The ID of the VPC-connected instance. This VPC is where your PolarDB for MySQL instance resides. You can go to the PolarDB console and obtain it from the instance basic information page. You can configure and add the DataV VPC intranet address of the instance's region to the whitelist to view the VPC ID and VPC Instance ID.
Instance ID
The ID of the database instance in the VPC. You can obtain it from the instance basic information page in the PolarDB console.
Domain Name
The intranet address used to connect to the database.
ImportantThis address is the domain name or IP address that the DataV server can access through the public network or the intranet in certain Alibaba Cloud regions.
For example, when using Alibaba Cloud PolarDB for MySQL in an intranet environment, the domain name might look like: xxxxxxxx.mysql.polardb.rds.aliyuncs.com. You can go to the instance basic information page in the PolarDB console, click to configure and add the DataV VPC intranet address of the instance's region to the whitelist. Once the intranet address takes effect, you can use it.
Port
The port set for the database. The default value is 3306.
Username
The username that is used to log on to the database.
Password
The password that is used to log on to the database.
Database
The name of the currently selected database.
-
Once the database information is entered, the system will automatically test the connection to ensure it can connect to the database successfully.
-
Click OK after a successful connection test to finish adding the data source.
The new data source will be listed automatically in the data source list.
Add a data source through the internet
Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
-
Select PolarDB for MySQL from the Type list.
-
Choose Internet from the list.
-
Provide the necessary information for the PolarDB for MySQL data source.
Parameter
Description
Name
The display name of the data source. You can specify a custom name.
Domain Name
The internet address used to connect to the database.
ImportantThis address is the domain name or IP address that the DataV server can access through the public network or the intranet in certain Alibaba Cloud regions.
For example, when using Alibaba Cloud PolarDB for MySQL in an internet environment, the domain name might look like: xxxxxxxx.mysql.polardb.rds.aliyuncs.com. You can go to the instance basic information page in the PolarDB console, click to request an internet address, and configure and add the DataV internet whitelist. Once the internet address takes effect, you can use it.
Port
The port set for the database.
Username
The username that is used to log on to the database.
Password
The password that is used to log on to the database.
Database
The name of the currently selected database.
-
After entering the information, click OK to add the data source.
The new data source will appear automatically in the data source list.
What to do next
Once you have the raw data, you can consult datasource config for widget data adaptation.
FAQ
For additional questions, consult the FAQ about datasource config.