Editing Replication Task

To open a replication task, click the edit link for the corresponding replicated object in the replication package editor. When editing a replication task, you can configure the following:

You can select object fields to replicate data from. For this, in the Columns list select check boxes corresponding to object fields to replicate data from. Note that if you want to use Incremental Updates, the object key fields and the following additional fields must be included:
ofor Salesforce: LastModifiedDate, CreatedDate, IsDeleted;
ofor Dynamics CRM: modifiedon, createdon;
ofor Zoho CRM: Modified Time, Created Time
ofor SugarCRM: date_modified, date_entered, deleted
 
selecting-columns-to-export
 
You can expand and collapse the field list by clicking the replicated object name. The check box to the right of object name allows you to select all the fields of the object.
Specify the filter conditions to filter data to replicate (see how).

To save the task, click the Save button at the bottom of the Task Editor.

Replication Task for Amazon Redshift

Replication task editor for data replication to Amazon Redshift is different from the replication task editor for other sources, and it allows you to specify additional parameters, specific for Amazon Redshift. These parameters affect the Redshift table creation. The editor consists of the three tabs:

Table

This tab allows specifying settings for the whole table.

Distribution Style

Determines how Amazon Redshift will distributes the rows, loaded to the table, between the node slices. It can have the following values:

Auto

Skyvia omits this parameter when creating a table. Default value is used.

Even

The rows will be evenly distributed between the node slices in a round-robin fashion, regardless of the row data values.

Key

The rows will be distributed between the node slices depending on the values in one of the columns.

ALL

Every node will have its own copy of all the table rows.

You can find more information about distribution styles in the Amazon Redshift documentation.

Distribution Key

Determines the column, based on values of which the rows will be distributed between the node slices. If Auto is selected, this parameter will be omitted when creating the table.

Distribution Sort Keys

Specifies the column list, which will be used for sorting table data when performing initial data loading to the table.

Columns

This tab allows you to configure settings for the Redshift table columns. It also allows you to exclude some of the columns from replication.

Clear check boxes for the columns you want to exclude from replication.

You can also edit column length for textual columns and precision and scale - for numeric columns. Additionally you can select Compression Encoding for each column. Auto means that compression encoding won't be specified in the CREATE TABLE statement. See Amazon Redshift documentation for more information about compression encodings.

Filters

This tab allows you to configure filtering settings.