DataV is an Alibaba Cloud data visualization service that allows you to analyze and present huge amounts of complex data as visual dashboards. You can add an AnalyticDB for MySQL data source to DataV and use DataV to perform visual analysis of AnalyticDB for MySQL data.
Prerequisites
The AnalyticDB for MySQL data source to be added is prepared.
Procedure for adding a data source over an internal network
Log on to the DataV console.
On the My Data tab, select Data Source and click Add Source.
In the Type list, select AnalyticDB for MySQL.
Select Internal from the Network drop-down list and select the region where the instance resides. The default region is China East 2.
Enter database information.
Parameter
Description
Name
The name of the data source. Enter a custom name.
VPC ID
The ID of the VPC instance. This VPC is the VPC where your AnalyticDB for MySQL instance resides. You can obtain it from the DMS for AnalyticDB .
Instance ID
The ID of the database instance in the VPC, which can be obtained from the DMS for AnalyticDB .
NoteGenerally, you can view the VPC instance ID of the DB instance directly in the console of the database product. However, due to the VPC network implementation mechanism, sometimes the instance ID displayed in the console is not the instance ID required to configure the VPC network for the DataV data source. Therefore, you need to use the OpenAPI of the database product to obtain the VPC instance ID required by DataV, which is usually the VPCCloudInstanceId or VPCInstanceId in the details of the database instance. For a specific database product, use the DescribeDBClusterAttribute interface to obtain the VPC instance ID.
domain name
The domain name or IP address that is used to connect to the database.
ImportantThe DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud.
If you need to access an AnalyticDB for MySQL database over the Internet, an example of the domain name is am-bp1uxxxxxxxxxxxxxx0o.ads.aliyuncs.com. You can log on to the AnalyticDB console and view the required information on the Clusters page.
Port Number
The port set by the database. Default value: 3306.
Username
The username that is used to log on to the ApsaraDB RDS for MySQL database.
Password
The password that is used to log on to the ApsaraDB RDS for MySQL database.
Database
The name of the database.
After you complete the database information, DataV automatically tests whether the database can be connected.
ImportantWhen the connection to the database is tested, after the error message Access VPC instance fail appears, you can add the -mysql, -instance, or -controller suffix to the instance ID and try to test the connection to the database again.
After the database passes the connectivity test, click OK.
The added data source is displayed in the data source list.
Procedure for adding a data source over the Internet
Log on to the DataV console.
On the My Data tab, click Data Source and click Add Data.
On the My Data page, click Add Data.
Select AnalyticDB for MySQL from the Type drop-down list.
Select Internet from the Network drop-down list.
Enter database information.
Parameter
Description
Name
The name of the data source. Enter a custom name.
domain name
The domain name or IP address that is used to connect to the database.
ImportantThe DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud.
If you need to access an AnalyticDB for MySQL database over the Internet, an example of the domain name is am-bp1uxxxxxxxxxxxxxx0o.ads.aliyuncs.com. You can log on to the AnalyticDB console and view the required information on the Clusters page.
Port Number
The port that is used to connect to the database.
Username
The username that is used to log on to the ApsaraDB RDS for MySQL database.
Password
The password that is used to log on to the ApsaraDB RDS for MySQL database.
Database
The name of the database.
After you enter the database information, DataV automatically tests whether the database can be connected.
ImportantWhen the connection to the database is tested, after the error message Access VPC instance fail appears, you can add the -mysql, -instance, or -controller suffix to the instance ID and try to test the connection to the database again.
After the database passes the connectivity test, click OK.
The added data source is displayed in the data source list.
Use DataV
For information about how to use DataV, see Use a template to create a project.