You can add an AnalyticDB for MySQL data source to DataV through the internal network or the external network.
Prerequisites
An AnalyticDB for MySQL data source must be available.
Add the IP addresses of the corresponding region to your data source whitelist to ensure that DataV can access your database. For more information, see Configure a database whitelist.
Limits
This feature is supported only in DataV Enterprise Edition or higher.
Add a data source through the internal 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.
-
In the Type list, select AnalyticDB for MySQL.
-
In the Network list, select Internal Network and choose the region where the instance is located (default is East China 2).
-
Enter the database details.
Parameter
Description
Name
The display name of the data source. You can customize this name.
VPC ID
The VPC ID of the AnalyticDB for MySQL instance. You can obtain it from the AnalyticDB console.
VPC Instance ID
The instance ID of the database in the VPC. You can obtain it from the AnalyticDB console.
NoteThe VPC instance ID displayed in the database console may differ from the one required by the DataV data source configuration. To get the correct ID, call the OpenAPI of the database product and check the VPCCloudInstanceId or VPCInstanceId field in the instance details. For AnalyticDB for MySQL, use the DescribeDBClusterAttribute - Query the detailed properties of the cluster interface.
Domain Name
The connection address of the database.
ImportantThis address is the domain name or IP address that the DataV server uses to access your database through the public network or the internal network of some Alibaba Cloud regions.
For example, for AnalyticDB for MySQL in an external network environment, the domain name format is: am-bp1uxxxxxxxxxxxxxx0o.ads.aliyuncs.com. You can obtain it from the cluster information page of the AnalyticDB console.
Port
The port of the database. Default: 3306.
Username
The username used to log on to the database.
Password
The password used to log on to the database.
Database
The name of the database to connect to.
After you enter the database details, the system automatically tests the connection.
-
After the connection test succeeds, click OK.
The data source is added and appears in the data source list.
Add a data source through the external 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.
-
In the Type list, select AnalyticDB for MySQL.
-
In the Network list, select External Network.
-
Enter the database details.
Parameter
Description
Name
The display name of the data source. You can customize this name.
Domain Name
The connection address of the database.
ImportantThis address is the domain name or IP address that the DataV server uses to access your database through the public network or the internal network of some Alibaba Cloud regions.
For example, for AnalyticDB for MySQL in an external network environment, the domain name format is: am-bp1uxxxxxxxxxxxxxx0o.ads.aliyuncs.com. You can obtain it from the cluster information page of the AnalyticDB console.
Port
The port of the database.
Username
The username used to log on to the database.
Password
The password used to log on to the database.
Database
The name of the database to connect to.
After you enter the database details, the system automatically tests the connection.
-
After the connection test succeeds, click OK.
The data source is added and appears in the data source list.
What to do next
To use the data source in your widgets, see Configure a widget data source.
FAQ
For more information, see FAQ about data source configuration and usage.