We performed a comparison between IBM InfoSphere DataStage, SSIS, 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 most valuable feature of the solution is the ability to incorporate very complex business rules in Data Stage."
"The solution has improved the time it takes to perform tasks related to batch applications."
"The product is a stable and powerful data management solution that can run in parallel mode for enhanced speed."
"We like the flexibility of modeling."
"I am impressed with the tool's ETL tracing."
"It's a robust solution."
"Finding logs is very easy on the solution."
"The product is easy to deploy."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"SSIS' most valuable feature is its reporting services."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The performance and stability are good."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"The most valuable feature is the metadata generated code."
"I found the initial setup very easy."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"It has a built-in automatic scheduling environment."
"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."
"The setup is extremely difficult."
"The graphical user interface (GUI) feels a lot like the interfaces from the 1980s."
"It would be great if they can include some basic version of data quality checking features."
"Their web interface is good but the on-prem sites are outdated. The solution could also be improved if they could integrate the data pipeline scheduling part of their interface."
"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 documentation and in-application help for this solution need to be improved, especially for new features."
"What needs improvement in IBM InfoSphere DataStage is its pricing. The pricing for the solution is higher than its competitors, so a lot of the clients my company has worked with prefer other tools over IBM InfoSphere DataStage because of the high price tag. Another area for improvement in the solution stems from a lot of new types of databases, for example, databases in the cloud and big data have become available, and IBM InfoSphere DataStage is working on various connectors for different data sources, but that still isn't up-to-date, meaning that some connectors are missing for modern data sources. The latest version of IBM InfoSphere DataStage also has a complex architecture, so my team faced frequent outages and that should be improved as well."
"The initial setup could be more straightforward."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"It would be nice if you could run SSIS on other environments besides Windows."
"This solution needs full support for real-time processing."
"Generic processes should be used instead of custom code for each table."
"I would like to see better integration with Power BI."
"It's a legacy tool, that is nearing the end of its useful life."
"No support for change data capture or delta detection - that must be custom coded ."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Improve the object renaming ability (it works, but it could be more automated)."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
Earn 20 points