Add an AnalyticDB for MySQL data source - DataV

This topic describes how to add an AnalyticDB for MySQL data source in DataV.

Prerequisites

You must have an AnalyticDB for MySQL data source ready to be added.

Important

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

All DataV versions are supported.

Add a data source through the internal network

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source in the left-side navigation pane to access the Data Source page, and then click Create 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 specify a custom name.
VPC ID	The ID of the VPC-connected instance. This VPC is where your AnalyticDB for MySQL instance is located. You can obtain it from the AnalyticDB console.
VPC Instance ID	The ID of the database instance under the VPC. You can obtain it from the AnalyticDB console. Note Usually, you can directly view the VPC-connected instance ID of the database instance in the console of the database product. However, due to the implementation mechanism of the VPC network, sometimes the instance ID displayed in the console is not the instance ID required by the DataV datasource config VPC network. Therefore, you need to obtain the VPC-connected instance ID required by DataV through the OpenAPI of the database product. It is usually the VPCCloudInstanceId or VPCInstanceId in the details of the database instance. To obtain the interface for the VPC-connected instance ID of a specific database product, use the DescribeDBClusterAttribute - Query the detailed properties of the cluster interface to obtain the VPC-connected instance ID.
Domain Name	The address to connect to the database. Important This address is the domain name or IP address that the DataV server needs to access your database through the public network or the internal network of some Alibaba Cloud regions. For example, when using Alibaba Cloud AnalyticDB for MySQL in an external network environment, the domain name example is: am-bp1uxxxxxxxxxxxxxx0o.ads.aliyuncs.com. You can obtain it from the cluster information page of the AnalyticDB console.
Port	The port set by the database. The default 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 details are entered, the system will automatically test the connection to ensure it can be established successfully.

Once the connection test succeeds, click OK to finalize the data source addition.

The new data source will appear automatically in the data source list.

Add a data source through the external network

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source in the left-side navigation pane to access the Data Source page, and then click Create 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 specify a custom name.
Domain Name	The address to connect to the database. Important This address is the domain name or IP address that the DataV server needs to access your database through the public network or the internal network of some Alibaba Cloud regions. For example, when using Alibaba Cloud AnalyticDB for MySQL in an external network environment, the domain name example is: am-bp1uxxxxxxxxxxxxxx0o.ads.aliyuncs.com. You can obtain it from the cluster information page of the AnalyticDB console.
Port	The port set by 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.

Once the database details are entered, the system will automatically test the connection to ensure it can be established successfully.

Once the connection test succeeds, click OK to finalize the data source addition.

The new data source will appear automatically in the data source list.

What to do next

Once you have the raw data, you can refer to widget data source configuration for widget data adaptation.

FAQ

For more information, see Data Source FAQ.