All Products
Search
Document Center

:Add an Elasticsearch Data Source

Last Updated:Jan 20, 2025

This topic explains how to add an Alibaba Cloud Elasticsearch data source.

Note

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.

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.

    image.png

  5. Select the Elasticsearch data source.

    image.png

  6. Choose Alibaba Cloud as the database source.

    image

  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.

    image

  9. Once the test is successful, click OK.

What to Do next

After adding a data source, proceed to create datasets and analyze data.