Oracle Warehouse Builder (OWB) is an ETL tool produced by

Oracle An oracle is a person or thing considered to provide insight, wise counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. If done through occultic means, it is a form of divination. Descript ...

that offers a graphical environment to build, manage and maintain

data integration Data integration refers to the process of combining, sharing, or synchronizing data from multiple sources to provide users with a unified view. There are a wide range of possible applications for data integration, from commercial (such as when a ...

processes in

business intelligence Business intelligence (BI) consists of strategies, methodologies, and technologies used by enterprises for data analysis and management of business information. Common functions of BI technologies include Financial reporting, reporting, online an ...

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 Business intelligence, reporting and data analysis and is a core component of business intelligence. Data warehouses are central Re ...

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 decommi ...

from

legacy system Legacy or Legacies may refer to: Arts and entertainment Comics * " Batman: Legacy", a 1996 Batman storyline * '' DC Universe: Legacies'', a comic book series from DC Comics * ''Legacy'', a 1999 quarterly series from Antarctic Press * ''Legacy ...

s. Further it offers capabilities for relational,

dimensional In physics and mathematics, the dimension of a mathematical space (or object) is informally defined as the minimum number of coordinates needed to specify any point within it. Thus, a line has a dimension of one (1D) because only one coordi ...

and

metadata Metadata (or metainformation) is "data that provides information about other data", but not the content of the data itself, such as the text of a message or the image itself. There are many distinct types of metadata, including: * Descriptive ...

data modeling Data modeling in software engineering is the process of creating a data model for an information system by applying certain formal techniques. It may be applied as part of broader Model-driven engineering (MDE) concept. Overview Data modeli ...

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 identifying and correcting (or removing) corrupt, inaccurate, or irrelevant records from a dataset, table, or database. It involves detecting incomplete, incorrect, or inaccurate parts of the dat ...

and data auditing. Whereas the core functionality is part of the

Oracle database Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for ru ...

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 is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea (a part of Pacific Ocean) to the north. With a population of 156.9 million people (including Madura) in mid 2024, proje ...

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 sinc ...

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 Oracle Corporation is an American multinational computer technology company headquartered in Austin, Texas. Co-founded in 1977 in Santa Clara, California, by Larry Ellison, who remains executive chairman, Oracle was the third-largest softwa ...

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 Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for ru ...

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.

References

{{reflist

External links

Oracle Warehouse Builder official site (now integrated in Oracle Data Integrator)

Discussion forum

Oracle Warehouse Builder blog
2000 software Warehouse Builder Extract, transform, load tools Data warehousing products