Quick BI:Alibaba Cloud Lindorm Data Source

Prerequisites

You have created an Alibaba Cloud database instance.

Limits

• Creating Alibaba Lindorm data sources is supported only in the Professional and Pro Edition group spaces.

• If the Lindorm database type is Wide table engine or Multi-model SQL, multi-table joins and merges are not supported during dataset building.

Procedure

1. Add to the whitelist.

   Before connecting to the Alibaba Lindorm database via the public network, add the IP address of Quick BI to the Lindorm database whitelist. For more information, see setting the whitelist.

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

3. Access the data source creation interface via the data source creation entry.

4. On the Alibaba Cloud Database tab, select Lindorm data source.

   

5. In the Configure Connection dialog box, configure the connection according to your business needs.

   Name	Description
   Display Name	The display name of the data source config list. The name cannot contain special characters or start or end with spaces.
   Database type	Select the type of database. The options are Multi-model SQL, Wide table engine, and Time series engine. Multi-model SQL: If the database contains multiple data models such as column-oriented tables and wide tables, select Multi-model SQL. Wide table engine: If the database belongs to the Lindorm wide table engine (including cases using search, column-oriented, vector, and other indexes), select Wide table engine. Time series engine: If the database belongs to the Lindorm time series engine (LindormTSDB), select Time series engine.
   Database address	The external network address where the Alibaba Lindorm database is deployed. Log on to the RDS management console, click to view connection details in the basic information area, and obtain the external network address. For example: Id-xxxxxxxxxxxxxxxxxx.lindorm.rds.aliyuncs.com.
   Port	The port number corresponding to the database.
   Database	The name of the database to be connected.
   Username And Password	The username and password that are used to access the database. Ensure that the username has create, insert, update, and delete permissions on the tables in the database.
   VPC data source	If you use an Alibaba Cloud VPC network, select VPC data source and configure the following parameters: Purchaser AccessKey ID and Purchaser AccessKey secret: The AccessKey ID and AccessKey secret of an account that has access permissions for the target Lindorm database. Ensure that the account has Read permission on the target instance. If it also has Write permission, the system automatically adds the IP address to the whitelist. Otherwise, you must manually add it. For instructions on creating custom policies, see creating custom policies. You can log on to the RAM console to obtain the AccessKey ID and AccessKey secret. Instance ID and Region: The instance ID and region of the Lindorm database. You can obtain this information from the RDS management console. Note If you select VPC data source, enter the internal network address and internal network port for the database address and port.
   Enable full table scan	When the database type is Wide table engine, you can set whether to enable full table scan. It is recommended to enable full table scan. Because Lindorm wide table engine is distributed storage, if full table scan is not enabled, an error will occur when filtering non-primary key columns.

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

   

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

What to Do next

After the data source is created, you can proceed to create datasets and analyze data.

• To add data tables from the Alibaba Lindorm database or use custom SQL in Quick BI, refer to creating and managing datasets.

• For adding visualization charts and data analysis, consult creating a dashboard and an overview of visualization charts.

• To delve deeper into data analysis, see drill settings and display.