Copy Over

The CopyOver method retrieves the current data from a given source and puts it into the local table. If a table with the same name already exists, it will be handled according to the selected cleanup method.

Parameter

Type

Description

dwh_table

string

Analytical storage table the data will be put into

source_table

string

Source object the data will come from

cleanup_method

string

Specifies the cleanup method. Valid values:

DROP (table will be dropped and recreated); default
DELETE (table will be emptied via deletion of all rows)

PIPES_PREFER_DROP not set and cleanup_method not set => DROP
PIPES_PREFER_DROP set and cleanup_method not set => PIPES_PREFER_DROP
PIPES_PREFER_DROP not set and cleanup_method set => cleanup_method
PIPES_PREFER_DROP set and cleanup_method set => cleanup_method

CopyOver Jobs

In addition to the CopyOver() method, the CData Virtuality Server also allows using the CopyOver technique on data sources via two procedures:

createCopyOverSourceTableJob()
createCopyOverSQLJob()

For changing existing CopyOver jobs, two more procedures are available:

changeCopyOverSourceTableJob()
changeCopyOverSQLJob()

How It Works

To add a replication job in the Web UI, do the following:

Open the replication job dialogue in the Web UI and go to the optimization menu.
Click Create New Job and then Create Replication Job:
In the dialogue, select the CopyOver tab:

CopyOver Jobs

How It Works

See Also