What I like about Oracle Warehouse Builder
January 19, 2020
We have been able to implement Oracle Warehouse Builder for a department and as an enterprise solution. We have used it for years to …
Oracle Warehouse Builder
Oracle Warehouse Builder
Overview
Recent Reviews
Popular Features
View all 11 featuresConnect to traditional data sources (5)
10.0
100%
Simple transformations (5)
10.0
100%
Video Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Oracle Warehouse Builder, and make your voice heard!
Pricing
View all pricingN/A
Unavailable
What is Oracle Warehouse Builder?
Oracle Warehouse Builder is a data integration solution, from Oracle.
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?
Alternatives Pricing
What is Oracle GoldenGate?
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
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.
Features Scorecard
Data Source Connection
9.5
95%
Data Transformations
10.0
100%
Data Modeling
8.2
82%
Data Governance
8.0
80%
Product Details
What is Oracle Warehouse Builder?
Oracle Warehouse Builder is a data integration solution, from Oracle.
Oracle Warehouse Builder Competitors
Oracle Warehouse Builder Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
View all alternatives
Frequently Asked Questions
What is Oracle Warehouse Builder?
Oracle Warehouse Builder is a data integration solution, from Oracle.
What are Oracle Warehouse Builder's top competitors?
Azure Data Factory, IBM InfoSphere DataStage, and Talend Data Integration are common alternatives for Oracle Warehouse Builder.
What is Oracle Warehouse Builder's best feature?
Reviewers rate Connect to traditional data sources and Simple transformations and Complex transformations highest, with a score of 10.
Who uses Oracle Warehouse Builder?
The most common users of Oracle Warehouse Builder are from Enterprises (1,001+ employees) and the Unknown industry.
Reviews and Ratings
 (21)
Reviews
(1-5 of 5)- Popular Filters
Companies can't remove reviews or game the system. Here's why
January 19, 2020
What I like about Oracle Warehouse Builder
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
No
April 14, 2018
When to use Oracle Warehouse Builder
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.
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.
Yes
I am a member of the 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 and All India Oracle User Group.
I am annually attending Oracle User Group conferences and one of my favorite topic is 'Migration Steps from OWB to ODI to ODIPC' and I share my experiences with conference attendees.
I am annually attending Oracle User Group conferences and one of my favorite topic is 'Migration Steps from OWB to ODI to ODIPC' and I share my experiences with conference attendees.
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.
May 27, 2016
Oracle Warehouse Builder
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
May 23, 2016
Occasional user's review
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.