Database Configuration

You can add any databases to Analytics that you want to monitor. You can also set alarms to trigger if the probe to a database fails, or a database query fails or responds too slowly. In addition, you can add an alarm that triggers if the query result is an unexpected value.

Once you have added a database, you can also change settings for specific databases.

Alarms specific to a database's queries are found in the database's Queries tab, not its Alarms tab.

Default Database Settings

You can change the default Collection Interval and Alarms for all databases.

Specific Database Settings

Enable or Disable Monitoring

You can enable or disable monitoring of a database with the following procedure. When monitoring is disabled, Analytics will stop collecting information and stop checking alarms for this database. Previously collected information can still be viewed in Analytics when monitoring is disabled.

To enable or disable monitoring a database:

  1. In Configuration, click Databases.

  2. Click the name of the database for which you want to enable or disable monitoring.

  3. Click at the top right.

Remove a Database

When you remove a database, it no longer appears in Analytics and its collected information is no longer accessible.

To remove a database:

  1. In Configuration, click Databases.

  2. Click the name of the database you want to remove.

  3. Click at the top right.

  4. Click OK.

Add a Database to Monitor in Analytics

You need to add databases as these are not added dynamically to Analytics. If the database requires authentication, you need to enter a username and password that grants access to the database. Basic and Windows Authentication is supported. Custom connection strings are also supported if the database requires more complex connection settings.

Once you have added databases, you can enable or disable a database, or remove it completely.

To monitor a database, Analytics requires a user with read-only access.

To add a database to monitor in Analytics:

  1. Open Analytics, and then click Configuration.

  2. At the bottom of the sidebar, click Add, and then click Database.

  3. On the Setup tab, enter the following information:

  4. If you want to perform a database connection test, Click Test Connection.

    The message displays whether the test is successful or not. Click OK.

  5. Click Save.

    A message indicates that the database is being added. When the process is complete, the database name appears in the sidebar under Databases and you can set more configuration options.

Alarms on a Specific Database

On the Alarms tab of a database:

Queries on a Specific Database

On the Queries tab of a database:

© 2020 VertiGIS North America Ltd. All Rights Reserved.

Documentation Version 1.7