All Products
Search

This Product

    :Add a user-created Elasticsearch Data Source

    Document Center

    :Add a user-created Elasticsearch Data Source

    Last Updated:Apr 28, 2024

    This topic describes how to add a user-created 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

    • A user-created Elasticsearch database is created.

    • The username and password of the user-created Elasticsearch database are obtained.

    Limits

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

    Procedure

    1. 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 user-created data source Elasticsearch, add the Quick BI IP address to the whitelist of the user-created data source Elasticsearch.

    2. After you log on to the Quick BI console.

    3. Go to the Create Data Source page.

    4. Click Show More.

      image.png

    5. Select the Elasticsearch data source.

      image.png

    6. Select User-created Database Source.

      image.png

    7. 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 of the deployment Elasticsearch database, including the IP address or domain name.

      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.

      SSH

      You can deploy a jump server and access the database over an SSH tunnel. To obtain the jump server information, contact O&M personnel or system administrators. If you select SSH, you must 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 used to log on to the jump server.

      • SSH Port: the port of the jump server. Default value: 22.

    8. Click Test Connection to verify that the data source can be connected.

      image..png

    9. 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.