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:

    • Display Name: Type in the name of the database to appear in the sidebar and in reports.

    • Server Installed On (optional): Specify the server that this database is installed on. When set, if you are monitoring the server that hosts this database, the status of the database will appear under that server.

    • Connection Type: Select the means by which to connect to the database. The following options are available, each with their own connection settings:

      • SQL Server: Connect directly to a Microsoft SQL Server database.

        This connection type has the following connection settings:

        • Server / Data Source: Set the server or data source for the database connection.

        • Authentication Type (optional): Set the authentication type for the database connection. The following options are avaiable:

          • None: Do not use authentication.

          • Basic: Use basic authentication consisting of a Username and Password.

          • Windows Authentication: Use Windows authentication consisting of a Username, Password and Domain.

      • OLE DB: Connect to the database via an Object Linking & Embedding Database driver.

        To use the OLE DB connection type, the OLE DB driver must be installed on the Analytics Hub server.

        This connection type has the following connection settings:

        • Provider: Set the OLE DB provider to use for the database connection.

        • Server / Data Source: Set the server or data source for the database connection.

        • Authentication Type (optional): Set the authentication type for the database connection. The following options are avaiable:

          • None: Do not use authentication.

          • Basic: Use basic authentication consisting of a Username and Password.

          • Windows Authentication: Use Windows authentication consisting of a Username, Password and Domain.

      • ODBC: Connect to the database via Open Database Connectivity driver.

        To use ODBC, you must use the 64 bit version of the driver and database; the 32 bit version is not supported. You must also use ODBC Data Sources (64 bit) to set up an appropriate DSN (Data Source Name).

        This connection type has the following connection settings:

        • DSN: Set the DSN (Data Source Name) for the database connection.

        • Authentication Type (optional): Set the authentication type for the database connection. The following options are avaiable:

          • None: Do not use authentication.

          • Basic: Use basic authentication consisting of a Username and Password.

          • Windows Authentication: Use Windows authentication consisting of a Username, Password and Domain.

      If you want to use a custom connection string instead, click Custom Connection String and type a custom Connection String.

  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: