Oracle Warehouse Builder (OWB) enables you to take raw data, typically in different formats and disparate systems, and transform it into high-quality information that’s optimized for business reporting and analytics. With a single, easy-to-use interface, Oracle Warehouse Builder (OWB) allows you to design ETL processes between target warehouses, intermediate storage areas and the end user.
Which features does Oracle Warehouse Builder (OWB) support?
If you want to know how Oracle Warehouse Builder (OWB) scores on different selection criteria and exactly which functionality it provides. We did all the work for you. Vendors will often tell you only the strengths of their product(s). In our vendor independent survey, all the features are revealed and discussed, including the weak points. Why buy our survey?
Review of OWB in our survey (PARTIAL results)
- Basic functionality
- Future prospects
"In some ways, Oracle found itself in a comfortable position, as many data warehouses run on Oracle databases. In the past, many developers tended to program their data warehouses in SQL. By marketing an ETL tool that generates the SQL code, Oracle had saved developers a great deal of work and made things much easier for them, but the product was restricted to the Oracle customer base and that does not match Oracle’s new philosophy – to have the best product in each marketplace." Read more in our 100% vendor neutral ETL Tools & Data Integration Survey.
Information from the vendor
At that time the best ETL tool
Oracle Warehouse Builder was one of the first ETL tools that was included in the ETL study carried out by the research and consultancy agency Passionned Group. Based on the results of the study, Oracle Warehouse Builder was singled out at that time as the best ETL tool and left the established market leaders standing. Now OWB will be replaced by Oracle Data Integrator.
Functionally complete ETL tool
Oracle Warehouse Builder (OWB) is a user-friendly and functionally complete ETL tool that supports virtually all aspects of BI and data warehousing. Examples include (virtually) automatic creation of history, impact analysis, data lineage, real-time processing, defining slowly changing dimensions with one mouse click, on-demand data integration and management, and setting up a semantic layer, data profiling and automatic documentation. OWB offers good support from a software development perspective providing functionality such as reusability of components and loading procedures, error detection, a complier and a graphic breakdown of the ETL process.
Broad native support for multiple databases
Oracle Warehouse Builder provides connectivity to most of the important data sources. However, it does not offer as broad a native support for multiple database types and flavors as some other ETL tools since it uses ODBC to provide the connectivity. OWB provides support for most platforms and operating systems.
The following positive characteristics stand out:
- Out-of-the-box support for slowly changing dimensions, building history, star schema and snowflake diagrams. Many ETL tools lack support for this methodology (which then has to be programmed manually) or provide support in the form of a wizard. In the latter case, ETL procedures can be created that are difficult to maintain.
- Extensive support for error detection: Not only does OWB contain features for processing data row by row but each substep can be performed separately. The integrated compiler contributes to an error-free, stable and well performing ETL process. It detects errors that occur frequently or illogical transformations even before an ETL process goes into production.
- Impact analysis and data lineage: users are given a graphical overview of the dependencies between data and ETL processes. In this way, the maintainability of the data warehouse is vastly improved. Not all ETL tools offer both possibilities. In a complete Oracle environment, this can be used from source systems to reporting systems and vice versa.
- Real-time data integration: OWB is able to process real-time data in various ways, namely by means of Message Queuing (with Oracle AQ, which handles the connectivity with either IBM Message Queuing or Tibco), database logs and database triggers. This is unusual and offers users many possibilities for gaining real-time transparency in business process performance (Business Activity Monitoring).
- Key-lookups in memory are reusable and can kept in memory: OWB lets users indicate whether dimension tables should be kept in memory for the entire loading process. This can reduce the time necessary to load data warehouses containing sizeable dimension tables by up to 20%. However, it would be better if Oracle were to offer this functionality in a more user-friendly way.
- Modeling and managing the data model: OWB is capable of managing all the metadata of the data warehouse. A logical data model is defined, after which a physical implementation can be chosen. Users can opt for a relational implementation of a star schema, a snowflake diagram or a combination of both, or a multi-dimensional (olap) implementation based on Oracle OLAP.
Oracle has a clear vision
Rick van der Linden, senior analyst and author of the ETL Tools & Data Integration Survey said about OWB: “Oracle has a clear vision of data integration, and had continued to improve its ETL tool OWB but that has now stopped with all the effort being put into Oracle Data Integrator. “ Find out more and order now the ETL Tools & Data Integration Survey 2017.
100% vendor independent research
In the ETL Tools & Data Integration Survey 2017 you’ll find the list of ETL tools in the market, including for each ETL tool an expert review, many comparison graphs and a comparison matrix with all the data. And a thorough 100% vendor independent evaluation of Oracle Warehouse Builder (OWB) with all their features.