Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Flow Design - still creating individual DW's, Changes needed to…
Data Flow Design - still creating individual DW's
Changes needed to Current ETL to make ETL owner aware
Table that identifies Owner / Tenant info
**Table that identifies which objects are being pulled
**Does this need to be column specific?
Modifications to Stored Procs to pull by owner / tenant
Mod tables to include Owner / Tenant info
Bunker Hill DB
BH Data Factory
Only BH owned cattle
BH DW
BH Power BI
ALCC Data Factory
Only ALCC owned cattle
ALCC owned DW
ALCC Aggregation Data Factory
Power BI
Bunker Hill DB
BH Data Factory
Only BH owned cattle
BH DW
BH Power BI
ALCC Data Factory
Only ALCC owned cattle
ALCC Aggregation DW
Power BI
ALCC + BG's DB
ALCC Data Factory
Only ALCC owned cattle @ Locations ALCC owns or BG's
ALCC DW
ALCC + BG's DB
ALCC Data Factory
Only ALCC owned cattle @ Locations ALCC owns or BG's
How can the ETL be owner Specific
ETL for each owner's cattle
Cattle Owner