10 likes | 331 Views
Brio ODS/JF Node. Informatica PowerCenter ETL Server. Brio Portal. Brio Quickview content Viewers. Brio WebClient. DATA SOURCES. DATA ACQUISITION. DATA WAREHOUSE. DATA DELIVERY. DATA CONSUMPTION. operational systems transactional systems. extraction transformation
E N D
Brio ODS/JF Node Informatica PowerCenter ETL Server Brio Portal Brio Quickview content Viewers Brio WebClient 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 banner reporting instance (clone) AIX production data warehouse machine AIX 4-CPU 4GB RAM Brio Portal & Brio Intelligence AIX end-user machines 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