Budgetary

1
ETL Tool
Legacy
Warehouse Admin. Tools
End-user Tools
FRMS
Budgetary
Extract, Transform and Load
Agency One
Data Mart
Inventory
Central Metadata
Local Metadata
Agency Two
GHRS
Metadata Exchange
Data Mart
Data Cleansing Tool
Local Metadata
Data Modeling Tool
Architected Data Mart
Architected Data Mart
Source Databases
Data Extraction, Transformation, Load
Data Access and Analysis
State of Alabama Data Warehouse Architecture -
Phase I
2
End-user Tools
ETL Tool
Central Data Warehouse
Legacy
Warehouse Admin. Tools
FRMS
Local Metadata
Budgetary
Extract, Transform and Load
Agency One
Data Mart
Inventory
Central Metadata
Local Metadata
Agency Two
GHRS
Metadata Exchange
Data Mart
Data Cleansing Tool
Local Metadata
Data Modeling Tool
Architected Data Mart
Architected Data Mart
Source Databases
Data Extraction, Transformation, Load
Data Access and Analysis
State of Alabama Data Warehouse Architecture -
Phase II
3
End-user Tools
ETL Tool
ODS
Legacy
Warehouse Admin. Tools
Central Data Warehouse
FRMS
Budgetary
Extract, Transform and Load
Inventory
Local Metadata
Agency One
Central Metadata
Data Mart
GHRS
Metadata Exchange
Local Metadata
Agency Two
Data Cleansing Tool
Data Mart
Data Modeling Tool
Local Metadata
Architected Data Mart
Architected Data Mart
Source Databases
Data Extraction, Transformation, Load
Data Access and Analysis
State of Alabama Data Warehouse Architecture -
Phase III