For Data quality studio, an integration is available to Data entry workflow.

Start data entry workflow from Quality assessment exceptions log

On a data quality assessment run, a record can fail the data quality assessment. As a data quality officer, you can review the records with an error or warning in the Quality assessment exceptions log.

With the Data entry workflow integration, you can start a data entry workflow to edit a record that failed a data quality assessment.

Note: You can only use the Data entry workflow integration Data entry workflow is installed on the D365 F&SCM the environment. The installed Data entry workflow version must be at least 10.0.40.15.

Setup

You can set up a Data entry workflow integration on a data quality assessment project.

To do so, define the:

  • Data entry workflow template to be applied. Make sure, the data entry workflow template contains the fields that are checked in the data quality assessment.
  • Applicable data entry workflow document record.
    Note: Based on the selected workflow document record, the related parent data source is filled in automatically.
  • Applicable dynamic query. The query must contain the fields that are assessed by the data quality assessment project. Make sure, the query contains the assessed fields that are part of and that are not part of the parent data source.
    Note: Set up the dynamic query to return unique records. To do so, in the dynamic query, the first defined table must be the main table. Use data entities for the next table records. For each of the data entity table records, define the applicable parent.

Process

As a data quality officer, you can review and process data quality assessment results in the Quality assessment exceptions log.

If a Data entry workflow integration is set up for the quality assessment project, for each record with errors or warnings, you can start a data entry workflow to make the desired changes to the record.
Note: You can start only one data entry workflow for each record with errors or warnings. A record can fail several validations or duplicate checks. For each failed validation or duplicate check, a separate entry is created in the Quality assessment exceptions log. So, if you have started a data entry workflow for an entry, you cannot start another data entry workflow for another entry of the same record

Provide feedback