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_4

4. A Stored Procedure–Based Metadata-Driven Framework

Andy Leonard¹  and Kent Bradshaw²

(1)

Farmville, VA, USA

(2)

Providence Forge, VA, USA

 

In order to add flexibility and control over the execution of all of the processes within the framework, metadata can be added to the environment. It can identify the stored procedures, controllers, and orchestrators as well as the relationships between each. The metadata will be used as the communication that drives the execution of the processes.

Building the Metadata

If we’re going to create metadata, then we need a place in which to store it. We can create a table ...