IBM DataStage vs. Oracle Warehouse Builder

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
IBM DataStage
Score 8.6 out of 10
N/A
IBM® DataStage® is a data integration tool that helps users to design, develop and run jobs that move and transform data. At its core, the DataStage tool supports extract, transform and load (ETL) and extract, load and transform (ELT) patterns. A basic version of the software is available for on-premises deployment, and the cloud-based DataStage for IBM Cloud Pak® for Data offers automated integration capabilities in a hybrid or multicloud environment.N/A
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
IBM DataStageOracle Warehouse Builder
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
IBM DataStageOracle Warehouse Builder
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Features
IBM DataStageOracle Warehouse Builder
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
IBM DataStage
9.1
9 Ratings
10% above category average
Oracle Warehouse Builder
9.5
5 Ratings
15% above category average
Connect to traditional data sources9.59 Ratings10.05 Ratings
Connecto to Big Data and NoSQL8.88 Ratings9.02 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
IBM DataStage
9.5
9 Ratings
13% above category average
Oracle Warehouse Builder
10.0
5 Ratings
18% above category average
Simple transformations9.89 Ratings10.05 Ratings
Complex transformations9.39 Ratings10.04 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
IBM DataStage
9.0
9 Ratings
10% above category average
Oracle Warehouse Builder
8.2
5 Ratings
1% above category average
Data model creation9.36 Ratings10.04 Ratings
Metadata management8.78 Ratings6.04 Ratings
Business rules and workflow8.18 Ratings9.04 Ratings
Collaboration9.09 Ratings8.94 Ratings
Testing and debugging9.59 Ratings7.04 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
IBM DataStage
8.9
8 Ratings
8% above category average
Oracle Warehouse Builder
8.0
3 Ratings
3% below category average
Integration with data quality tools8.88 Ratings8.03 Ratings
Integration with MDM tools9.08 Ratings8.02 Ratings
Best Alternatives
IBM DataStageOracle Warehouse Builder
Small Businesses
Skyvia
Skyvia
Score 9.6 out of 10
Skyvia
Skyvia
Score 9.6 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
IBM DataStageOracle Warehouse Builder
Likelihood to Recommend
8.8
(9 ratings)
8.0
(5 ratings)
Usability
9.0
(2 ratings)
-
(0 ratings)
Performance
9.0
(1 ratings)
-
(0 ratings)
Support Rating
9.6
(3 ratings)
-
(0 ratings)
User Testimonials
IBM DataStageOracle Warehouse Builder
Likelihood to Recommend
IBM
Excellent Cloud data mapping tool and easy creating multiple project data analytics in real-time and the report distribution are excellent via this IBM product. Easy tool to provide data visualization and the integration is effective and helpful to migrating huge amounts of data across other platforms and different websites insights gathering.
Read full review
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
IBM
  • Data movement
  • Seamless integration of scripts and etl jobs
  • Descriptive logging
  • Ability to work with myriad of data assets
  • Direct integration for Governance catalog
Read full review
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
IBM
  • Connector Stages to Snowflake on the cloud. We had some issues initially but since then had been corrected.
  • Accessing tool from a browser (zero foot-print). Currently we need to either install locally or connect to a server to do ETL work.
  • Diversify ways of authenticating users.
Read full review
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
Usability
IBM
Because it is robust, and it is being continuously improved. DS is one of the most used and recognized tools in the market. Large companies have implemented it in the first instance to develop their DW, but finding the advantages it has, they could use it for other types of projects such as migrations, application feeding, etc.
Read full review
Oracle
No answers on this topic
Performance
IBM
It could load thousands of records in seconds. But in the Parallel version, you need to understand how to particionate the data. If you use the algorithms erroneously, or the functionalities that it gives for the parsing of data, the performance can fall drastically, even with few records. It is necessary to have people with experience to be able to determine which algorithm to use and understand why.
Read full review
Oracle
No answers on this topic
Support Rating
IBM
I believe that IBM generally has one of the worst and most complex assistance systems (physical and online) that exists.
Read full review
Oracle
No answers on this topic
Alternatives Considered
IBM
It's obvious since they both are from the same vendors and it makes it easier and can get better rates for licensing. Also, sales rapes are very helpful in case of escalations and critical issues.
Read full review
Oracle
Ab>initio, IBM Datastage 8.0
Read full review
Return on Investment
IBM
  • Reduce development time by 65% compared with hand coding.
  • Reduces ETL process maintenance times.
  • Better data governance for technical and non-technical people.
  • Improve time to market for initiatives that require data integration.
Read full review
Oracle
  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
Read full review
ScreenShots