How to set up a Bold BI data source with AWS OpenSearch
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.