This topic describes how to add a Distributed Relational Database Service (DRDS) data source. Only Quick BI Enterprise Standard and Quick BI Pro allow you to add DRDS data sources.

Prerequisites

  • A DRDS database is created.
  • The username and password that are used to connect to the DRDS 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 DRDS card.
    drds_intl
  4. In the Add DRDS Database dialog box, configure the following parameters.
    drds3.12.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 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 of 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 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. 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.
    Verify that the data source can be connected 3.12.1
  6. Click OK.

What to do next

After you add a data source, you can create a dataset and analyze data.
  • You can add data tables in the DRDS data source or user-defined SQL statements for ad hoc analysis to Quick BI. For more information, see Create a dataset.
  • For more information about how to add visual charts and analyze data, see Create a dashboard and Overview.
  • For more information about how to mine data value and deeply analyze data, see Configure the drilling feature.