Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OWB, DI, Discoverer and OBIEE

680889Aug 10 2009 — edited Aug 10 2009
Hi 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
This post has been answered by rmoff on Aug 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details