Table of Contents

Manually connecting a DMA to an indexing database

If you choose self-hosted storage instead of the recommended Storage as a Service (STaaS) setup, you can connect a DataMiner Agent to an existing OpenSearch or Elasticsearch cluster.

If you are using a dedicated clustered storage setup, from 10.3.0/10.3.3 onwards, you should do so in DataMiner Cube, as detailed under Configuring the general database settings in Cube.

If you are using an older DataMiner version or a setup with storage per DMA, follow the steps below.

Important

Elasticsearch is only supported up to version 6.8, which is no longer supported by Elastic. As a consequence, if you want to use self-hosted storage instead of the recommended Storage as a Service, we recommend using OpenSearch instead.

Caution

Make sure the DataMiner Agent has an available connection to each node of the OpenSearch or Elasticsearch cluster. You can for example verify this for Elasticsearch by entering http://elasticnodeip:9200/ in your browser's address bar to access the general server information.

Admin consent

Note

This procedure is only used to connect a DMA to a single OpenSearch/Elasticsearch cluster. For information on how to configure multiple OpenSearch or Elasticsearch clusters, see Configuring multiple OpenSearch clusters or Configuring multiple Elasticsearch clusters, respectively.

  1. Stop the DataMiner Agent. See Starting or stopping DataMiner Agents in your DataMiner System.

  2. In the C:\Skyline DataMiner directory, find the DB.xml file and copy this to your local machine as a backup.

  3. Open the original DB.xml file.

  4. Locate the active DataBase tag for the indexing database and specify the hosts, username, and password.

    Example:

    <DataBase active="true" search="true" type="Elasticsearch">
       <DBServer>Node IP1,Node IP1,..,Node IPx</DBServer>
       <UID>elastic</UID>
       <PWD></PWD>
    </DataBase>
    
  5. Save the file and restart the DataMiner Agent.

  6. When the DMA is online again, confirm that there are no errors related to the database configuration.

Note

An indexing database is never used on its own by DataMiner. It is always combined with a Cassandra database, either with a Cassandra cluster per DMA, or a Cassandra cluster per DMS. See Supported system data storage architectures.