Brio Portal

1
DATA SOURCES
DATA ACQUISITION
DATA WAREHOUSE
DATA DELIVERY
DATA CONSUMPTION

• operational systems
• transactional systems

• extraction
• transformation
• modeling
• loading

• central repository
• subject-based data marts
• metadata
• operational data store

• user-facing applications
• report generation
• subject-based data cubes
• data mining

• business intelligence
• decision-support
• OLAP
• querying
• reporting

Brio Portal Brio Intelligence AIX
production data warehouse machine AIX 4-CPU 4GB
RAM
end-user machines
banner reporting instance (clone) AIX
Microsoft Excel analysts
Banner Reporting Instance Oracle 7.3
DWDB (targets) Oracle 8i DWDB
Informatica Repository metadata
Brio Insight analysts
Brio Shared Metadata
banner production AIX
Banner Oracle 7.3 PROD
Webserver (Apache) AIX