Oracle Warehouse Builder

Last updated
Mapping editor in Oracle Warehouse Builder 11g OWB t10102.gif
Mapping editor in Oracle Warehouse Builder 11g

Oracle Warehouse Builder (OWB) is an ETL tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.

Contents

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. OWB uses a variant of Tcl over Java and PL/SQL 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. [1]

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. [1] [2]

Future integration with Oracle Data Integrator

As of 2008, 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. [1] Oracle has publicly commented on plans to release a data integration product that will unify features from both of the current offerings. [1]

UPDATE: According to 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.

Use older versions of Oracle documentation

Think lists

Related Research Articles

Berkeley DB (BDB) is an embedded database software library for key/value data, historically significant in open-source software. Berkeley DB is written in C with API bindings for many other programming languages. BDB stores arbitrary key/data pairs as byte arrays and supports multiple data items for a single key. Berkeley DB is not a relational database, although it has database features including database transactions, multiversion concurrency control and write-ahead logging. BDB runs on a wide variety of operating systems, including most Unix-like and Windows systems, and real-time operating systems.

<span class="mw-page-title-main">Extract, transform, load</span> Procedure in computing

Extract, transform, load (ETL) is a three-phase computing process where data is extracted from an input source, transformed, and loaded into an output data container. The data can be collated from one or more sources and it can also be output to one or more destinations. ETL processing is typically executed using software applications but it can also be done manually by system operators. ETL software typically automates the entire process and can be run manually or on recurring schedules either as single jobs or aggregated into a batch of jobs.

Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation.

Oracle Forms is a software product for creating screens that interact with an Oracle database. It has an IDE that includes an object navigator, property sheet, and code editor that uses PL/SQL. It was originally developed to run server-side in character-mode terminal sessions. It was ported to other platforms, including Windows, to function in a client–server environment. Later versions were ported to Java where it runs in a Java EE container and can integrate with Java, and web services that can be launched from a URL. Recent versions provide a means to run the forms from a desktop computer without requiring a browser.

<span class="mw-page-title-main">JDeveloper</span> Integrated development environment

JDeveloper is a freeware IDE supplied by Oracle Corporation. It offers features for development in Java, XML, SQL and PL/SQL, HTML, JavaScript, BPEL and PHP. JDeveloper covers the full development lifecycle from design through coding, debugging, optimization and profiling to deploying.

SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers.

In database computing, Oracle Real Application Clusters (RAC) — an option for the Oracle Database software produced by Oracle Corporation and introduced in 2001 with Oracle9i — provides software for clustering and high availability in Oracle database environments. Oracle Corporation includes RAC with the Enterprise Edition, provided the nodes are clustered using Oracle Clusterware.

SAP PowerDesigner is a collaborative enterprise modelling tool produced by Sybase, currently owned by SAP. It can run either under Microsoft Windows as a native application or in an Eclipse environment through a plugin. It supports model-driven architecture software design, and stores models using a variety of file extensions, such as .bpm, .cdm and .pdm. The internal file structure can be either XML or a compressed binary file format. It can also store models in a database repository.

Oracle Spatial and Graph, formerly Oracle Spatial, is a free option component of the Oracle Database. The spatial features in Oracle Spatial and Graph aid users in managing geographic and location-data in a native type within an Oracle database, potentially supporting a wide range of applications — from automated mapping, facilities management, and geographic information systems (AM/FM/GIS), to wireless location services and location-enabled e-business. The graph features in Oracle Spatial and Graph include Oracle Network Data Model (NDM) graphs used in traditional network applications in major transportation, telcos, utilities and energy organizations and RDF semantic graphs used in social networks and social interactions and in linking disparate data sets to address requirements from the research, health sciences, finance, media and intelligence communities.

Oracle Multimedia is a feature available for Oracle databases, which provides multimedia utilities in a database environment, generating as a result a multimedia database (MMDB). Oracle Multimedia was deprecated in Oracle 18c and desupported in Oracle 19c.

ER/Studio is data architecture and database design software developed by IDERA, Inc. ER/Studio is compatible with multiple database platforms and is used to create and manage database designs, as well as to document and reuse data assets. In 2015, Embarcadero Technologies was acquired by database and infrastructure management software company IDERA, Inc. Since the acquisition by IDERA, Inc., ER/Studio has been renamed to ER/Studio Data Architect with updated features.

The Oracle Database OLAP Option implements On-line Analytical Processing (OLAP) within an Oracle database environment. Oracle Corporation markets the Oracle Database OLAP Option as an extra-cost option to supplement the "Enterprise Edition" of its database.

Oracle Data Mining (ODM) is an option of Oracle Database Enterprise Edition. It contains several data mining and data analysis algorithms for classification, prediction, regression, associations, feature selection, anomaly detection, feature extraction, and specialized analytics. It provides means for the creation, management and operational deployment of data mining models inside the database environment.

Oracle WebCenter is Oracle's portfolio of user engagement software products built on top of the JSF-based Oracle Application Development Framework. There are three main products that make up the WebCenter portfolio, and they can be purchased together as a suite or individually:

RMAN is a backup and recovery manager supplied for Oracle databases created by the Oracle Corporation. It provides database backup, restore, and recovery capabilities addressing high availability and disaster recovery concerns. Oracle Corporation recommends RMAN as its preferred method for backup and recovery and has written command-line and graphical interfaces for the product.

Transparent Data Encryption is a technology employed by Microsoft, IBM and Oracle to encrypt database files. TDE offers encryption at file level. TDE enables the encryption of data at rest, encrypting databases both on the hard drive and consequently on backup media. It does not protect data in transit nor data in use. Enterprises typically employ TDE to solve compliance issues such as PCI DSS which require the protection of data at rest.

Oracle WebLogic Server is a Java EE application server currently developed by Oracle Corporation. Oracle acquired WebLogic Server when it purchased BEA Systems in 2008.

Oracle Data Integrator (ODI) is an extract, load, transform (ELT) tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.

SQL:2011 or ISO/IEC 9075:2011 is the seventh revision of the ISO (1987) and ANSI (1986) standard for the SQL database query language. It was formally adopted in December 2011. The standard consists of 9 parts which are described in detail in SQL. The next version is SQL:2016.

Informix Corporation, formerly Informix Software, Inc., was a software company located in Menlo Park, California. It was a developer of relational database software for computers using the Unix, Microsoft Windows, and Apple Macintosh operating systems.

References

  1. 1 2 3 4 "Oracle Warehouse Builder Product Roadmap" (PDF). Oracle Corporation. July 2008. Retrieved 2009-04-15.
  2. "Oracle Data Integrator and Oracle Warehouse Builder - Statement of Direction" (PDF). Oracle Corporation. January 2010. Retrieved 2010-04-22.