Quick BI is a next-generation self-service business intelligence (BI) platform that is tailored for cloud users and enterprises. Quick BI provides a GUI and supports flexible and efficient multidimensional analysis. Quick BI helps you gain fine-grained data-driven insights into your business. You can connect to ApsaraDB ClickHouse over the Internet or a virtual private cloud (VPC), add an ApsaraDB ClickHouse data source to Quick BI, and build a BI system for your ApsaraDB for ClickHouse cluster. This topic describes how to add an ApsaraDB ClickHouse data source to Quick BI.

Prerequisites

  • An ApsaraDB ClickHouse cluster is created. For more information, see Create an ApsaraDB for ClickHouse cluster.
  • A username and a password of a database account are created. For more information, see Create an account.
  • The CIDR blocks of Quick BI are added to the whitelist of ApsaraDB ClickHouse. For more information, see Configure a whitelist.
  • If Quick BI is not deployed in the same VPC as the ApsaraDB ClickHouse cluster, you must apply for a public endpoint for the ApsaraDB ClickHouse cluster. For more information, see Apply for a public endpoint.

Limits

  • Only workspace administrators and developers can add data sources.
  • Only Quick BI Enterprise Standard and Quick BI Pro allow you to add ApsaraDB for ClickHouse data sources in group workspaces.

Procedure

  1. Log on to the Quick BI console.
  2. In the top navigation bar, click Workbench. In the left-side navigation pane, click Data Sources.
  3. In the upper-right corner of the Data Sources page, click Create Data Source.
  4. In the Add Data Source dialog box, click the Cloud Data Sources tab. Then, click the ClickHouse card.
  5. In the Add ClickHouse Data Sources dialog box, configure the parameters.
    • 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 is displayed in the data source list.

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

      Database Address The public endpoint of the ApsaraDB for ClickHouse cluster.
      Port Number The port number that is used to connect to the ApsaraDB for ClickHouse cluster. Default value: 8123.
      Database The name of a database in the ApsaraDB for ClickHouse cluster.
      Username The username that you use to connect to a database in the ApsaraDB for ClickHouse cluster.
      Password The password that you use to connect to a database in the ApsaraDB for ClickHouse cluster.
      Time Zone The time zone of the database in the ApsaraDB for ClickHouse cluster.
    • If the data source is connected over a VPC, select VPC Data Source and configure the following parameters.
      Parameter Description
      Name The name of the data source. The name is displayed in the data source list.

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

      Database Address The internal endpoint of the ApsaraDB for ClickHouse cluster.
      Port Number The port number that is used to connect to the ApsaraDB for ClickHouse cluster.
      Database The name of a database in the ApsaraDB for ClickHouse cluster.
      Username The username that you use to connect to a database in the ApsaraDB for ClickHouse cluster.
      Password The password that you use to connect to a database in the ApsaraDB for ClickHouse cluster.
      Time Zone The time zone of the database in the ApsaraDB for ClickHouse cluster.
      VPC Data Source Select VPC Data Source and configure the following parameters:
      • AccessKey ID: the AccessKey ID that is used to purchase the ApsaraDB for ClickHouse cluster. For more information, see Obtain an AccessKey pair.
      • AccessKey Secret: the AccessKey secret that is used to purchase the ApsaraDB for ClickHouse cluster. For more information, see Obtain an AccessKey pair.
      • Instance ID: the ID of the ApsaraDB for ClickHouse cluster.
      • Region: the region in which the ApsaraDB for ClickHouse cluster is deployed.
  6. Click Test Connection to verify that the data source can be connected.
  7. After the data source passes the connectivity test, click OK.
    The data source that you created is displayed in the data source list.

What to do next

After you add a data source, you can create a dataset and analyze data.