All Products
Search
Document Center

DataV:add-an-AnalyticDB-for-MySQL-data-source

Last Updated:Dec 11, 2023

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

Prerequisites

The AnalyticDB for MySQL data source is ready to be added.

Procedure for adding a data source over an internal network

  1. Log on to the DataV console .
  2. On the My Data tab, click Data Source and click Add Data.

  3. In the Type list, select AnalyticDB for MySQL.

  4. In the Network section, select Intranet and select the region where the instance resides. The default region is China (Hangzhou).

  5. Enter the database information.

    Parameter

    Description

    Name

    The name of the data source. You can specify a custom name.

    VPC ID

    The ID of the VPC where your AnalyticDB for MySQL instance resides. Accessibleobtained in the DMS for AnalyticDB.

    Instance ID

    The ID of the database instance in the VPC, which can be found in theobtained in the DMS for AnalyticDB.

    Note

    Generally, you can view the VPC ID of a database instance in the console of a 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. You can call the API operation of a database service to obtain the ID of the VPC that is required by DataV. In most cases, the ID is VPCCloudInstanceId or VPCInstanceId in the details of the database instance. To obtain the ID of the VPC, you can call the DescribeDBClusterAttribute -Querying Cluster Details operation to obtain the ID of the VPC.

    Domain name

    The domain name or IP address that is used to connect to the database.

    Important

    The 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.

    For example, if you use an Alibaba Cloud AnalyticDB for MySQL in an Internet environment, an example of a domain name is am-bp1uxxxxxxxxxxxxxx0o.ads.aliyuncs.com.DMS for AnalyticDB the Cluster Information page.

    Port

    The port set for the database. Default value: 3306.

    Username

    The username that is used to connect to the database.

    Password

    The password that is used to connect to the database.

    Database

    The name of the database. Select the desired database.

    After you complete the database information, DataV automatically tests whether the database can be connected.

    Important

    If an error message Access VPC instance fail appears when you test the connection to the database, you can add a -mysql, -instance, or -controller suffix to the instance ID and try to test the connection to the database again.

  6. After the connection 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

  1. Log on to the DataV console .
  2. On the My Data tab, click Data Source and click Add Data.

  3. On the My Data page, click Add Data.

  4. From the Type list, select AnalyticDB for MySQL.

  5. In the Network section, select Internet.

  6. Enter the database information.

    Parameter

    Description

    Name

    The name of the data source. You can specify a custom name.

    Domain name

    The domain name or IP address that is used to connect to the database.

    Important

    The 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

    The port that is used to connect to the database.

    Username

    The username that is used to connect to the database.

    Password

    The password that is used to connect to the database.

    Database

    The name of the database. Select the desired database.

    After you enter the database information, DataV automatically tests whether the database can be connected.

    Important

    If an error message Access VPC instance fail appears when you test the connection to the database, you can add a -mysql, -instance, or -controller suffix to the instance ID and try to test the connection to the database again.

  7. After the connection passes the connectivity test, click OK.

    The added data source is displayed in the data source list.