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:|
|o||for Salesforce: LastModifiedDate, CreatedDate, IsDeleted;|
|o||for Dynamics CRM: modifiedon, createdon;|
|o||for Zoho CRM: Modified Time, Created Time|
|o||for SugarCRM: date_modified, date_entered, deleted|
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 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:
This tab allows specifying settings for the whole table.
Determines how Amazon Redshift will distributes the rows, loaded to the table, between the node slices. It can have the following values:
Skyvia omits this parameter when creating a table. Default value is used.
The rows will be evenly distributed between the node slices in a round-robin fashion, regardless of the row data values.
The rows will be distributed between the node slices depending on the values in one of the columns.
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.
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.
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.
This tab allows you to configure filtering settings.