Quick BI:Add a User-created Kingbase Data Source

Limits

Supports version 7.1.2.

Procedure

1. Add the whitelist.

   Before connecting to the Alibaba Cloud Kingbase database over the Internet, you must add the IP address of Quick BI to the Kingbase whitelist.

2. Log on to the or the international Quick BI console.

3. Follow the steps in the figure below to add a data source.

   1. Navigate to the data source creation page via the data source creation entry.

   2. Click Show more.

   3. Select the Kingbase data source.

4. In the Add Kingbase Data Source dialog box, configure the settings as needed for your business scenario.

   Name	Description
   Display name	The display name in the data source configuration list. The name cannot contain special characters or start or end with spaces.
   Database address	The address of the deployed Kingbase database, including the IP address or domain name.
   Port	The port number of the database. Default value: 5432.
   Database	The name of the database to be connected.
   Username and Password	The username that is used to access the database. Ensure that the username has the create, insert, update, and delete permissions on tables in the database.
   Database version	Supports versions v7 and v8.
   VPC data source	If you use a VPC network, select VPC data source and configure the following parameters: AccessKey ID and AccessKey Secret: The AccessKey ID and AccessKey Secret that have access privileges to the destination Kingbase cluster. Ensure that the account has Read permissions on the destination instance. If the account has Write permissions, the system automatically adds the whitelist. Otherwise, you must manually add it. For more information, see Create a custom policy. ECS instance ID: Log on to the ECS console and obtain the instance ID on the Instances tab. For more information, see View instance information. Region of the ECS instance: Log on to the ECS console and obtain the region of the instance in the upper-left corner. For more information, see View instance information.
   SSH	Specifies whether to access the data source over an SSH tunnel based on your business requirements. If you select SSH, configure the following parameters: SSH Host: The hostname or IP address. SSH Username: The SSH username that is used to access the database. SSH Password: The password of the SSH username. SSH Port: The port number of the database. Default value: 22.

5. Click Connection Test to verify the data source connectivity.

6. Once the test is successful, click OK to finalize the data source addition.