Oracle Warehouse Builder

Likelihood to Recommend

The best place for Oracle Warehouse Builder is at the business IT level. It's not suited for business-level users. They are easy confused. One way to reduce the confusion for the developers is to set up the workspaces based on the requirements that are discovered in design sessions. Once this is complete, the implementation of Oracle Warehouse Builder can take flight and be successful.

Read full review

Verified User

Consultant in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 5 answers on this topic

Feature Rating Comparison

Oracle Warehouse Builder

Connect to traditional data sources

Connecto to Big Data and NoSQL

Oracle Warehouse Builder

Simple transformations

Complex transformations

Oracle Warehouse Builder

Data model creation

Metadata management

Business rules and workflow

Collaboration

Testing and debugging

Oracle Warehouse Builder

Integration with data quality tools

Integration with MDM tools

Pros

Easy transformation.
Easy implementation from Oracle to Oracle systems.
Ease of usage and easy to learn.
Starting component of metadata management.

Read full review

Gurcan Orhan

Enterprise Data WareHouse Architect

Ekol LogisticsLogistics and Supply Chain, 5001-10,000 employees

View all 5 answers on this topic

Cons

What I noticed is that sometimes OWB doesn't generate the best SQL in the package especially when there are a high number of source tables in the ETL. It would be nice if ETL developers were allowed to update the generated packages in the database directly.
Another thing - moving OWB ETLs from one database to another one could be easier - for example it would be nice to just copy the generated packages from one database to the other one without doing the deployment of these ETLs through OWB.

Read full review

Kate Nadolinski

Senior Consultant

CACI International IncComputer Software, 10,001+ employees

View all 5 answers on this topic

Alternatives Considered

Ab>initio, IBM Datastage 8.0

Read full review

Verified User

Executive in Information Technology

Telecommunications Company, 10,001+ employees

View all 5 answers on this topic

Return on Investment

It improved understanding of ETL functions. Data is consistent. The speed is pretty good.

Read full review

Dina Britan

SIS Lead Analyst

SUNY Downstate Medical CenterHospital & Health Care, 1001-5000 employees

View all 5 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Rating Summary

Oracle Warehouse Builder

Oracle Warehouse Builder