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."The concept of integration is a valuable feature of the product."
"The solution is stable."
"IBM is stable and accurate to monitor. It's easy to understand to monitor the data lineage from source to target."
"As a data integration platform, it is easy to use. It is quite robust and useful for volumetric analysis when you have huge volumes of data. We have tested it for up to ten million rows, and it is robust enough to process ten million rows internally with its parallel processing. Its error logging mechanism is far simpler and easier to understand than other data integration tools. The newer version of InfoSphere has the data catalog and IDC lineage. They are helpful in the easy traceability of columns and tables."
"The data lineage report can be filtered for reporting. The reports are user-friendly and take less time to find what you need."
"We can view what we want to do. We can transform data and put them on tables."
"It's a robust solution."
"The ETL tools are probably the most valuable feature. It has an IBM tool, a friendly UI and it makes things more comfortable."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"The most valuable feature is Data movement."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The initial setup is easy."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"It's completely user-friendly."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"I like the data vault implementations."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"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 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."
"Naturally produces a way to easily debug your DW data solutions."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"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."
"So, there are some features that are missing. If I compare DataStage to Talend, Talend allows you to write custom code in Java or use these tools in your applications as well if you are building a job application. But in DataStage, it does not allow you to write custom code for any component."
"Improvements for DataStage could include better integration with modern data sources like cloud solutions and documents, along with enhancing its capability to handle non-structured data."
"Reduced cost would allow more customers to choose the product. It's quite expensive in relation to the cost of other similar solutions."
"I'd like to be able to do more with the data and metadata, including copy and pasting, et cetera."
"We would be happy to see in next versions the ability to return several parameters from jobs. Now, jobs can return just one parameter. If they could return several parameters, that would be great."
"The response time from support is slow and needs to be improved."
"The solution can be a bit more user-friendly, similar to Informatica."
"I want the tool to continue with the on-prem version, not the cloud one."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"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."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The resource management aspect of the solution could be improved."
"No support for change data capture or delta detection - that must be custom coded ."
"Customization could be better."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"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)."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
Earn 20 points