Oracle Warehouse Builder (OWB) is an
ETL tool produced by
Oracle that offers a graphical environment to build, manage and maintain
data integration
Data integration involves combining data residing in different sources and providing users with a unified view of them.
This process becomes significant in a variety of situations, which include both commercial (such as when two similar companies ...
processes in
business intelligence
Business intelligence (BI) comprises the strategies and technologies used by enterprises for the data analysis and management of business information. Common functions of business intelligence technologies include reporting, online analytical p ...
systems.
Features
The primary use for OWB is consolidation of heterogeneous data sources in
data warehousing
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integr ...
and
data migration
Data migration is the process of selecting, preparing, extracting, and transforming data and permanently transferring it from one computer storage system to another. Additionally, the validation of migrated data for completeness and the decommis ...
from
legacy system
In computing, a legacy system is an old method, technology, computer system, or application program, "of, relating to, or being a previous or outdated computer system", yet still in use. Often referencing a system as "legacy" means that it paved ...
s. Further it offers capabilities for
relational,
dimensional and
metadata data modeling,
data profiling
Data profiling is the process of examining the data available from an existing information source (e.g. a database or a file) and collecting statistics or informative summaries about that data. The purpose of these statistics may be to:
# Find ou ...
,
data cleansing
Data cleansing or data cleaning is the process of detecting and correcting (or removing) corrupt or inaccurate records from a record set, table, or database and refers to identifying incomplete, incorrect, inaccurate or irrelevant parts of the d ...
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. OWB uses a variant of
Tcl
TCL or Tcl or TCLs may refer to:
Business
* TCL Technology, a Chinese consumer electronics and appliance company
**TCL Electronics, a subsidiary of TCL Technology
* Texas Collegiate League, a collegiate baseball league
* Trade Centre Limited ...
over
Java
Java (; id, Jawa, ; jv, ꦗꦮ; su, ) is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea to the north. With a population of 151.6 million people, Java is the world's mos ...
and
PL/SQL
PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 6 - stored PL/SQL procedures/functions/packages/triggers since ...
called OMB+.
History
Oracle Warehouse Builder was built from the ground up in Oracle, it was first released in January 2000 (release 2.0.4). The 3i release significantly enhanced the ETL mapping designer, then 9i in 2003 introduced the mapping debugger, process flow editing, integrated match/merging and name/address cleansing, multi-table insert, scripting, RAC certification to name a few. The 10gR1 release was essentially a certification of the 10g database, and the 10gR2 release (code named Paris) was a huge release incorporating a wide spectrum of functionality from dimensional modelling to data profiling and quality. The OWB 11gR1 release was a move into the database release stack, and included the server components being installed with the database and MDM connectors.
The packaging as part of the
Oracle Developer Suite ended in May 2006 with the release of OWB 10gR2 (''10g Release 2''), when the core functions were included in
Oracle 10gR2 Standard Edition and Enterprise Edition.
With the introduction of Oracle 11g in July 2007 the OWB version was updated to 11gR1 (''11g Release 1'').
Version 11.2 (''11g Release 2'') was released with the 11gR2
Oracle Database in September 2009. Its features include support for Oracle OBI EE, and native access to an extensible set of non-Oracle platforms using customizable and user-definable code templates.
Future integration with Oracle Data Integrator
, 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. The Warehouse Builder 11.2 code template support is in fact derived from and largely compatible with the Oracle Data Integrator Knowledge Module framework.
Oracle has publicly commented on plans to release a data integration product that will unify features from both of the current offerings.
UPDATE:
According t
Oracle Data Integrator and Oracle Warehouse Builder Statement of Direction(First Published January 2010,
Updated May 2011):
No major enhancements are planned for Oracle Warehouse Builder beyond the OWB
11.2 release. OWB 11.2 continues to be available and supported by Oracle, and patches
and bug fixes will continue to be offered at regular intervals. Oracle will continue to
support OWB 11.2 for the full lifetime of Database 11g and the full lifetime of the next
major database release (“Database 12”) in accordance with Oracle’s Lifetime Support
Policies for Database releases. Future database releases beyond Database 12 would
not be certified with OWB 11.2.
OMB+
Script everything
References
{{reflist
External links
*
ttp://forums.oracle.com/forums/forum.jspa?forumID=57&start=0 Discussion forumOracle Warehouse Builder blog
2000 software
Warehouse Builder
Extract, transform, load tools
Data warehousing products