Oracle Warehouse Builder

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Oracle Warehouse Builder
Score 8.7 out of 10
N/A
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.N/A
Pricing
Oracle Warehouse Builder
Editions & Modules
No answers on this topic
Offerings
Pricing Offerings
Oracle Warehouse Builder
Free Trial
No
Free/Freemium Version
No
Premium Consulting/Integration Services
No
Entry-level Setup FeeNo setup fee
Additional Details—
More Pricing Information
Community Pulse
Oracle Warehouse Builder
Considered Both Products
Oracle Warehouse Builder
Chose Oracle Warehouse Builder
I think that Oracle Warehouse Builder is easier to use the Oracle Data Integrator (ODI). The connections in Oracle Warehouse Builder (OWB) are easier to understand when troubleshooting. Anything that makes troubleshooting easier gets higher marks in my book. ODI wins in the …
Chose Oracle Warehouse Builder
Depending on investment, I would prefer Oracle Data Integrator, since it complies with all versions of all types of databases including Big Data, Hadoop and NoSQL environment as well as the cloud and is the strategic heterogenous data integration product of Oracle, as it is …
Chose Oracle Warehouse Builder
Currently we work with Informatica and compared to OWB Informatica is a little bit more difficult to use, however Informatica has more features and is a more powerful BI tool.
Chose Oracle Warehouse Builder
Ab>initio, IBM Datastage 8.0
Top Pros
Top Cons
Features
Oracle Warehouse Builder
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Oracle Warehouse Builder
9.5
5 Ratings
15% above category average
Connect to traditional data sources10.05 Ratings
Connecto to Big Data and NoSQL9.02 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Oracle Warehouse Builder
10.0
5 Ratings
18% above category average
Simple transformations10.05 Ratings
Complex transformations10.04 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Oracle Warehouse Builder
8.2
5 Ratings
1% above category average
Data model creation10.04 Ratings
Metadata management6.04 Ratings
Business rules and workflow9.04 Ratings
Collaboration8.94 Ratings
Testing and debugging7.04 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Oracle Warehouse Builder
8.0
3 Ratings
3% below category average
Integration with data quality tools8.03 Ratings
Integration with MDM tools8.02 Ratings
Best Alternatives
Oracle Warehouse Builder
Small Businesses
Skyvia
Skyvia
Score 9.6 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
All AlternativesView all alternatives
User Ratings
Oracle Warehouse Builder
Likelihood to Recommend
8.0
(5 ratings)
User Testimonials
Oracle Warehouse Builder
Likelihood to Recommend
Oracle
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
Pros
Oracle
  • Easy transformation.
  • Easy implementation from Oracle to Oracle systems.
  • Ease of usage and easy to learn.
  • Starting component of metadata management.
Read full review
Cons
Oracle
  • 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
Alternatives Considered
Oracle
Ab>initio, IBM Datastage 8.0
Read full review
Return on Investment
Oracle
  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
Read full review
ScreenShots