Remediate

Quality Console Overview

The Quality Console pages allow users to manage remediation reports by

  • Catalog Business Process

  • Catalog Category Value

  • Catalog Term

  • Mapping Status

From the Quality Console, users can see reports that:

  • are available

  • have tables that exist in the database

  • have been mapped

  • are not being remediated

View Data Downloaded from the Syniti Knowledge Platform

Once the service page runs, users can view data quality report data from the Syniti Knowledge Platform within Remediate. This task is useful to see whether or not the table exists in the Syniti Knowledge Platform.

To view data download from the Syniti Knowledge Platform:

  1. Click Quality Console in the Navigation pane.

  2. Click the Business Process, Categories or Terms icons on the Page toolbar to review data quality reports.

  3. Click the IMPLEMENTATION ID link to view the implementation associated with the report from within the Syniti Knowledge Platform.

  4. Click Vertical View.

  5. Click the Rule_Asset ID or the Enforcement_Asset ID link to view the rule or the enforcement associated within the report from within the Syniti Knowledge Platform.

Lock Data Quality Report Mapping

Lock the mapping once the remediation process has been built and tested. Locking a report mapping sets the status to Mapped. From here, use Promote to transport the remediation process from the Development environment to Production. Only data quality reports with a status of Mapped are used to initiate new requests for data remediation.

To lock a data quality report for mapping:

  1. Click Quality Console in the Navigation pane.

  2. Click the Mappings icon on the Page toolbar.

  3. Click the Reports icon for the Exists in Cloud mapping status.

  4. Locate the report and click the Map icon.

  5. Click the Lock Mapping icon on the Page toolbar.

Map Data Quality Report to an MDM Task

Remediate has functionality that enables the columns of a failed data table that is related to a Data Quality Report to be mapped to an MDM Task.

Mapping a data quality report to an MDM task has three parts:

  1. Map the data quality report to an MDM Category, Task and Table.

  2. Map data quality report fields to Task Table fields.

  3. Create and assign a stored procedure that creates the request.

Map Data Quality Report to an MDM Category, Task and Table

To map the data quality report to an MDM Category, Task and Table:

  1. Click Quality Console in the Navigation pane.

  2. Locate the data quality report and click the Map icon; the Report Mapping page displays.

  3. Click Edit.

  4. Select the CATEGORY ID, TASK and TABLE to which the failed data should be mapped.

  5. Click Save.

Map Data Quality Fields to Task Table Fields

When a table is selected in the previous steps, the fields from the failed data table are pulled into the Report Field Mapping page. These fields must then be mapped to the associated task table fields.

To map the data quality report fields to Task Table fields:

  1. From the Report Mapping page, click the Field Mapping icon.

  2. Click Edit for a report field.

  3. Select the target table field to which the report field is mapped from the TARGET TABLE FIELD list box.

  4. Click Save.

Create and Assign the Create Request Stored Procedure

Create the Request stored procedure and assign it to the data quality report.

Create the Create Request Stored Procedure

When the report is mapped to a target table and the record is locked for mapping (i.e., the Lock Mapping icon is clicked), a rule runs to check for the existence of the webRequest_Submit_RemediateJob_TargetIns stored procedure in the Content Application / Categories Application’s database.

This stored procedure contains the logic to read the mapping information and insert the data from the table created from the Syniti Knowledge Platform Quality module that contains the report data into the Table field on the Report Mapping page.

A Power User or application developer must configure the Submit event to include this new stored procedure. This procedure can be modified or duplicated by the MDM Category application developers to fit their data needs and requirements.

To create the webRequest_Submit_RemediateJob_TargetIns stored procedure in the Content Application / Categories Application’s database, execute the Create Request script.

Assign the Stored Procedure to a Data Quality Report

Once the stored procedure is created, assign it to a data quality report.

To assign the stored procedure to a data quality report:

  1. From the Report Mapping page, click the Vertical View icon.

  2. Click Edit.

  3. Select the stored procedure that is used to initiate a new request based on the failed data in the report from the Create Request Procedure list box.

  4. Click Save.

Create a Request in MDM

Once data for remediation has been identified and mapped to an MDM task, create a request for the data to be corrected.

To create a request in MDM:

  1. Locate the report in Quality Console.

  2. Click the Create Request icon for the report.