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 DataStage
Oracle Warehouse Builder
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
IBM DataStage
Oracle Warehouse Builder
Free Trial
Yes
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
IBM DataStage
Oracle Warehouse Builder
Features
IBM DataStage
Oracle Warehouse Builder
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
IBM DataStage
9.5
Ratings
12% above category average
Oracle Warehouse Builder
9.5
Ratings
12% above category average
Connect to traditional data sources
10.00 Ratings
10.00 Ratings
Connecto to Big Data and NoSQL
9.00 Ratings
9.00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
IBM DataStage
8.0
Ratings
2% below category average
Oracle Warehouse Builder
10.0
Ratings
20% above category average
Simple transformations
8.00 Ratings
10.00 Ratings
Complex transformations
8.00 Ratings
10.00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
IBM DataStage
6.3
Ratings
23% below category average
Oracle Warehouse Builder
8.2
Ratings
3% above category average
Data model creation
5.00 Ratings
10.00 Ratings
Metadata management
5.00 Ratings
6.00 Ratings
Business rules and workflow
6.00 Ratings
9.00 Ratings
Collaboration
6.00 Ratings
8.90 Ratings
Testing and debugging
6.00 Ratings
7.00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
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.
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.
Because it is a flexible tool that can manage many flows and create a strong solution with a interesting use of variables. Easy to scale up as you can copy jobs arleady build and modify them. SQL queries allow to be fast in development and have the pushdown feature, but you loose a little of user friendly look. Metadata management is not strong as a visual feature, but can be determine by job codes.
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.
IBM offers different levels of support but in my experience being and IBM shop helps to get direct support from more knowledgeable technicians from IBM. Not sure on the cost of having this kind of support, but I know there's also general support and community blogs and websites on the Internet make it easy to troubleshoot issues whenever there's need for that.
No, it wasn’t my decision to use such an ETL product. I’m just the administrator at this point. I’ve heard there are other products there that are even on cloud support. That is much easier to use, more agile, and user-friendly. That doesn’t have that barrier from user to administrator to the developer standpoint.
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.
Not directly related to ROI or cost figures. Only comment here is that IBM tools tend to be more costly than average ETL tools, but it depends on if the company is an IBM shop.
One positive aspect is the company has had not a need to switch ETL tool for years.
Upgrading to newer versions of the tool brings flexibility in the tool and up-to-date features in relation to other applications.
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.
