All Products
Search
Document Center

Quick BI:Add a User-Created Kylin Data Source

Last Updated:Jan 25, 2024

Quick BI can connect to the Kylin database, via either a public network or an Alibaba Cloud VPC. This topic describes how to add a user-created Kylin data source.

Prerequisites

  • Make sure that your network meets the following requirements:

    • If you Quick BI connect to the Kylin database over the Internet, add the Quick BI IP address to the whitelist of the database. For more information, see Add security group rules.

    • If you want to connect Quick BI to your Kylin database over an internal network, make sure that one of the following methods is used to ensure the connectivity between Quick BI and the user-created 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 access the data source.

      • You can deploy a jump server and access the database over an SSH tunnel.

  • A user-created Kylin database is created. The username and password that are used to access the Kylin database are obtained.

Background

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. For more information, see Kylin.

Procedure

  1. Log on to the Quick BI console.

  2. Perform the steps that are shown in the following figure to add a user-created Kylin data source.

    1. Go to the Create Data Source page.

    2. Click Show More.

      image

    3. Select the Kylin data source.

      image

  3. In the Add Kylin Data Source dialog box, configure the parameters.

    Component

    Description

    Display Name

    The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.

    Database Address

    The address where the Kylin database is deployed, including the IP address or URL.

    Port

    The port that is used to deploy the Kylin database.

    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. Make sure that the username has the create, insert, update, and delete permissions on the tables in the database.

    Password

    The password that is used to log on to the database.

    VPC data source

    If the Kylin database is deployed on a ECS and the network type is Alibaba Cloud VPC, select VPC Data Source and configure the following parameters:

    • AccessKey ID: the AccessKey ID that is used to purchase the instance.

      For more information, see Obtain an AccessKey pair.

    • AccessKey: the AccessKey secret that is used to purchase the 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.

    SSH

    If you select SSH, configure the following parameters:

    You can deploy a jump server and access 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 access user-created data sources via SSH tunnels.

  4. Click Test Connection to verify that the data source can be connected.

    image

  5. Click OK.

What to do next

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