Replication

There are several types of replication:

• batch: there is one fixed table residing in the analytical storage which is updated whenever the replication job run;

• incremental: only newly added data from the source table is copied to the analytical storage;

• CopyOver: the current data is retrieved from a given source and put into the local table. If a table with the same name already exists, it will be handled according to the selected cleanup method;

• history update: keeps track of changes made to data;

• upsert update: supports updating existing rows and inserting data into new ones.

In the subpages, we explain all types in more detail.