Skip to main content
Skip table of contents

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:

  1. Open the replication job dialogue in the Web UI and go to the optimization menu.

  2. Click Create New Job and then Create Replication Job:

    Context menu for a virtual view showing copy options and job creation options in the Code Editor.

  3. In the dialogue, select the CopyOver tab:

    Create New Replication Job screen with Copy Over selected, target table settings, cleanup method options, and schedule section.

    Advanced Options section showing job enable toggle, parallel run setting, retry on failure option, timeout field, and start immediately toggle.

See Also

Replication Jobs for more information on this type of jobs

Replication Jobs Procedures for detailed information on the related system procedures

A short guide on data replication types and use cases. CopyOver Replication for a post in the CData Virtuality blog on CopyOver replication

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close