This topic describes how to add a cloud data source PolarDB for MySQL. Only Quick BI Enterprise Standard and Quick BI Pro allow you to add cloud data sources PolarDB for MySQL in group workspaces.

Prerequisites

  • A PolarDB for MySQL database is created.
  • The username and password that you use to access the PolarDB for MySQL database are obtained.
  • 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 PolarDB for MySQL card.
    pdb
  4. In the Add PolarDB for MySQL Database dialog box, configure the parameters.
    Add a cloud data source PolarDB for MySQL
    Parameter Description
    Name The name of the data source. In this example, set the value to cloud data source PolarDB_for_MySQL.
    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 PolarDB.
    Username The username that you use to access the database. In this example, set the value to root.
    Password The password that you use to access the database.
    VPC Data Source If the data source is connected over a VPC, select VPC Data Source and configure the parameters.
    AccessKey ID The AccessKey ID that you use to purchase the instance where the database resides.
    Note This parameter appears only when you select VPC Data Source.
    AccessKey Secret The AccessKey secret that you use to purchase the instance where the database resides.
    Note This parameter appears only when you select VPC Data Source.
    Cluster ID The ID of the PolarDB cluster.
    Note This parameter appears only when you select VPC Data Source.
    Region The region where the database instance resides.
    Note This parameter appears only when you select VPC Data Source.
  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.