Articles in this section
Category / Section

How to set up a Bold BI data source with AWS OpenSearch

Published:

When setting up a Bold BI data source with AWS OpenSearch, there are several prerequisites and steps to follow. This article will guide you through the process.

Prerequisites

Before you begin, ensure that you are using Amazon ElasticSearch 7.10 or above, as Open Distro Elastic Search is supported from this version onwards.

Enabling Settings

To connect Amazon Elasticsearch service through Open Distro, you need to enable certain settings. This can be done by passing the following API:

PUT _opendistro/_sql/settings
{
“persistent”:{
“opendistro.sql.cursor.enabled”: true
}
}

This will enable the SQL cursor, which is necessary for the connection to function correctly.

Connecting to Elastic Search Data Source

Once the prerequisites are met and the settings are enabled, you can proceed to connect to the Elastic Search data source. Detailed instructions for this process can be found in the Elastic Search Data Source Connection Document.

By following these steps, you should be able to successfully set up a Bold BI data source with AWS OpenSearch.

References

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
RM
Written by Reethika Moovendhan
Updated:
Comments (0)
Please  to leave a comment
Access denied
Access denied