How to add a Alibaba Cloud Elasticsearch data source and what are the prerequisites -

This topic describes how to add a Alibaba Cloud Elasticsearch data source.

Note

Due to the syntax of the data source itself, Elasticsearch the LIMIT of the data source does not support OFFSET, paged query cannot be used properly. We recommend that you cancel pagination when you use the Elasticsearch data source to create a chart.

Prerequisites

The Alibaba Cloud Elasticsearch database is created.
You have obtained the username and password of the Alibaba Cloud Elasticsearch database.

Limits

Versions 7.8.1 and later are supported, and X-Pack plug-ins (Platinum Edition) are required.

Procedure

Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.
Before connecting to the Alibaba Cloud Elasticsearch, add the Quick BI IP address to the Alibaba Cloud Elasticsearch whitelist.
After you log on to the Quick BI console.
Go to the Create Data Source page.
Click Show More.
Select the Elasticsearch data source.
Select Alibaba Cloud for Database Source.

In the Configure Connection dialog box, configure the following settings based on your business requirements.

Feature	Description
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 and Port Number	The address and port of the deployment Elasticsearch database. Log on to the ApsaraDB Elasticsearch console and obtain the database address in the Network Information section.
Username and Password	The username and password that are used to access the database. Make sure that the username has the create, insert, update, and delete permissions on the tables in the database.
Time zone	The time zone in which the Elasticsearch database is deployed.

Click Test Connection to verify that the data source can be connected.
After the database passes the connectivity test, click OK.

What to do next

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

For more information about how to add a data table in the Elasticsearch data source or a user-created SQL statement to the Quick BI, see Create and manage datasets.
You can add charts for data analysis. For more information, see Create a dashboard and Overview of visualization charts.
Drill down the data for in-depth data analysis. For more information, see the Configure the drilling feature section of the "Drilling" topic.