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."DataStage works better with Linux operating systems when the application services are hosted on Linux system equipment, but it's powerful on Windows too."
"It works with multiple servers and offers high availability."
"The most valuable feature is the data integration for data warehousing."
"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."
"Finding logs is very easy on the solution."
"The most valuable feature is the product's versatility to inject data."
"Highly customizable: Allowing you to handle multiple data latencies (scheduled batch, on-demand, and real-time) in the same job."
"The solution's scalability is really good...we are using multi-instance jobs where you can scale them easily."
"The technical support is very good."
"Overall, it's a good product."
"The scalability of SSIS is good."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The simplicity of the solution is great. The solution also offers excellent integration."
"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 setup is straightforward. It's very easy to install."
"The product's deployment phase is easy."
"Data transformations and rollups are easy to accomplish."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"It has a built-in automatic scheduling environment."
"I like the data vault implementations."
"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."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Support is absolutely excellent, efficient, and timely."
"In terms of intermediate storage, we have some challenges, especially with customers who store data in intermediate locations."
"Currently lacking virtualization ability."
"The response time from support is slow and needs to be improved."
"It would be useful to provide support for Python, AR, and Java."
"It doesn't have any big data connections. It would be good to have them because most of the systems are moving towards big data. There should also be a user-friendly way to interact with the cloud. Its loading process is very slow. It takes a lot of time for around 5 or 6 million records, and we are not able to provide real-time data to the vendors due to this delay. Its performance needs to be improved. It is also like a legacy system. It is not updated much. In higher versions, they only do small changes. We would like to have new features and new technologies."
"The graphical user interface (GUI) feels a lot like the interfaces from the 1980s."
"In the future, I would like to see more integration with cloud technologies."
"The solution should be more user-friendly."
"Tuning using this solution requires extensive expertise to improve performance."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"It would be nice if you could run SSIS on other environments besides Windows."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"The performance of SSIS could improve when comparing it to Oracle Database."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Video training would be a helpful addition."
"Future releases should improve the data lineage, as it currently is not good."
"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."
"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."
"Customization could be better."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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."
"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."
Earn 20 points