Execution Automation

Enterprise Version offers various windows services dedicated to unattended execution.

Execution Flow

Execution Flow

The execution flow above is based on microservices architecture. Its main benefit of it is resilience. If one component fails the rest will continue working. Components can be updated independently or moved from server to server

Notes:

  • When an event happens event monitor inserts a record into the execution queue.
  • Scheduler is constantly checking the schedule table and if there’s something to execute it inserts a record into the execution queue
  • Execution agent is constantly checking queue table and if there’s something to execute it launches command line execution utility
  • Once the command line execution utility completes the execution it moves records from the queue table into queue_archive
  • Scheduler is a part of the execution agent

Execution Automation

Event Monitors

Video Tutorials





For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: September 28, 2022