1. Support
  2. User Guides
  3. Database Configuration – Operator Side

Database Configuration – Operator Side

The Goverlan Reach Operator Console uses a database back-end to store inventory data as well as operator configuration objects.

By default, the configuration uses a local file-based SQL database stored on the operator’s machine. However, for large environment, you can configure a MS SQL database back end to improve performance.

If multiple operators are using Goverlan, it is recommended to configure all operator consoles to point to the same database. This enables Team Collaboration as well as the sharing of inventory data.

NOTE:

The Goverlan Reach Operator Console and Goverlan Reach Server use two separate SQL databases that have their own functions. It is not recommended to configure both operator consoles and reach servers to point to the same database.

Database Settings

Open the General Settings of the application and select the Database Settings category.

  • Database Type – Specify the database type. SQLITE or SQL Server.
  • Database Name – The name of the database.
  • Folder Path (for SQLITE) – The path to the SQLITE database file. For multiple operators, use a network share location.
  • SQL Server Name Instance (for SQL Server)– The name and SQL Instance for the server.
  • Authentication (for SQL Server) – Choose the authentication type. Windows or SQL authentication.
NOTE:

The Goverlan database configuration (as well as other settings) can be centrally configured and applied to all operators.  See Centralizing the Configuration & Auditing of Goverlan

Inventory Data

Goverlan implements a technology call SureData. This technology uniquely combines a real-time information query engine with a database back-end. When system information is queried, a real-time query is executed and upon success, the information is registered as inventory data. If the system becomes unavailable, the information is queried from inventory instead of real-time.

Inventory data is stored in the database back-end. The Database Settings window allows you to turn OFF this feature if you do not wish to have inventory data registered.

You can also open the Advanced Settings to:

  • View the amount of database storage used by different inventory data objects
  • Enable or disable inventory registration of specific objects
  • Configure how often inventory updates should be registered in the database
  • Reset specific inventory data

 

Was this article helpful?

Related Articles