Extractions

After setting up your source and destination connections, you can create and manage extractions to control how data is transferred between them. The Extractions page lets you map a source connection to a destination connection and define the actions to perform during the transfer. In other words, you decide from which data source the data will be extracted and into which database the data will be loaded.

important

Ensure that your source and destination servers are synchronized to the same time server to prevent timing and data consistency issues.

In this sections:

Topic	Description
Add an extraction	Create a new extraction manually or by importing one from a template or backup.
Add tables	Select the tables or queries to include in your extraction.
Manage table indexes	Create, update, or delete indexes for tables to optimise performance.
Configure table fields	Choose which fields to include, change field types, and set keys or transformations.
Load tables by partition	Configure incremental table loading in smaller date-based batches.
Edit existing extractions	Modify or update the settings and configuration for existing extractions.
Validate and build an extraction	Validate extraction settings and update the destination structure before running.
Run an extraction	Execute an extraction manually and choose the load mode.
Run a post execution script	Set and run SQL scripts automatically after table loading.
Export an extraction	Save an extraction as a backup or reuse it in another environment.