This topic describes how to add an AnalyticDB for MySQL V3.0 data source.

Prerequisites

  • An AnalyticDB for MySQL V3.0 database is created.
  • The username and password that are used to log on to the AnalyticDB for MySQL V3.0 database are obtained.

Procedure

  1. Choose Workspace > Data Sources.
  2. In the upper-right corner of the Data Sources page, click Create Data Source.
  3. In the Add Data Source dialog box, click the Cloud Data Sources tab. Then, click the AnalyticDB for MySQL 3.0 card.
    analytic_DB_3.0_intl
  4. In the Add AnalyticDB for MySQL 3.0 Database dialog box, configure the following parameters.
    Add a data source 312.1
    • If you use the Internet to connect Quick BI to the data source, configure the following parameters.
      Parameter Description
      Name The name of the data source. The name appears in the list of data sources.

      The name can contain letters, digits, underscores (_), and hyphens (-).

      Database Address The public endpoint of the database.
      Port Number The port number that is used to connect to the database over the Internet.
      Database The custom name of the database. The name is specified when you create 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.
    • If you use a virtual private cloud (VPC) to connect Quick BI to the data source, select VPC Data Source and configure the following parameters.
      Parameter Description
      Name The name of the data source. The name appears in the list of data sources.

      The name can contain letters, digits, underscores (_), and hyphens (-).

      Database Address The private endpoint that is used to connect to the database.
      Port Number The port number that is used to connect to the database over the VPC.
      Database The custom name of the database. The name is specified when you create 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.
      VPC Data Source Select VPC Data Source and configure the following parameters:
      • AccessKey ID: the AccessKey ID that you used to purchase the instance on which the database is deployed. For more information, see Obtain an AccessKey pair.
      • AccessKey Secret: the AccessKey secret that you used to purchase the instance. For more information, see Obtain an AccessKey pair.
      • Instance ID: the ID of the instance.
      • Region: the region in which the instance is deployed.
  5. Click Test Connection to verify that the data source can be connected.
  6. Click OK.