TrustRadius: an HG Insights company

Oracle Warehouse Builder

Score8.7 out of 10

20 Reviews and Ratings

Get a Demo

What is Oracle Warehouse Builder?

Oracle Warehouse Builder (OWB) is a data-warehousing centered data integration solution, from Oracle. It offers basic ETL functionality for building a simple data warehouse, as well as advanced ETL functionality supporting enterprise data integration projects, along with connectivity for Oracle and SAP applications.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features Oracle Warehouse Builder has to offer, as determined by TrustRadius' reviewers.
Based on 20 ratings of Oracle Warehouse Builder's features
View all features

Top Performing Features

  • Connect to traditional data sources

    Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

    Category average: 8.7

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.1

  • Complex transformations

    Complex data transformations are data normalization, advanced data parsing, etc.

    Category average: 7.2

Areas for Improvement

  • Integration with MDM tools

    Integration with master data management tools to ensure data consistency across the organization

    Category average: 7.8

  • Testing and debugging

    Tool to debug and tune for optimal performance

    Category average: 6.9

  • Metadata management

    Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management

    Category average: 7.9

Reviews

What users are saying about Oracle Warehouse Builder.
View all reviews

When to use Oracle Warehouse Builder

Incentivized
Gurcan OrhanView profile
Enterprise Data WareHouse Architect in Information Technology at Ekol Logistics (5001-10,000 employees employees)

Pros

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

Cons

  • User experience.
  • Supporting newer technologies.
  • Ease of operation.

Return on Investment

  • Oracle Warehouse Builder is coming out of the box with Oracle Database Release 11G and it is free to use.
  • Oracle Warehouse Builder Enterprise Edition can be bought to extend its capabilities.
  • Oracle Warehouse Builder is coming to the end of life, so you need to be careful about selecting.

Alternatives Considered

Oracle Data Integrator, Oracle Enterprise Data Quality and Oracle GoldenGate

Other Software Used

Oracle Data Integrator, Oracle GoldenGate, Oracle Enterprise Data Quality, Oracle Database, Oracle Database 12c, Oracle Database as a Service, Oracle Exadata Database Machine, SAP PowerDesigner

Overall OWB is a great tool for small to medium warehousing projects

Incentivized
Kate NadolinskiView profile
Senior Consultant in Finance and Accounting at CACI International Inc (10,001+ employees employees)

Pros

  • OWB has a very nice performance of ETL processing, as it uses Oracle database as a transformation engine. It's very intuitive and easy to use tool.

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.

Return on Investment

  • OWB allows you to quickly develop even complex ETLs thus saving lots of time for the developers to work on other things. I would say OWB is a very convenient and easy to use tool.

Other Software Used

Informatica Enterprise Data Integration, Informatica Data Quality

What I like about Oracle Warehouse Builder

Incentivized
Verified User
Consultant in Information Technology (10,001+ employees employees)

Pros

  • Connects to random sources
  • User friendly

Cons

  • Variables are kinda clunky
  • Auto population

Return on Investment

  • Cleans up randomness
  • Creates a place for rules of transformation

Alternatives Considered

Oracle Data Integrator

Other Software Used

Oracle Data Integrator

Occasional user's review

Incentivized
Dina BritanView profile
SIS Lead Analyst in Information Technology at SUNY Downstate Medical Center (1001-5000 employees employees)

Pros

  • It is very well structured.
  • It creates pl/sql codes without the need to do it manually.
  • The visual design is pretty good.

Cons

  • No good learning material available.
  • I didn't see a training course for it.
  • It is not easy to learn.

Return on Investment

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

Oracle Warehouse Builder

Incentivized
Verified User
Executive in Information Technology (10,001+ employees employees)

Pros

  • Simplified user interface with all required ETL functions
  • Flexible and Efficient

Cons

  • Should include better automation for mapping transformations

Return on Investment

  • Not sure.

Related Products

Products similar to Oracle Warehouse Builder that may also meet your needs.
All comparisons
Talend Data Integration
CompareLearn more
IBM DataStage
CompareLearn more
Azure Data Factory
CompareLearn more