Note
Your assigned role restricts which actions you can perform. Refer to Roles and Permissions for more information about role-based access in Replicate Preview.
Overview
The Replications panel lists all the replications created from the Source Tables Selection dialog box or added manually from the Replications panel.
The Replications panel displays the following columns:
Column Name | Description |
|---|---|
Target Name | Name of the target table configured in the replication. Click to view the replication overview, execution history, and logs for the recent replication refresh or execution. |
Target Schema | Schema of the selected target table. To modify the schema, Edit the replication, turn off the Use Default Schema toggle button, and specify the Target Schema. Then, click Save. |
Source Table | Name of the source table associated with the replication. |
Source Datastore | Name of the source datastore to which the source table belongs. |
Source Schema | Schema of the selected source table. |
Source Filter | Allows you to quickly view source filter information for each replication, if available. |
Progress Status | Provides real-time status updates on the events that a replication job processes in a replication. Refer to the Replication Job Progress and Status section for more information. |
Replication Type | Displays the replication type.
|
Priority | Denotes the order of the replications to be executed for the selected source and target datastores. |
Record Count | Total number of records identified in the source. |
Processed Records | Number of records successfully processed or moved to the target without any errors. |
Failed Records | Number of records that failed to move. Review logs for details about the failure cause and corrective actions. |
Volume (MB) | Displays the volume of data processed in megabytes (MB) during the last execution of the replication. |
Last Refreshed | Timestamp of the last execution of the replication. |
Duration | Time taken to complete the replication, in seconds. |
Active | Turn on the toggle button to set a replication as Active for data replication. Turning off this toggle button disables all quick action buttons except Delete and Show Logs for this replication. |
Actions | Includes the quick action icons to execute a replication, schedule a replication job, view recent logs, and so on. Refer to the Quick Action Feature in the Replications Panel section for more information. |
The Replications panel displays the number of replications configured for the selected source datastore against a target datastore. If required, you can expand and collapse this panel when auditing or reviewing details in this panel.
Columns in grids throughout the Syniti Knowledge Platform (SKP) can be individually customized, sorted, and filtered. You can also search for names or values for in columns that have the Search feature enabled. The selected settings are remembered per user. Refer to SKP Grid Searching, Sorting, and Filtering for more information.
Quick Actions Feature in the Replications Panel
You can perform the actions below using the quick action icons in the Actions column of the Replications panel. Currently, the following quick actions are supported in the Replications panel:
Note
To view more quick actions available in the Replications panel, click the More Actions button in the Actions column.
Execute Replications: Run a replication job for the selected replication associated with the corresponding target and source datastores. Refer to Execute Replication Jobs for more information.
Schedule: Set a schedule to execute a replication with customizable recurrence options, offering flexibility in running replication jobs at regular intervals as required. Refer to Schedule Replication Jobs for more information.
Field Mappings: Select the required columns in a source table, and to modify how the column attributes must be configured in a target table during a data snapshot. Refer to Perform Field Mapping for more information.
Partitions: Define custom partitions for this replication task. Each partition applies source and target filters to split the data into separate execution units. Refer to Configuring Partitions for more information.
Replication Dependencies: Define dependent replications associated with a selected replication, such that the dependent replications are run before executing the selected replication. Refer to Configuring Replication Dependencies for more information.
Drop Target Table: Removes the entire table from the target database. Use this action when a replication has been run with mismatched source and target column mappings. After dropping the table, correct the column mappings and re-run the replication to recreate the target table with proper field definition.
Edit: Modify the replication configuration. For example, you can update the applied source filter or change the target table name.
Show Logs: View and debug logs for the most recent execution of the selected replication.
Delete: Remove a replication from the associated target and source datastores.
Bulk Actions in the Replications Panel
Use the multi-select checkboxes in the Replications panel to select the required replications and perform supported bulk actions, with or without column filters. Currently, the following bulk actions are supported:
Export Selected: Exports the selected replication details as a CSV or XLSX file.
Export All: Export all replications in the selected target-source datastore combination as a CSV or XLSX file.
Add Selected to Group: Adds the selected replications to an existing group, a new group, or multiple groups.
Add All to Group: Adds all available replications in the selected target-source datastore combination to an existing group, a new group, or multiple groups.
Execute Selected: Executes only the selected replications, with or without replication state filters applied on the Progress Status column.
Execute All: Executes all replications in the selected target-source datastore combination, with or without replication state filters applied on the Progress Status column.
Delete Selected: Delete the selected replications.
Delete All: Deletes all replications in the selected target-source datastore combination.
Editing a Replication
To edit a replication:
In the Replications panel, select the required replication associated with the correct target and source datastores.
In the Actions column, select More Actions > Edit for the selected replication. The Edit Replication dialog box is displayed.
Modify the required fields that needs changes.
After finishing the required modifications, click Save.
Deleting a Replication
In the Replications panel, select the required replication associated with the correct target and source datastores.
In the Actions column, select More Actions > Delete for the selected replication. The Delete Replication Replication dialog box is displayed.
If you want to delete multiple replications, use the multi-select checkbox to select the required replications and click the Delete button at the top of the Replications panel. The Delete Selected Replications dialog box is displayed.
Click Confirm.
The selected replications and their associated workflows have been deleted successfully.