Oracle Warehouse Builder vs. Toad Data Modeler

Oracle Warehouse Builder

Toad Data Modeler

Overview
Product	Rating	Most Used By	Product Summary	Starting 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
Toad Data Modeler	Score 0.0 out of 10	N/A	A cross-platform database modeling software used to create data models. Toad Data Modeler is used to deploy changes to data structures across more than 20 different platforms, and to construct logical and physical data models, compare and synchronize models, generate complex SQL/DDL, create and modify database schema and scripts, as well as reverse and forward engineer both databases and data warehouse systems. Toad's database modeling tools ultimately aim to simplify design, maintenance and…	N/A

Pricing

Oracle Warehouse Builder

Toad Data Modeler

Editions & Modules

No answers on this topic

Offerings

Pricing Offerings
Oracle Warehouse Builder	Toad Data Modeler
Free Trial
No	No
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

No setup fee

Additional Details

—

More Pricing Information

Community Pulse
	Oracle Warehouse Builder	Toad Data Modeler

Features

Oracle Warehouse Builder

Toad Data Modeler

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	Oracle Warehouse Builder 9.5 5 Ratings 14% above category average	Toad Data Modeler - Ratings
Connect to traditional data sources	10.05 Ratings	00 Ratings
Connecto to Big Data and NoSQL	9.02 Ratings	00 Ratings

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	Oracle Warehouse Builder 10.0 5 Ratings 21% above category average	Toad Data Modeler - Ratings
Simple transformations	10.05 Ratings	00 Ratings
Complex transformations	10.04 Ratings	00 Ratings

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	Oracle Warehouse Builder 8.2 5 Ratings 5% above category average	Toad Data Modeler - Ratings
Data model creation	10.04 Ratings	00 Ratings
Metadata management	6.04 Ratings	00 Ratings
Business rules and workflow	9.04 Ratings	00 Ratings
Collaboration	8.94 Ratings	00 Ratings
Testing and debugging	7.04 Ratings	00 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	Oracle Warehouse Builder 8.0 3 Ratings 1% above category average	Toad Data Modeler - Ratings
Integration with data quality tools	8.03 Ratings	00 Ratings
Integration with MDM tools	8.02 Ratings	00 Ratings

Best Alternatives
	Oracle Warehouse Builder	Toad Data Modeler
Small Businesses	Skyvia Score 10.0 out of 10	DBeaver Score 8.5 out of 10
Medium-sized Companies	IBM InfoSphere Information Server Score 8.0 out of 10	ER/Studio Score 9.9 out of 10
Enterprises	IBM InfoSphere Information Server Score 8.0 out of 10	ER/Studio Score 9.9 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	Oracle Warehouse Builder	Toad Data Modeler
Likelihood to Recommend	8.0 (5 ratings)	- (0 ratings)

User Testimonials
	Oracle Warehouse Builder	Toad Data Modeler
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. Incentivized Verified User Anonymous Read full review	Quest Software No answers on this topic
Pros	Oracle Easy transformation. Easy implementation from Oracle to Oracle systems. Ease of usage and easy to learn. Starting component of metadata management. Incentivized Gurcan Orhan Enterprise Data WareHouse Architect Read full review	Quest Software No answers on this topic
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. Incentivized KN Kate Nadolinski Senior Consultant Read full review	Quest Software No answers on this topic
Alternatives Considered	Oracle Ab>initio, IBM Datastage 8.0 Incentivized Verified User Anonymous Read full review	Quest Software No answers on this topic
Return on Investment	Oracle It improved understanding of ETL functions. Data is consistent. The speed is pretty good. Incentivized Dina Britan SIS Lead Analyst Read full review	Quest Software No answers on this topic
ScreenShots