Search Anywhere Configuration Settings
This section describes how to configure Search Anywhere connections for use in search queries. For details, see Search Anywhere.
To create a configuration, go to Main Menu - Settings - Module Settings - Configurations List and click Create Configuration. To edit a configuration, open the same list and click its name. See the instructions for each connection type:
Hadoop, ClickHouse, and DB connections have an advanced mode.
To edit a configuration's permissions or tags, click the three-dot button next to its name and select the required menu item.
To view a connection summary, click the down arrow next to the configuration name. Hadoop, ClickHouse, and DB summaries show the JDBC driver, class name, and user; Elastic and OpenSearch summaries show the authorization type and trust store path.
Configuring the JDBC Drivers Path
JDBC driver files must be present on every node that runs queries against the corresponding source. The cluster setting specifies the path but does not copy files between nodes. A successful connection test on one node does not confirm that the driver is present on other nodes.
By default, JDBC drivers are stored in /app/opensearch/config/sme/jdbc_drivers/. If OpenSearch is installed outside the default /app/opensearch/ directory, specify the driver path manually by adding a cluster-level setting. This allows the drivers to be read and displayed in the user interface.
To add this setting, open the Dev Tools console (Main Menu - Settings - Dev Tools) and run the following command:
PUT _cluster/settings
{
"persistent": {
"sme": {
"core": {
"db": {
"jdbc": {
"drivers_path": "/app/opensearch/config/sme/jdbc_drivers/"
}
}
}
}
}
}