Run Extraction
After validating your extraction, you can manually run it to produce an immediate result instead of waiting for a scheduled run. Tables are extracted in alphabetical order. To ensure one table finishes before the next starts, set Parallelism to 1 in the extraction settings.
Run an extraction
- From the welcome screen or left navigation pane, select Extractions.
- Select the built extraction.
- Click Run Extraction Now in the upper-right corner.
- Select the tables to populate.
- In the upper right, choose the load mode from the dropdown list, then click Run. This replaces all destination data with the selected source data depending on the load mode.
Wait for the process to finish. The results appear in the Status column. If an error occurs, click the link in the Error column to view details in the Logs page.
Load mode options
| Option | Description |
|---|---|
| Load | (Migration only) Loads all data from the source into the destination. |
| Truncate and Load | Replaces all destination data with current data from the source. |
| Incremental Load | Updates only records that have changed since the last incremental load, replacing their corresponding records in the destination. |
| Process Deleted Records | Checks for records deleted in the source within a specified number of days. For example, if set to 30 days, DataSync verifies all transactions created or updated in the last 30 days and deletes from the destination any that no longer exist in the source. |