Oracle Business Analytics Warehouse:
1.Data Integration engine that combines data from multiple source systems to build a data warehouse.
2.An open architecture to allow organizations to use third party analytical tools with OBAW using OBI Server.
3.Prebuilt data extractors to incorporate data from external applications into the Oracle Business Analytics Warehouse.
4.A set of ETL processes that takes data from multiple source systems and creates the OBAW tables.
5.DAC schema management as well as configuration,administration,loading and monitoring of OBAW.
OBAW Architecture:
High level analytical queries,like those commonly used in OBAW,scan and analyze large volumes of data using complex formulas.
For this reason,the Oracle Business Analytics warehouse was constructed using dimensional modelling techniques to allow for fast access to information required for decision making.
OBAW derives its data from Operational applications and uses informatica's data integration technology to extract,transform and load data from transactional databases into OBAW.
OBAW Architecture components:
1.DAC Client: A command and control interface for the DWH to allow for schema management,configuration,administration and monitoring of data warehouse processes.
It also enables you to design subject area and build execution plans.
2.DAC Server: Executes the instructions from DAC client.DAC server manages data warehouse processes,including loading of the ETL and scheduling execution plans.
3.DAC repository:Stores the metadata that represents the data warehouse processes.
4.Informatica server:Load and refreshes the OBAW.
5.Informatica Repository Server: Manages the Informatica Repository.
6.Informatica Repository:Stores the metadata related to informatica workflows.
7.Informatica client utilities:Tool that enable you to create and manage the informatica repository.
DAC--
It provides a framework for the entire life cycle of data warehouse Implemenations.
It enables you to create,configure,execute and monitor modular Datawarehouse Applications in a parallel,high performing environment.
1.Data Integration engine that combines data from multiple source systems to build a data warehouse.
2.An open architecture to allow organizations to use third party analytical tools with OBAW using OBI Server.
3.Prebuilt data extractors to incorporate data from external applications into the Oracle Business Analytics Warehouse.
4.A set of ETL processes that takes data from multiple source systems and creates the OBAW tables.
5.DAC schema management as well as configuration,administration,loading and monitoring of OBAW.
OBAW Architecture:
High level analytical queries,like those commonly used in OBAW,scan and analyze large volumes of data using complex formulas.
For this reason,the Oracle Business Analytics warehouse was constructed using dimensional modelling techniques to allow for fast access to information required for decision making.
OBAW derives its data from Operational applications and uses informatica's data integration technology to extract,transform and load data from transactional databases into OBAW.
OBAW Architecture components:
1.DAC Client: A command and control interface for the DWH to allow for schema management,configuration,administration and monitoring of data warehouse processes.
It also enables you to design subject area and build execution plans.
2.DAC Server: Executes the instructions from DAC client.DAC server manages data warehouse processes,including loading of the ETL and scheduling execution plans.
3.DAC repository:Stores the metadata that represents the data warehouse processes.
4.Informatica server:Load and refreshes the OBAW.
5.Informatica Repository Server: Manages the Informatica Repository.
6.Informatica Repository:Stores the metadata related to informatica workflows.
7.Informatica client utilities:Tool that enable you to create and manage the informatica repository.
DAC--
It provides a framework for the entire life cycle of data warehouse Implemenations.
It enables you to create,configure,execute and monitor modular Datawarehouse Applications in a parallel,high performing environment.
No comments:
Post a Comment