Advanced ETL Processor services support production automation by running ETL work without depending on a user manually starting the desktop application. This is the difference between a workflow and a workflow that still runs when everyone has gone home.
What You Will Learn
- Understand where services fit in Advanced ETL Processor automation.
- Prepare ETL workflows for unattended execution.
- Use the Execution Agent for scheduled production work.
- Review logs and monitoring before relying on service-based jobs.
Before You Start
Build and test the workflow interactively first. Services are excellent at repeating exactly what you configured, including mistakes.
Automation Docs For Service Execution
Services are used when ETL jobs need to run unattended. In practice, that means scheduled packages, transformations, imports, and SQL scripts can execute without someone opening the desktop application and clicking buttons like it is 1999.
The automation documentation explains the main execution options, including the Execution Agent, Scheduler, Event Monitors, and Command Line Interface.
Before using services in production, also review the Execution Log and Management Console. Automation without logging is just guessing with a timetable.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.