Validate and Build Extraction
Once your extraction, including the source, destination, and related tables, is set up, the next step is to validate its configuration and update the destination structure before running it. The Validate and Build feature checks that all required tables, fields, and indexes exist in the source connection, validates SQL queries and calculated fields, and ensures that changes will not compromise data integrity in the destination, such as when modifying table structures.
Validate and build
For synchronization and consolidation extractions
- From the welcome screen or left navigation pane, select Extractions.
- Select a synchronization or consolidation extraction.
- Click Validate and Build in the upper-right corner.
- In Options, select the desired settings. If you select both options, validated tables will not be cleaned.
- In Object Management, choose the desired action.
- Click Build.
When complete, review the validation report and the Status column. If an error appears, select the link in the Error column to view the Logs page. - Next, run the extraction.
note
If a table exists in the destination but not in the source, you must delete it manually from the destination.
Options
| Setting | Description |
|---|---|
| Options | Remove tables, fields and indexes that does not exist in the source Cleans the extraction during validation by removing any tables, fields, or indexes not found in the source. This applies to all validated tables. Process only tables for which the configuration had changed since the last validation Selected by default. Processes only objects that have been modified since the last validation. This affects only modified objects. |
| Object Management | Only add missing tables/fields/indexes Adds only the missing objects and updates changed objects without deleting existing data. To update all objects, select this option and clear the first option. Drop the previously created object and recreate the objects based on the new definition Deletes the changed objects and recreates them with the new definition. To recreate all objects, select this option and clear the first option. |
For migration and export extractions
- From the welcome screen or left navigation pane, select Extractions.
- Select a migration or export extraction.
- Click Validate and Build in the upper-right corner.
- Click Build.
When complete, review the validation report and the Status column. If an error appears, select the link in the Error column to view the Logs page. - Next, run the extraction.