![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 19%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWN%3C/text%3E%3C/svg%3E)
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
@Winnie Ng - Thanks for the question and using MS Q&A platform.
Yes, there is a difference between a scheduled trigger and a tumbling window trigger when scheduling an SAP CDC pipeline in Azure Data Factory.
A scheduled trigger is used to run a pipeline on a fixed schedule, such as every day at a specific time or every hour. You can set the start time and recurrence interval for the trigger, and the pipeline will run automatically according to the schedule.
On the other hand, a tumbling window trigger is used to run a pipeline on a recurring basis, but with a sliding window of time. This means that the trigger will run the pipeline at regular intervals, but the data processed by the pipeline will be limited to a specific time window. For example, you could set up a tumbling window trigger to run a pipeline every hour, but only process data from the last 15 minutes.
In the context of SAP CDC pipelines, a scheduled trigger would be appropriate if you want to run the pipeline on a fixed schedule, such as every day at midnight. A tumbling window trigger would be appropriate if you want to run the pipeline at regular intervals, but only process data from a specific time window, such as the last hour or the last day.
Ultimately, the choice between a scheduled trigger and a tumbling window trigger will depend on your specific requirements and the nature of the data you are processing.
Use the SAP CDC connector with Data Factory features like mapping data flow activities, and tumbling window triggers for a low-latency SAP CDC replication solution in a self-managed pipeline. You can run your pipeline and mapping data flows frequently by using a Data Factory tumbling window trigger to replicate SAP data in Azure with low latency and without using watermarking.
For more details, refer to Overview and architecture of the SAP CDC capabilities and Manage the SAP CDC process.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.