Occasional user's review
May 23, 2016

Occasional user's review

Dina Britan | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Warehouse Builder

It is used for bringing data from a production database to a reporting database. Oracle Warehouse Builded (OWB) was supplied by Ellucian when the Banner production system was installed. It is mostly maintained by another company that is the outsourcing company for us - SICAS, but I use OWB to update some objects that are created locally for some specific business needs.
  • It is very well structured.
  • It creates pl/sql codes without the need to do it manually.
  • The visual design is pretty good.
  • No good learning material available.
  • I didn't see a training course for it.
  • It is not easy to learn.
  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
If the data volume is big it is a good tool. In my organization the database it is used for is very small.

Oracle Warehouse Builder Feature Ratings

Connect to traditional data sources
8
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
7
Complex transformations
Not Rated
Data model creation
7
Metadata management
7
Business rules and workflow
7
Collaboration
7
Testing and debugging
Not Rated
Integration with data quality tools
7
Integration with MDM tools
Not Rated