Search Anywhere Configuration Settings
This section is dedicated to configuring various Search Anywhere configurations, which can later be used in search queries. More details about this can be found here.
To create a configuration, navigate to Menu - Settings - Management - Configurations list - Create Configuration. To start editing a configuration, navigate to Menu - Settings - Management - Configuration List, then click on the desired configuration name in the table. Learn more about creating and editing each connection type:
Hadoop, Clickhouse, and DB connections have an advanced mode.
You can also edit permissions and tags for a configuration. To do this, click on the three dots next to the configuration name and select the corresponding items in the dropdown menu.
To view a summary of the connection information, which includes the JDBC driver, class name, and user for Hadoop, Clickhouse, and DB connections, as well as the authorization type and trust store path for Elastic and OpenSearch connections, click the "down arrow" next to the configuration name.
Configuring the JDBC Drivers Path
By default, all JDBC drivers are located in the /app/opensearch/config/sme/jdbc_drivers/ directory. If OpenSearch is not installed in the default /app/opensearch/ directory, you need to manually specify the path to the drivers. To do this, a corresponding cluster-level setting must be added — this ensures the drivers are correctly read and displayed in the user interface.
To add this setting, open the Developer Console (Main Menu - System Settings - Developer Console) and run the following command:
PUT _cluster/settings
{
"persistent": {
"sme": {
"core": {
"db": {
"jdbc": {
"drivers_path": "/app/opensearch/config/sme/jdbc_drivers/"
}
}
}
}
}
}