Data Assurance

Data Assurance is a Control-M add-on that enables you to crosscheck your workflow data with one or more databases to verify its accuracy. Monitor Templates enable you to monitor your data quality through a number of metrics, as described in Creating a Monitor Template. If Data Assurance discovers a discrepancy between your data and the crosschecked database, you can configure it to automatically rerun one or more jobs and verify their data on subsequent runs.

Getting Started with Data Assurance

This procedure describes how to get started with Data Assurance.

Begin

  1. Add a Data Source: Connect to the database that is used to crosscheck the accuracy of your workflow data, as described in Adding a Data Source.

  2. Create a Monitor Template: Monitor your data quality through a number of metrics, as described in Creating a Monitor Template.

  3. Creating a Data Assurance Job: Creates a Data Assurance job and assigns it a Monitor Template, as described in Creating a Data Assurance Job.

     

Adding a Data Source

This procedure describes how to add a data source, which Data Assurance crosschecks with the data in your workflows.

Begin

  1. From the icon, select Configuration.

    The Configuration domain opens.

  2. From the drop-down list, select Centralized Connection Profiles.

    The Centralized Connection Profiles tab appears.

  3. Click the Add Connection Profile drop-down list and select Data Assurance Executor.

    The Data Assurance Executor dialog box appears.

  4.  

Creating a Monitor Template

This procedure describes how to create a Monitor Template, which is a set of data quality metrics that describe your workflow data quality compared to a defined Data Source.

Begin

  1. From the icon, select Data Assurance.

    The Data Assurance domain opens.

  2. Click the Monitor tab.

    The Monitor tab appears.

  3. Click New Monitor Template.

    The Select Dataset dialog box appears.

  4. Click > to expand the Data Source file and select a database (dataset).

    A list of databases appear.

  5. Click Select Dataset.

    The New Monitor Template appears.

  6. Do the following:

    1. In the Name field, type a logical name.

    2. Click to save the Monitor Template.

    3. Click New Metric.

      The Scope dialog box appears.

    4. Select and then define the required scope, as described in Monitor Template Scope Attributes.

    5. Click Disable to turn off the metrics.

    6. Click Add Metric to add the Monitor Template.

      The new Monitor Template appears.

  7. Click Save Monitor Template.

    The new Monitor Template is saved.

Monitor Template Scope Attributes

The following table describes the Monitor Template scope attributes.

Scope

Description

Field

Defines the following Dataset field metrics:

  • Field:

  • Metric:

  • Operator:

  • Threshold:

Entire Dataset

Defines the following metrics

Custom Dataset

 

Creating a Data Assurance Job

This procedure describes how to create a Data Assurance job.

Begin

  1. From the icon, select Data Assurance.

    The Data Assurance domain opens.

  2. Click the Pipelines tab.

    The Pipelines tab appears.

  3. Double-click a pipeline.