Enabling Delta Replication – End-to-End Step-by-Step User Guide

This guide explains how to enable Delta Replication in Dynamic Data Replicator for time based Data Refresh templates. Delta Replication allows recurring refresh activity to run using a defined schedule, so only relevant incremental changes are processed after the initial refresh cycle.

Time BasedDelta Replication is enabled from a Data Refresh time based template.

ScheduledRun delta refreshes daily, weekly, monthly, or yearly.

ControlledSet the schedule start date, time, run mode, and delta frequency.

AutomatedUse the console schedule job to trigger planned replication cycles.

Purpose of Delta Replication

Delta Replication is used when an organisation needs a controlled recurring refresh process rather than a full refresh every time. It helps keep non production systems updated with relevant changes from the source system while reducing processing effort, runtime, storage impact, and manual administration.

In DDR, Delta Replication is enabled from the Data Refresh dashboard for a time based template. The user selects the required template, opens Schedule Settings, enables Delta Relevant, selects the delta frequency, confirms the planned start date and time, and then schedules the run.

Key point: Delta Replication can be enabled only for Data Refresh time based replication. It should be used where the business requirement is to keep test or non production data refreshed at planned intervals without repeatedly executing a full copy.

Business Benefits

Reduced Refresh Effort

Supports recurring refresh activity without requiring the same level of manual preparation for each cycle.

Improved Test Readiness

Keeps selected test data aligned with source activity so teams can work with more current and relevant datasets.

Lower System Impact

Helps reduce unnecessary processing by focusing on delta based refresh activity instead of repeated full refreshes.

Operational Control

Allows administrators to define exact schedule frequency, start date, start time, and execution mode.

Repeatable Governance

Provides a structured and auditable approach for refresh scheduling across SAP source and target systems.

Better Automation

Uses the DDR console scheduling process to automate planned replication cycles.

Step 1

Open the DDR Data Refresh Dashboard

From the DDR application, go to the Data Refresh dashboard. This is where time based templates are listed and managed. Select the time based template for which Delta Replication needs to be enabled.

The template must be a Data Refresh time based template. Delta Replication should not be enabled from other template categories because the delta scheduling process is designed for time based refresh scenarios.

Screenshot 1: DDR Welcome Screen and Navigation Context

Use the left hand DDR navigation to access the Data Refresh and Dashboard areas used for template selection and scheduling.

Step 2

Select Schedule Settings

After selecting the required time based template, click Schedule Settings. The schedule popup opens and allows the user to define the start date, start time, run mode, and delta setting.

Select the required Schedule Start date and time. Then confirm the Run Mode, such as Actual Run, based on the intended execution approach.

Screenshot 2: Schedule Settings – Delta Replication Frequency

DDR schedule settings popup with delta replication frequency

The Schedule Settings popup is used to enable Delta Relevant and choose the delta frequency such as Daily, Weekly, Monthly, or Yearly.

Step 3

Enable Delta Relevant and Select the Frequency

Tick Delta Relevant to enable delta based scheduling for the selected template. Once selected, choose the required delta mode from the dropdown list.

Delta Mode	Purpose	Typical Use
Daily	Runs the delta refresh every day from the scheduled start point.	Useful for high activity test environments requiring regular updates.
Weekly	Runs the delta refresh once per week.	Useful for planned weekly test data alignment.
Monthly	Runs the delta refresh once per month.	Useful for periodic project, reporting, or regression test cycles.
Yearly	Runs the delta refresh once per year.	Useful for low frequency controlled refresh requirements.

Step 4

Schedule the Delta Replication Run

Once the schedule start date, time, run mode, Delta Relevant option, and delta frequency have been selected, click Schedule. DDR saves the scheduling details and prepares the selected Data Refresh template for recurring delta execution.

The scheduled run will be managed by the DDR console scheduling process. Administrators should ensure that the required background job is available and active in the console system.

Important: Please schedule the /ADM/TDPG_SCHEDULE_EXPORT job in the console system. This job is required for scheduled DDR export processing.

Technical Notes

Delta Replication is available for Data Refresh time based replication only.
The selected template must already exist before delta scheduling can be configured.
The schedule start date and time determine when the recurring delta cycle begins.
The delta mode controls the recurrence pattern, such as daily, weekly, monthly, or yearly.
The console scheduling job must be active so DDR can trigger planned export execution.
Authorised users should review template selection carefully before scheduling production like refresh activity into non production systems.

Process Flow Summary

Step	User Action	System Outcome
1	Open Data Refresh dashboard.	DDR displays available templates and dashboard controls.
2	Select the required time based template.	The selected template becomes the schedule target.
3	Click Schedule Settings.	DDR opens the scheduling popup.
4	Select start date, time, and run mode.	DDR captures the schedule execution settings.
5	Tick Delta Relevant and choose frequency.	DDR enables recurring delta replication for the selected template.
6	Click Schedule.	The delta replication schedule is saved for automated execution.