BI Solution Architecture Overview Source DB: Most of Relational databases, data file (txt, excel….). ETL (Extract, transform, load): A process to filtrate the necessary data to target database. Including: Extracting data from outside sources, transforming it to fit operational needs (which can include quality levels), Loading it into the end target (database or data warehouse). This process runs automatically and periodically. OLTP DB: Is a Relational database which is used to store the data after ETL process. Computing & Analysis: Build CUBE data on OLAP DB. This process runs automatically and periodically. OLAP DB: A CUBE data database. Report Tools: Any report tool can query CUBE data. Module Tools Used in demo Option Source DB MS-Sqlserver 2005 Oracle xi, Access, My Sql, Txt files…. ETL MS-DTS Oracle-OWB, MS- SSIS, Datastage… OLTP DB MS-Sqlserver 2005 Oracle xi, My Sql…. Computing & Analysis MS-Analysis Service Oracle OLAP Services…. OLAP DB MS-OLAP Oracle OLAP Report Tools Excel 2007 Crystal Report, BO….. Usage scope In most of our current projects, we built the business reports by running the Ad Hoc Query on Relational database. We can treat this as a simple online transaction processing (OLTP), just because the data size is small and structure is very simple, so no need ETL process. In this solution, we are suggested to use online analytica
