Oracle Warehouse Builder: Difference between revisions
| Line 3: | Line 3: | ||
== Features == |
== Features == |
||
The primary use for OWB is consolidation of heterogeneous data sources in [[Data warehouse|data warehousing]] and [[data migration]] from [[legacy system|legacy systems]]. Further it offers capabilities for [[Relational model|relational]], [[Dimensional modeling|dimensional]] and [[metadata modeling|metadata]] [[data modeling]], [[data profiling]], [[data cleansing]] and [[data auditing]]. Whereas the core functionality is part of the [[Oracle database]] since version |
The primary use for OWB is consolidation of heterogeneous data sources in [[Data warehouse|data warehousing]] and [[data migration]] from [[legacy system|legacy systems]]. Further it offers capabilities for [[Relational model|relational]], [[Dimensional modeling|dimensional]] and [[metadata modeling|metadata]] [[data modeling]], [[data profiling]], [[data cleansing]] and [[data auditing]]. Whereas the core functionality is part of the [[Oracle database]] since version 10gR2, some of the latter features are sold separately as options. |
||
== History == |
== History == |
||
Revision as of 19:03, 28 April 2009
Oracle Warehouse Builder (OWB) is an ETL tool produced by Oracle that offers an graphical environment to handle data integration processes in business intelligence systems.
Features
The primary use for OWB is consolidation of heterogeneous data sources in data warehousing and data migration from legacy systems. Further it offers capabilities for relational, dimensional and metadata data modeling, data profiling, data cleansing and data auditing. Whereas the core functionality is part of the Oracle database since version 10gR2, some of the latter features are sold separately as options.
History
Oracle Warehouse Builder was first released in January 2000.[1]
The packaging as part of the Oracle Developer Suite ended in May 2006 with the release of OWB 10.2 (10g Release 2), when the core functions were included in Oracle 10g2 standard and enterprise editions.
With the introduction of Oracle 11g in July 2007 the OWB version was updated to the current 11.1 (11g Release 1).
Version 11.2 (11g Release 2) went to beta stage in December 2008 and is scheduled to be released in 2009. It will feature improved usability, support for Oracle OBI EE, and native access to non-Oracle platforms.[1]
Future integration with Oracle Data Integrator
As of 2008[update], Oracle plans to integrate OWB with Oracle Data Integrator (ODI), an ETL tool Oracle acquired when it took over Sunopsis in 2006. In the short term, OWB and ODI will continue to be released independently, with each release being closer to integrating the two products.[1] In the long term, Oracle plans to release a unified data integration product.[1]
References
- ^ a b c d "Oracle ® Warehouse Builder Product Roadmap" (PDF). Oracle Corporation. July 2008. Retrieved 2009-04-15.