Quick BI:Alibaba Cloud Elasticsearch data source

Prerequisites

• You have created an Alibaba Cloud Elasticsearch instance.

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

Limitations

• Only Elasticsearch 7.8.1 or later with the X-Pack plug-in (Platinum Edition) is supported.

• The Elasticsearch query language's LIMIT clause does not support OFFSET, which prevents pagination from working correctly. Disable pagination when you create visualizations from an Elasticsearch data source.

• You cannot perform multi-table joins on Elasticsearch data sources.

Procedure

1. Add IP addresses to the whitelist.

   To connect to Alibaba Cloud Elasticsearch, add the IP addresses of Quick BI to the whitelist of your Alibaba Cloud Elasticsearch instance.

2. Log on to the Quick BI console.

3. Navigate to the page for creating a data source. For more information, see Create a data source.

4. On the Alibaba Cloud Databases tab, select Elasticsearch.

   

5. In the Configure Connection dialog box, configure the following parameters.

   Parameter	Description
   Display name	The display name of the data source in the data source list. Enter a valid name without special characters or leading or trailing spaces.
   Database address and port	The address and port of your Elasticsearch instance. Find the database address in the network information section of the Alibaba Cloud Elasticsearch console.
   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.
   Time zone	The time zone where the Elasticsearch instance is deployed.

6. Click Test Connection to test the connection to the data source.

   

7. After a successful connection test, click OK.