This topic describes how to add a cloud data source AnalyticDB for MySQL V2.0.

Prerequisites

  • An AnalyticDB for MySQL V2.0 database is created.
  • The AccessKey ID and AccessKey secret used for authentication are obtained.

Procedure

  1. Click the Workspace tab. In the left-side navigation pane, click Data Sources.
  2. On the Data Sources page, click Create Data Source in the upper-right corner.
  3. In the Add Data Source dialog box, click the Cloud Data Sources tab and then the AnalyticDB for MySQL 2.0 card.
    添加数据源
  4. In the Add AnalyticDB for MySQL 2.0 Database dialog box, configure the parameters.
    Add a cloud data source AnalyticDB for MySQL V2.0
    Parameter Description
    Select Database The databases available under the current account are displayed. In this example, select China (Hangzhou)_ads_demo.
    Note If no database is available under the current account, Select Database is not displayed.
    Name The name of the data source. In this example, set the value to ads_demo.
    Database Address The hostname or IP address of the database that is used as the data source.
    Port Number The port that you use to access the database. Default value: 3306.
    Database The name of the database that you want to access. In this example, set the value to quickbi.
    AccessKey ID The AccessKey ID that is displayed in the Alibaba Cloud Management Console.
    AccessKey Secret The AccessKey secret that is displayed in the Alibaba Cloud Management Console.
  5. Click Test Connection to test connectivity with the database.
    Test connectivity with the database
  6. After the database passes the connectivity test, click OK.