Prepare to Enrich with JDBC

You can configure Moogsoft AIOps to add data to alerts from an external source in a process called enrichment. Before you start your enrichment project, verify that your enrichment strategy satisfies your business objectives as outlined in your Situation Design. This topic covers preparation as the the first step in the JDBC enrichment from Enrich Alerts Using a JDBC Data Source and defines the example scenario.

The following diagram illustrates the process to enrich alert data from an external database:

prepare_JDBC_Enrichment.png

Before you start to add data to alerts, make sure you identify a clear purpose for the data according to your business objectives as outlined in your Situation Design. For example:

  • Identify a business case to add data to an alert. Will you use data to drive alert clustering? Or will it provide information operators need to resolve Situations.

  • Research sources and source quality for your enrichment data. Do you have a configuration management database (CMDB) that can provide enrichment data? If so how current is the data in the CMDB? Is it well maintained with current data.

The ability to add data to your alerts is very powerful, however you should always choose to enrich with care. Retrieving information from an external source adds to data processing time and increases the size of alert data.

Step 1 example: Prepare to enrich

Imagine for this example that you have a monitoring solution sending event data to Moogsoft AIOps . After interviewing your operators and assessing their needs to resolve Situations, you have identified the following information is missing from your source monitoring data:

  • Physical location

  • Responsible support groups

Fortunately, you have a CMDB that is accessible using JDBC. You can use data from the CMDB to add information to the alert data and help operators resolve Situations.

Learn more

To continue with the JDBC Enrichment example, go to step 2: Analyze Your JDBC Source Data.

For more information information about gathering requirements, see Situation Design Workflow.