This chapter provides an overview of the architecture and various components that make up BIA Reporting. Each of the artifacts provided with BIA Reporting are explained.
The BIA Reporting solution is a framework for providing specific reports. As a framework it can be customized to include new reporting requirements as they arise. The framework consists of the following deliverables:
- A set of data models both Relational and Dimensional. These models are optimized to support reporting needs.
- Extract Transform and Load (ETL) process definitions. A set of process definitions that define how the data is moved and transformed from the On-Line Transaction Processing (OLTP) data source to the BIA Reporting data sources. These are provided for both Oracle and DB2 platforms. The tools used to perform the ETL processes are Oracle Warehouse Builder (OWB) and IBM InfoSphere Warehouse Edition (IWE).