Wyn Enterprise User Guide

Wyn Enterprise: Connect to ElasticSearchDSL

To create an ElasticSearchDSL data source in Wyn Enterprise, follow these steps.

  1. On the Resource Portal, navigate to Create (+) > Create Data Source.

  2. Select ElasticSearchDSL in the data source list on the left or in the icon view on the right.

  3. Fill in the database configuration information for the selected data source.

Field Description
Name* The name for the data source that you want to specify.
Hostname* A host name or address.
Port* A port number, the default is 9200.
UserName A user name to connect to the ElasticSearchDSL database.
Password A password of the ElasticSearchDSL user.
Use Configuration String (Advanced) Use this option to connect to the data provider through a connection string. The format of the connection string is: HostName=myHostname;Port=myPort;username=myUsername;Password=myPassword

* Required fields

  1. Click Test Connection to verify the data source connection. If the data source is available, and the credentials filled are correct, you receive a notification on successful connection.

  2. Click Create after the successful connection.

    You can view the added data source in the Categories tab of the Resource Portal.

Salient Points

  1. No schema is generated on previewing the data source.
  2. The dataset cannot be designed by dragging and dropping the tables from the ElasticSearchDSL data source.
  3. The dataset designer only supports the creation of custom SQL tables with native DSL.
    Custom SQL tables with native DSL This is the only way to read the data from the ElasticSearchDSL data source. For more information about DSL queries, please visit this article.