Replication mode
The following replication modes are available:
Information noteWhen replicating from SaaS application sources, the Full load replication mode is enabled by default and cannot be disabled.
- Full load: Loads the data from the selected source tables to the target platform and creates the target tables if necessary. The full load occurs automatically when the task is started, but can also be performed manually should the need arise.
- Apply changes: Keeps the target tables continually up-to-date with any changes made to the source tables.
-
Store changes: Stores the changes to the source tables in Change Tables (one per source table).
For more information, see Store changes.
If you select Store changes or Apply changes and your source data contains tables that do not support CDC, or views, two data pipelines will be created. One pipeline for tables that support CDC, and another pipeline for all other tables and views that support Full load only.
Information noteALTER TABLE DDL operations are not currently supported. Other DDL operations such as DROP TABLE and TRUNCATE TABLE are supported.
Apply changes mode
Changes are applied to the target tables using one of the following methods:
- Batch optimized: This is the default. When this option is selected, changes are applied in batches. A preprocessing action occurs to group the transactions into batches in the most efficient way.
- Transactional: Select this option to apply each transaction individually, in the order it is committed. In this case, strict referential integrity is ensured for all tables.