Add a PolarDB for MySQL data source to DataV and configure the required connection parameters. PolarDB is a next-generation cloud-native relational database developed by Alibaba Cloud, fully compatible with MySQL syntax.
Prerequisites
The PolarDB for MySQL data source that you want to add is available.
You must add the IP addresses for the corresponding region to the whitelist of your data source. This ensures that DataV can access your database. For more information, see Configure a database whitelist.
Limits
This feature is available only in DataV Enterprise Edition and later versions.
Add a data source over a private network
Access the DataV console.
On the Workbench page, click in the navigation pane on the left. On the Data Source page, click New Data Source.
-
From the Type list, select PolarDB for MySQL.
-
Set Network to Private Network and select the region that contains the PolarDB instance.
-
Enter the database information.
Parameter
Description
Name
The display name of the data source. You can enter any name.
VPC ID
The ID of the VPC where your PolarDB for MySQL instance resides. You can obtain this ID from the PolarDB console. To view the VPC ID and VPC Instance ID, first add the private IP address of the DataV VPC for the instance's region to the whitelist.
VPC Instance ID
The ID of the PolarDB for MySQL instance in the VPC. You can obtain this ID from the instance's basic information page in the PolarDB console.
Domain Name
The private endpoint used to connect to the database.
ImportantThe domain name or IP address that the DataV server uses to access your database over the public network or a private network in specific Alibaba Cloud regions.
For example, a private domain name for a PolarDB for MySQL instance looks like this: xxxxxxxx.mysql.polardb.rds.aliyuncs.com. To use this domain name, go to the instance's basic information page in the PolarDB console. Click Configure and add the private IP address of the DataV VPC for the instance's region to the whitelist.
Port
The port used by the database. Default value: 3306.
Username
The username used to connect to the database.
Password
The password used to connect to the database.
Database
The name of the current database.
-
After you enter the database information, the system automatically tests the connection to verify database accessibility.
-
After the connection test succeeds, click OK to add the data source.
The new data source appears in the data source list.
Add a data source over the internet
Access the DataV console.
On the Workbench page, click in the navigation pane on the left. On the Data Source page, click New Data Source.
-
From the Type list, select PolarDB for MySQL.
-
From the list, select Public Network.
-
Enter the information for the PolarDB for MySQL data source.
Parameter
Description
Name
The display name of the data source. You can enter any name.
Domain Name
The public endpoint used to connect to the database.
ImportantThe domain name or IP address that the DataV server uses to access your database over the public network or a private network in specific Alibaba Cloud regions.
For example, a public domain name for a PolarDB for MySQL instance looks like this: xxxxxxxx.mysql.polardb.rds.aliyuncs.com. To use this domain name, go to the instance's basic information page in the PolarDB console. Request a public endpoint and add the public IP addresses of DataV to the whitelist.
Port
The port used by the database.
Username
The username used to connect to the database.
Password
The password used to connect to the database.
Database
The name of the current database.
-
After you enter the information, click OK to add the data source.
The new data source appears in the data source list.
What to do next
After you obtain the raw data, see Configure a widget data source to adapt the data for your widgets.
FAQ
For more information, see FAQ about data source configuration and usage.