TrustRadius
Oracle Warehouse Builder is a data integration solution, from Oracle.When to use Oracle Warehouse BuilderWe're using Oracle Warehouse Builder to offload data from Oracle databases, to transform and to load into operational reporting environment (operational data store) which is an another Oracle database. Oracle Warehouse Builder helps us to add meaning into operational raw data and to perform initial transformations for business users' requirements.,Easy transformation. Easy implementation from Oracle to Oracle systems. Ease of usage and easy to learn. Starting component of metadata management.,User experience. Supporting newer technologies. Ease of operation.,9,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.,Independent Oracle User Group New York Oracle User Group ODTUG Colombia Oracle Users Group Costa Rica Oracle Users Group Ecuador Oracle User Group Grupo de Usuarios Oracle El Salvadore Oracle User Group Guatemala Oracle User Group Mexico Panama Oracle User Group Azerbeidzjan Oracle User Group Bulgarian Oracle User Group German Oracle User Group Oracle Gebruikersclub Holland Oracle User Group Finland Oracle User Group Norway Slovenian Oracle User Group (SIOUG) TROUG Turkish Oracle User Group Turkey Oracle User Group UK Oracle User Group All India Oracle User Group,Oracle Data Integrator, Oracle Enterprise Data Quality and Oracle GoldenGate,Oracle Data Integrator, Oracle GoldenGate, Oracle Enterprise Data Quality, Oracle Database, Oracle Database 12c, Oracle Database as a Service, Oracle Exadata Database Machine, SAP PowerDesignerOverall OWB is a great tool for small to medium warehousing projectsIt's used only within one department.,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.,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.,8,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.,,Informatica Enterprise Data Integration, Informatica Data QualityOccasional user's reviewIt 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.,7,It improved understanding of ETL functions. Data is consistent. The speed is pretty good.Oracle Warehouse BuilderI have used Oracle Warehouse Builder for implementation of Data Extraction, Transformation and Load in my Project. It was used in the Telecom department and is extremely useful for transforming data for building reports for business users and downstream systems. It is a pretty simple ETL tool that provides all viable options required for building reports for data analysis for business intelligence problems.,Simplified user interface with all required ETL functions Flexible and Efficient,Should include better automation for mapping transformations,8,Not sure.,,Not Sure,Price Product Features Product Usability Vendor Reputation
Unspecified
Oracle Warehouse Builder
17 Ratings
Score 8.4 out of 101
TRScore

Oracle Warehouse Builder Reviews

Oracle Warehouse Builder
17 Ratings
Score 8.4 out of 101
Show Filters 
Hide Filters 
Filter 17 vetted Oracle Warehouse Builder reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-4 of 4)
  Vendors can't alter or remove reviews. Here's why.
Gurcan Orhan profile photo
April 14, 2018

User Review: "When to use Oracle Warehouse Builder"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We're using Oracle Warehouse Builder to offload data from Oracle databases, to transform and to load into operational reporting environment (operational data store) which is an another Oracle Database.
Oracle Warehouse Builder helps us to add meaning into operational raw data and to perform initial transformations for business users' requirements.
  • Easy transformation.
  • Easy implementation from Oracle to Oracle systems.
  • Ease of usage and easy to learn.
  • Starting component of metadata management.
  • User experience.
  • Supporting newer technologies.
  • Ease of operation.
If you plan to upgrade your databases to newer versions, you need to migrate your Oracle Warehouse Builder jobs to Oracle Data Integrator (fastest and easiest way) or an other ETL tool, because Oracle Warehouse Builder came to an end and does not support newer versions of databases as it is described in statement of direction.
There will be no major releases of Oracle Warehouse Builder (latest
release is 11GR2 - 11.2.0.4), but bug resolving and minor releasing will continue.
Read Gurcan Orhan's full review
Kate Nadolinski profile photo
March 28, 2017

Oracle Warehouse Builder Review: "Overall OWB is a great tool for small to medium warehousing projects"

Score 8 out of 10
Vetted Review
Verified User
Review Source
It's used only within one department.
  • 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.
  • 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.
Oracle Warehouse Builder (OWB) is best used for small to middle warehousing projects. In the past, it had a disadvantage compared to other ETL tools (like Informatica) working with non-Oracle sources or targets, but this was improved during the latest releases.
Read Kate Nadolinski's full review
Dina Britan profile photo
May 23, 2016

Oracle Warehouse Builder: "Occasional user's review"

Score 7 out of 10
Vetted Review
Verified User
Review Source
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.
If the data volume is big it is a good tool. In my organization the database it is used for is very small.
Read Dina Britan's full review
No photo available
May 27, 2016

User Review: "Oracle Warehouse Builder"

Score 8 out of 10
Vetted Review
Verified User
Review Source
I have used Oracle Warehouse Builder for implementation of Data Extraction, Transformation and Load in my Project. It was used in the Telecom department and is extremely useful for transforming data for building reports for business users and downstream systems. It is a pretty simple ETL tool that provides all viable options required for building reports for data analysis for business intelligence problems.
  • Simplified user interface with all required ETL functions
  • Flexible and Efficient
  • Should include better automation for mapping transformations
Well suited to address simple and straight forward business problems. Has room for improvement from automation perspective and complex data transformation functions.
Read this authenticated review

Oracle Warehouse Builder Scorecard Summary

Feature Scorecard Summary

Connect to traditional data sources (4)
8.6
Connecto to Big Data and NoSQL (1)
6
Simple transformations (4)
9.9
Complex transformations (3)
8.6
Data model creation (3)
5.2
Metadata management (3)
5.2
Business rules and workflow (3)
5.1
Collaboration (4)
7.9
Testing and debugging (3)
7.9
Integration with data quality tools (2)
7.5
Integration with MDM tools (1)
8

About Oracle Warehouse Builder

Oracle Warehouse Builder is a data integration solution, from Oracle.
Categories:  Data Integration

Oracle Warehouse Builder Technical Details

Operating Systems: Unspecified
Mobile Application:No