We performed a comparison between IBM InfoSphere DataStage, Oracle Data Integrator (ODI), and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It is quite useful and powerful."
"We are mostly using transmission rules. It has a lot of functions and logic related to transmission. It is a user-friendly tool with in-built functions."
"IBM is stable and accurate to monitor. It's easy to understand to monitor the data lineage from source to target."
"The data lineage report can be filtered for reporting. The reports are user-friendly and take less time to find what you need."
"The ETL tools are probably the most valuable feature. It has an IBM tool, a friendly UI and it makes things more comfortable."
"The Hierarchical Data Stage is good."
"The best feature of IBM InfoSphere DataStage for me was that it was very much user-friendly. The solution didn't require that much raw coding because most of its features were drag and drop, plus it had a large number of functionalities."
"I am impressed with the tool's ETL tracing."
"It has the ability to easily load slowly changing dimensions."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"It is an ETL tool, which does the extract, transform, and load."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The installation of the client ODI Studio is easy."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"It has a built-in automatic scheduling environment."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"The tool supports multiple target update methods."
"Support is absolutely excellent, efficient, and timely."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"I'd like to be able to do more with the data and metadata, including copy and pasting, et cetera."
"The troubleshooting guide is very bad."
"The documentation and in-application help for this solution need to be improved, especially for new features."
"The graphical user interface (GUI) feels a lot like the interfaces from the 1980s."
"DataStage is quite expensive. It is too hard to find a consultant using DataStage in Turkey."
"It would be great if they can include some basic version of data quality checking features."
"There are three things that could improve - the cloud, monitoring and cloud integration. It's a solid product but not a modern one and of course it depends what you're looking for."
"The error messaging needs to be improved."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"Stability could be improved because some operators have issues."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"Technical support isn't the best."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"Improve the object renaming ability (it works, but it could be more automated)."
"No support for change data capture or delta detection - that must be custom coded ."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
Earn 20 points