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 create an AnalyticDB for MySQL connection in DataV and use DataV to perform visual analysis of AnalyticDB for MySQL data.

Create an AnalyticDB for MySQL connection in DataV

  1. Log on to the DataV console.
  2. Choose Data Sources > Add Source.
  3. Select AnalyticDB for MySQL from the Type drop-down list.
  4. Configure the parameters.
    Parameter Description
    Name The name of the data source. We recommend that you choose an identifiable name to facilitate subsequent management.
    Domain Name The endpoint of the AnalyticDB for MySQL database to which you want to connect.
    Note Enter the domain name or IP address for DataV to access the database over the Internet or the internal network of Alibaba Cloud regions.

    If you use AnalyticDB for MySQL over the Internet, you can reference the following example to specify the domain: am-bp1uxxxxxxxxxxxxxx0o.ads.aliyuncs.com. You can obtain the endpoint of the cluster on the Cluster Information page of the AnalyticDB for MySQL console.

    Username The account used to connect to the AnalyticDB for MySQL cluster. You can use one of the following account types:
    • Privileged account
    • Standard account
    Password The password of the account used to connect to the AnalyticDB for MySQL cluster.
    Port The port of the AnalyticDB for MySQL cluster endpoint.
    Database The name of the database in the AnalyticDB for MySQL cluster.

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

  5. After the connection passes the test, click OK. The new data source is displayed on the page.

Use DataV

For more information about how to use DataV, see Create a project.