Skip to main content
TrustRadius
Oracle Warehouse Builder

Oracle Warehouse Builder

Overview

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…

Read more
Recent Reviews
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 11 features
  • Connect to traditional data sources (5)
    10.0
    100%
  • Simple transformations (5)
    10.0
    100%
Return to navigation

Pricing

View all pricing
N/A
Unavailable

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…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

3 people also want pricing

Alternatives Pricing

What is Boomi?

Boomi is a cloud-based, on-premise, or hybrid integration platform. It offers a low-code/no-code interface with the capacity for API and EDI connections for integrating with external organizations and systems, as well as compliance with data protection regulations.

What is Dataloader.io?

Dataloader.io delivers a cloud based solution to import and export information from Salesforce.

Return to navigation

Product Demos

Oracle warehouse builder (OWB) interview FAQ

YouTube

Oracle warehouse builder || Oracle warehouse builder(OWB) Part - 23

YouTube

Oracle warehouse builder || Oracle warehouse builder(OWB) Part - 21

YouTube

Oracle warehouse builder || Oracle warehouse builder(OWB) Part - 24

YouTube

Oracle warehouse builder || Oracle warehouse builder(OWB) Part - 17

YouTube

Oracle warehouse builder || Oracle warehouse builder(OWB) Part - 25

YouTube
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

9.5
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

10
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

8.2
Avg 8.2

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

8
Avg 8.2
Return to navigation

Product Details

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.

Oracle Warehouse Builder Competitors

Oracle Warehouse Builder Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

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.

Azure Data Factory, IBM DataStage, and Talend Data Integration are common alternatives for Oracle Warehouse Builder.

Reviewers rate Connect to traditional data sources and Simple transformations and Complex transformations highest, with a score of 10.

The most common users of Oracle Warehouse Builder are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(20)

Reviews

(1-5 of 5)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We have been able to implement Oracle Warehouse Builder for a department and as an enterprise solution. We have used it for years to transform data and clean bad data. All this means is that we consolidate the random spreadsheets, home-grown applications, flat-files, and anything else that users can manage to produce randomly. We can bring that junk together and scrub it so it's not only in one place but clean, too.
  • Connects to random sources
  • User friendly
  • Variables are kinda clunky
  • Auto population
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.
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (4)
80%
8.0
Data model creation
100%
10.0
Metadata management
60%
6.0
Business rules and workflow
90%
9.0
Testing and debugging
70%
7.0
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
80%
8.0
  • Cleans up randomness
  • Creates a place for rules of transformation
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 heavy lifting and enterprise solution realm. ODI is much easier to implement at that level. The web interface that can be setup for business users to kick off scenarios is better than the interface that we can give access to in OWB.
Gurcan Orhan | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Data Source Connection (1)
100%
10.0
Connect to traditional data sources
100%
10.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (2)
90%
9.0
Collaboration
90%
9.0
Testing and debugging
90%
9.0
Data Governance
N/A
N/A
  • 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.
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 declared in statement of direction.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Data Source Connection (2)
25%
2.5
Connect to traditional data sources
50%
5.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
75%
7.5
Simple transformations
100%
10.0
Complex transformations
50%
5.0
Data Modeling (5)
50%
5.0
Data model creation
50%
5.0
Metadata management
50%
5.0
Business rules and workflow
50%
5.0
Collaboration
50%
5.0
Testing and debugging
50%
5.0
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
  • 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.
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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Data Source Connection (2)
70%
7.0
Connect to traditional data sources
80%
8.0
Connecto to Big Data and NoSQL
60%
6.0
Data Transformations (2)
80%
8.0
Simple transformations
80%
8.0
Complex transformations
80%
8.0
Data Modeling (5)
70%
7.0
Data model creation
70%
7.0
Metadata management
80%
8.0
Business rules and workflow
60%
6.0
Collaboration
70%
7.0
Testing and debugging
70%
7.0
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
80%
8.0
  • Not sure.
Ab>initio, IBM Datastage 8.0
Not Sure
  • Price
  • Product Features
  • Product Usability
  • Vendor Reputation
Dina Britan | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
Data Source Connection (2)
40%
4.0
Connect to traditional data sources
80%
8.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
35%
3.5
Simple transformations
70%
7.0
Complex transformations
N/A
N/A
Data Modeling (5)
56%
5.6
Data model creation
70%
7.0
Metadata management
70%
7.0
Business rules and workflow
70%
7.0
Collaboration
70%
7.0
Testing and debugging
N/A
N/A
Data Governance (2)
35%
3.5
Integration with data quality tools
70%
7.0
Integration with MDM tools
N/A
N/A
  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
Return to navigation