:Add an user-created Elasticsearch Data Source

Prerequisites

• A user-created Elasticsearch database is in place.

• The username and password for the user-created Elasticsearch database are available.

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, rendering paged queries inoperative. 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 Quick BI to the whitelist.

   Before connecting to the user-created Elasticsearch data source, add the IP address of Quick BI to its 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. Click to show more options.

   

5. Select the Elasticsearch data source type.

   

6. Choose 'user-created' as the database source.

   

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

   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 where the Elasticsearch database is deployed, including IP or domain name.
   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.
   SSH	You can set up a jump server and access the database through an SSH tunnel. To obtain the jump server information, contact O&M personnel or system administrators. If you select SSH, you need to configure the following parameters. SSH Host: Enter the IP address of the jump server. SSH Username: The username used to log on to the jump server. SSH Password: The password corresponding to the username used to log on to the jump server. SSH Port: The port of the jump server. Default value: 22.

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

   

9. Once the test is successful, click OK.