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.
You can change the default Collection Interval and Alarms for all databases.
Collection Interval: Change how often the databases are probed and alarms are triggered.
Alarms: You can also set default alarms to trigger when a database fails to respond, or when a query fails or is too slow, or when a query result is an unexpected value.
Click on any alarm card to edit the default setting of an alarm. For more information, see Database Unavailable Alarm, Query Failure Alarm, Query Result Alarm and Query Response Alarm.
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:
In Configuration, click Databases.
Click the name of the database for which you want to enable or disable monitoring.
Click at the top right.
When you remove a database, it no longer appears in Analytics and its collected information is no longer accessible.
To remove a database:
In Configuration, click Databases.
Click the name of the database you want to remove.
Click at the top right.
Click OK.
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:
Open Analytics, and then click Configuration.
At the bottom of the sidebar, click Add, and then click Database.
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.
If you want to perform a database connection test, Click Test Connection.
The message displays whether the test is successful or not. Click OK.
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.
On the Alarms tab of a database:
Alarms: You can set an alarm to trigger when a specific database fails to respond.
Click on any alarm card to edit the default setting of an alarm. For more information, see Database Unavailable Alarm.
Alarms specific to a database's queries are found in the database's Queries tab, not its Alarms tab.
On the Queries tab of a database:
Query: You can add, edit, test and delete SQL (Structured Query Language) queries for a database. You can also set alarms specific to queries.
Analytics only supports SELECT queries that return a single numeric value.
To add a query:
In Configuration | Databases | [Database Name] | Queries, click + New Query.
A window appears in which you can enter the details of the new query.
In the Name box, type a name for the query.
In the Query box, type the SQL for the query.
To test the query, click Test Query.
A message displays the result of the query. Click OK.
Click Save.
To edit a query:
In Configuration | Databases | [Database Name] | Queries, beside the query, click .
A window appears in which you can edit the details of the query.
Edit the details as you want.
To test the query, click Test Query.
A message displays the result of the query. Click OK.
Click Save.
To test a query:
In Configuration | Databases | [Database Name] | Queries, beside the query, click .
A message displays the result of the query. Click OK.
To delete a query:
In Configuration | Databases | [Database Name] | Queries, beside the query, click .
A confirmation window appears.
Click Yes.
To set an alarm for a specific query:
In Configuration | Databases | [Database Name] | Queries, beside the query, either click or
.
The query expands, displaying its alarms.
Click on any alarm card to edit the default setting of an alarm. For more information, see Query Failure Alarm, Query Result Alarm and Query Response Alarm.
Click Save.