Data Governance User Guide > Automate Data Quality Rules > Automating Data Quality Rules Process
  

Automating Data Quality Rules Process

The following image shows the steps required to set up Axon with Enterprise Data Catalog and Informatica Data Quality so that Axon runs the rules automatically on data store fields:
The image shows the steps required to set up Axon with Enterprise Data Catalog and Informatica Data Quality.
The following steps describe how to automate data quality rules:
  1. 1. Set up Axon, Enterprise Data Catalog, and Informatica Data Quality.
  2. 2. Link objects as required between Axon and Enterprise Data Catalog. Link objects as required between Axon and Informatica Data Quality.
  3. 3. Onboard objects from Enterprise Data Catalog to Axon. Optionally, manually create links between Enterprise Data Catalog fields and Axon attributes.
  4. 4. Run rules on the objects onboarded from Enterprise Data Catalog in Informatica Data Quality.
Note: If the administrator has enabled the Data Marketplace option in the Admin Panel, make sure that you are in Data Governance view to set up rule automation and perform tasks in Axon.
Data Governance dropdown on the Axon toolbar

Step 1. Set Up Axon, Enterprise Data Catalog, and Informatica Data Quality

The first step to automate rules is to set up Axon, Enterprise Data Catalog, and Informatica Data Quality by creating the required objects.
Perform the following steps to create the objects:
  1. 1. In Enterprise Data Catalog, create a resource to scan data sources, and configure the resource to discover data profiles and data domains.
  2. 2. In Axon, create a System object that maps to the resource you created in Enterprise Data Catalog. Link the System object to at least one Enterprise Data Catalog resource to enable onboarding objects from Enterprise Data Catalog to Axon.
  3. 3. In Axon, create a Glossary object.
  4. 4. Create an Axon resource type in Enterprise Data Catalog. Use the Axon resource type to scan the Axon glossaries.
  5. 5. In Axon, create a standard data quality rule for the glossary objects. The standard data quality rule is a textual definition of the rule that you want to run on the fields.

Step 2. Link Objects Between Axon, Enterprise Data Catalog, and Informatica Data Quality

The second step is to link the objects in Axon and Enterprise Data Catalog to onboard the fields, and link the objects in Axon and Informatica Data Quality to connect the rules.
Perform the following steps to link the objects:
  1. 1. In Axon, associate the Glossary object with the Enterprise Data Catalog data domains. In Enterprise Data Catalog, you can associate data domains and fields with the Axon glossary.
  2. 2. In Axon, link the standard data quality rule to an existing rule in Informatica Data Quality. This step associates a textual rule definition in Axon with a logical rule in Informatica Data Quality. Alternatively, Informatica CLAIRE® can recommend a rule and automatically create the rule in Informatica Data Quality.
    3. Note: To recommend and create a rule automatically, the Axon Administrator must enable this option in the Admin Panel. For more information, see the Axon Data Governance 7.1 Administrator Guide.
  3. 3. In Axon, choose the option to automatically create local data quality rules for the standard data quality rule. This step enables data quality rule automation.

Step 3. Onboard Objects from Enterprise Data Catalog to Axon

The third step is to display the objects from Enterprise Data Catalog in Axon. You can manually link the attributes in Axon with the fields in Enterprise Data Catalog. You can also choose to automatically onboard the objects from Enterprise Data Catalog to Axon. When you choose to onboard objects, the data sets and attributes are automatically created and onboarded to Axon.
Perform the following steps to onboard the objects:
  1. 1. In Axon, choose the option to automatically onboard the objects from Enterprise Data Catalog.
  2. 2. After the key elements are identified, the data sets and attributes are automatically created and onboarded to Axon. Axon is now ready to send the fields to Informatica Data Quality to run the rules.
  3. 3. In Axon, you can choose to accept or reject the Attribute objects created automatically.

Step 4. Run Informatica Data Quality Rules on Onboarded Objects

The fourth step is to run the rules automatically. Axon automatically runs Informatica Data Quality rules on Enterprise Data Catalog fields and displays the scores.
Axon performs the following steps to display the scores:
  1. 1. Axon creates a local data quality rule for the attributes that apply to each data set. In this step, Axon creates an instance of a rule for each field scanned by Enterprise Data Catalog. Axon then sends the rule mapping requests for the attributes to Informatica Data Quality.
  2. 2. Informatica Data Quality receives the mapping requests and runs the rule on the fields as per the schedule that you have defined.
  3. 3. Informatica Data Quality generates data quality scores for each field.
  4. 4. Axon retrieves the data quality scores for each table column and displays the scores for each local rule.