Add an Alibaba Cloud Lindorm data source to connect Quick BI to your Lindorm instance. After you establish the connection, you can analyze and visualize your data in Quick BI. This topic describes how to add an Alibaba Cloud Lindorm data source using a public connection.
Prerequisites
You have created an Alibaba Cloud Lindorm instance.
Limitations
Only workspaces in Quick BI Professional and Advanced support Lindorm data sources.
When the database type is wide column engine or multi-model SQL, Quick BI does not support joining or merging multiple tables during data modeling.
Procedure
Add IP addresses to the allowlist.
To connect to your Alibaba Cloud Lindorm instance over the internet, you must add the IP addresses of Quick BI to the allowlist of your Lindorm instance. For more information, see Set an allowlist.
Log on to the Quick BI console.
Navigate to the data source creation page as described in Create a data source.
On the Alibaba Cloud Databases tab, select Lindorm.
In the Configure Connection dialog box, configure the following parameters.
Parameter
Description
Display name
The name of the data source that is displayed in the data source list.
The name cannot contain special characters or leading or trailing spaces.
Database type
Select a database type: Multi-model SQL, Wide-column Engine, or Time Series Engine.
multi-model SQL: Select this option if your database uses multiple data models, such as column-store tables and wide column tables.
wide-column engine: Select this option if your database uses the Lindorm wide column engine, including scenarios with search, columnar, or vector indexes.
time series engine: Select this option if your database uses the Lindorm time series engine (TSDB).
Database address
The public endpoint of your Lindorm instance.
Log on to the Lindorm console, and in the Basic Information section, click View Connection Details to obtain the public endpoint. For example, Id-xxxxxxxxxxxxxxxxxx.lindorm.rds.aliyuncs.com.
Port
The port number of the database.
Database
The name of the database that you want to connect to.
Username and password
The username and password for the database.
Ensure that the user has CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
VPC data source
If you use an Alibaba Cloud VPC, select VPC data source and configure the following parameters:
AccessKey ID and AccessKey Secret: The AccessKey pair with permissions to access the target Lindorm database.
Ensure that the account has Read permissions on the target instance. If the account also has Write permissions, the system automatically adds the IP addresses of Quick BI to the allowlist. Otherwise, you must add them manually. For information about how to create custom policies, see Create a custom policy.
You can obtain your AccessKey pair from the RAM console.
Instance ID and region: The instance ID and region of the Lindorm instance. You can obtain this information from the Lindorm console.
NoteIf you select VPC data source, you must enter the internal address and port in the Database Address and Port fields.
Enable full table scan
When Database type is wide-column engine, you can specify whether to enable a full table scan.
We recommend that you enable this option. The Lindorm wide column engine uses distributed storage. If you do not enable a full table scan, queries that filter on non-primary key columns will fail.
Click Test Connection to test the data source connection.
After a successful connection test, click OK to add the data source.
Next steps
After you create the data source, you can create a dataset and analyze your data.
To add data tables or custom SQL queries from your Lindorm database to Quick BI, see Create a dataset.
To add charts and analyze data, see Create a dashboard and Overview of charts.
To drill down into your data, see Step 3: Configure and display drill-down data.