Quick BI supports self-managed Kylin data sources. If your business data is stored in a Kylin database, you must add a Kylin data source to Quick BI before you use Quick BI to process data. This topic describes how to add a self-managed Kylin data source.

Prerequisites

  • Make sure that your network meets the following requirements:
    • If you use the Internet to connect Quick BI to your Kylin database, make sure that the CIDR blocks of Quick BI are added to the whitelist of the Kylin database. For more information, see Add security group rules.

      The CIDR blocks of Quick BI are 10.152.69.0/24, 10.152.163.0/24, and 139.224.4.0/24.

    • If you use an internal network to connect Quick BI to the Kylin database, make sure that one of the following methods is used to ensure the connectivity between Quick BI and the self-managed Kylin data source:
      • If the Kylin database is deployed on an Elastic Compute Service (ECS) instance, you can use a virtual private cloud (VPC) to connect to the data source.
      • You can deploy a jump server and connect to the database over an SSH tunnel.
  • The username and password that are used to log on to the Kylin database are obtained.

Background information

Quick BI allows you to connect to your Kylin database to analyze and display data. Kylin is a wireless frontend solution for mPaaS HTML5 containers. Kylin features efficient runtime, consistent development experience, rich R&D support, and comprehensive UI components. Kylin helps you resolve various issues in hybrid mobile development, such as frontend packaging, browser compatibility, and API mocking.

Limits

  • Only Quick BI Pro and Quick BI Enterprise Standard allow you to add self-managed Kylin data sources to group workspaces.

Procedure

  1. Add a data source, as shown in the following figure.
    Add a data source
  2. In the Add Kylin Database dialog box, configure the following 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 appears in the list of data sources.

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

      Database Address The public IP address of the server on which the Kylin database is deployed.
      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 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 ECS instance on which the database is deployed.
      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 If the Kylin database is deployed on an ECS instance and you use a VPC to connect Quick BI to the Kylin database, select ECS Data Source (VPC) and configure the following parameters:
      • AccessKey ID: the AccessKey ID that you used to purchase the ECS 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 ECS instance.

        For more information, see Obtain an AccessKey pair.

      • Instance ID: the ID of the ECS instance.
      • Region: the region in which the ECS instance is deployed.
    To use an SSH tunnel to connect to a self-managed data source, select ssh and configure the following parameters.
    Parameter Description
    ssh If you select ssh, configure the following parameters:
    You can deploy a jump server and connect to the database over an SSH tunnel. To obtain the jump server information, contact O&M personnel or system administrators.
    • SSH Host: the IP address of the jump server.
    • SSH Username: the username that is used to log on to the jump server.
    • SSH Password: the password that is used to log on to the jump server.
    • SSH Port Number: the port number that is used to connect to the jump server. Default value: 22.
    For more information, see Connect to a Linux instance by using a password.
    Note Only Quick BI Enterprise Standard allows you to connect to self-managed data sources in group workspaces over SSH tunnels.
  3. Click Test Connection to verify that the data source can be connected.
    Test network connectivity 312.1
  4. 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 self-managed Kylin 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.