Current Architecture
OLTP Sources
Oracle
Sybase
Mframe
DB2/ISAM
External
Extraction
Tools:
Oracle Repl’n
ftp
Shell Scripts
Cobol
JCL
FOCUS
Bcp
ODS / Staging
Oracle
Unix
Files
Loading
Tools:
Shell Scripts
Perl
SQL
PL/SQL
BRTE
(IU Batch
Run-Time Envt
shell utilities)
IU DSS Data-W’house
Oracle
ODBC
apps
IUIE
Web-Based
Publishing
•1-tbl query
•SQR reports
(PDQs)
•Frozen Files
(mime-docs)
•Indexd Files
Unix
Files
Note: Non-dimensional