Understanding Data Set Validation

The purpose of Data Set validation (Validate/Check Integrity) is to check data validity based on rules defined on record fields (metadata), for example, whether a field value can be empty. Data can be validated from either the project file (Validate) or database (Check Integrity). The validation rules are always stored as metadata in database.

  • Validation

    Data will be validated come from project file.

  • Check Integrity

    Data will be validated come from database.

There are two types of validation:

  • Basic Validation

    Provides the default validations.

  • Custom Validation

    Extension application class (defined in the Data Set Definition) that extends the base validation class to define specific validation logic.

    See Defining Extension

Basic Validation

Basic validation is used to check that the data set instances in a project are correct against their metadata in the database. This table lists the validations performed:

Validation Operation

Description

Translate

For record fields defined as edit type Translate Table Edit, check if field value is in the translate table.

Yes/No

For record fields defined as edit type Yes/No Table Edit, check if all yes/no fields contain yes or no data only.

Required

For record fields defined as Required, check if all Required fields contain data.

Prompt

For record fields defined as edit type Prompt Table Edit, check if the field value is contained in the prompt table.

Reference

For references defined in Relations in the Data Set Designer, check if the references for data set instances in the project are correct.

When and Where to Run Validation

Validation and Check Integrity can be run in various stages in the data migration process. When they are run will determine the validation that takes place.

  • Check Integrity

    Stage

    Database

    UI Control

    Description

    Before Copy to File

    Source

    Check Integrity button

    Performs all basic edits.

    Before Compare/Copy From File

    Target

    Check Integrity button

    Performs all basic edits.

    Copy From File

    Target

    Check Integrity After Copy checkbox on the Copy From File page

    Performs all basic edits.

    After Copy From File

    Target

    Check Integrity button

    Performs all basic edits.

  • Validate

    Stage

    Database

    UI Control

    Description

    Before Compare/Copy From File

    Target

    Validate button

    Performs translate, Yes/No, and Required edits, does not include prompt and reference edit.

    Compare From File

    Target

    Validate Project checkbox on Compare From File page

    Performs translate, Yes/No, and Required edits, does not include prompt and reference edit.

    Copy From File

    Target

    Validate Project checkbox on Copy From File page

    Performs translate, Yes/No, and Required edits, does not include prompt and reference edit.