Validating and Building an Extraction

Once your extraction (source, destination connection and their related tables) is set up, the next step is to validate the setting of an extraction, before being able to run it.

The feature will:

  • Ensure that all the tables, fields, and indexes exist in the source connections,
  • Validate all SQL queries or calculated fields,
  • Ensure that the data integrity in the destination connection is not affected (ex: change the table structure).

To validate and build an extraction:

  1. Select the extraction you want to validate and build in the list and click the Validate and Build icon.

  2. In the dialog box, perform one of the actions below.

    • For Synchronization / Consolidation and extraction types, choose an option and click Build:

      The options are as follows:

      Option Description
      Options  
      Remove tables, fields, and indexes that do not exist in the source

      Clean-up an existing extraction as a pre-process step during a Validate and Build process in DataSync. When checked, it removes from the extraction any tables, fields, or indexes that cannot be found in the source. This applies to all tables that will be validated. Thus, if Process only tables for which the configuration had changed since the last validation is also checked, already validated tables won’t be cleaned in the extraction.

      Note that this cleans the extraction only. To propagate the changes in the destination, you will need to select Drop the previously created object and recreate the objects for tables and fields, and select Only add missing tables/fields/indexes to recreate the index.

      In the case of a table not present in the source but present in the destination, you must manually delete the destination table.
      Process only those tables for which the configuration has changed since the last validation This option is selected by default. It will only affect modified objects.
      Object Management  
      Only add missing Tables/Fields/Indexes

      Select this option to apply changes only (additions, edits, and deletions). The structure will be updated and existing data will remain for objects that have changed.

      To apply changes to all objects, select this option and remove the first option.
      Drop the previously created object and recreate the objects

      Select this option to delete and recreate objects that were changed since the last validation.

      To recreate all objects, select this option and remove the first option.

    • For Migration and Export extraction types, click Validate.

  1. Wait for the process to be done. A validation report is displayed to give you a quick overview once the process is finished. The results are displayed in the Status column. If there is an error, click the hyperlink in the Error column to view the Log Page.