SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory

© Andy Leonard, Kent Bradshaw 2020

A. Leonard, K. BradshawSQL Server Data Automation Through Frameworkshttps://doi.org/10.1007/978-1-4842-6213-9_3

3. Stored Procedure Orchestrators

Andy Leonard¹  and Kent Bradshaw²

(1)

Farmville, VA, USA

(2)

Providence Forge, VA, USA

 

Building on the controller pattern in Chapter 2, the next logical progression for the framework is the concept of the orchestrator. It is basically a controller for controllers and can address the issue of precedence rules between controllers.

The Orchestrator

Controllers are themselves a type of process just as the daily and monthly processes that have been built. We may find that dependencies exist between the processing of different controllers. That is where an orchestrator comes in. ...