:Add an Elasticsearch Data Source

Prerequisites

• An Alibaba Cloud Elasticsearch database has been created.

• You have obtained the username and password for the Alibaba Cloud Elasticsearch database.

Limits

• Supports version 7.8.1 and later, and requires the X-Pack plug-in (Platinum Edition).

• The Elasticsearch data source's syntax limitations mean that the LIMIT clause does not support OFFSET, preventing normal use of paged queries. It is advisable to disable paging when creating charts with the Elasticsearch data source.

• The Elasticsearch data source does not support table joins due to its syntax limitations.

Procedure

1. Add the whitelist.

   Before connecting to Alibaba Cloud Elasticsearch, you need to add the IP address of Quick BI to the whitelist of Alibaba Cloud Elasticsearch.

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

3. Navigate to the data source creation interface via the data source creation entry.

4. Click to show more.

   

5. Select the Elasticsearch data source.

   

6. Choose Alibaba Cloud as the database source.

   

7. In the configure connection dialog box, complete the necessary configurations based on your specific business scenario.

   Name	Description
   Display name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
   Database address and port	The address and port where the Elasticsearch database is deployed. Log on to the ApsaraDB Elasticsearch console to obtain the database address in the network information area.
   Username and password	The username and password that are used to access the database. Ensure that the username has create, insert, update, or delete permissions on tables in the database.
   Time zone	The time zone where the Elasticsearch database is deployed.

8. Click connection test to verify the data source's connectivity.

   

9. Once the test is successful, click OK.