OWB, DI, Discoverer and OBIEE
680889Aug 10 2009 — edited Aug 10 2009Hi All,
I got confused in OWB, DI, Discoverer and OBIEE technologies.I have following understanding about these:
1. OWB: Oracle Warehouse Builder (transfers only useful data from one system to warehouse based on mappings). OWB is ETL (Extract- Transform- Load) based technology.
2. DI: Oracle Data Integrator (ODI) is an E-LT (Extract, Load and Transform) tool used for high-speed data movement between disparate systems.Oracle bought the tool from Sunopsis in October 2006.
3. Discoverer: A reporing mechanism from data available in Warehouse.
4. OBIEE is a comprehensive suite of enterprise business intelligence products that contain the programs, servers, and tools to support broad, self-service access across the organization. OBIEE is the foundation for Fusion Intelligence For E-Business Suite applications.
First of all please correct me if my understanding is wrong. And I also hope all of these technologies are for mostly reporting.
Right now we have Oracle Application implementation for OM and CRM and one data warehouse (Oracle 10g database). We also have OWB to load the data from Oracle apps database to Discoverer by mappings defined and we use discoverer to generate the reports.
Now my questions are:
1. What is the relation among these technologies?
2. We generally keep different database for Datawarehouse to avoid extra reporting load on Application server (Oracle apps), is it right???
3. Is Di is the advanced technology from OWB?
4. If we want to implement OBIEE, then how data will come to data warehouse or we have to use OWB with OBIEE also to get the data in data warehouse?
5. Or can we use DI instead of OWB to make the process faster.
Please help me in this regard.
Thank you,
Anupam