We performed a comparison between IBM InfoSphere DataStage and SSIS based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: SSIS beat out IBM InfoSphere DataStage in all categories we compared.
"I am impressed with the tool's ETL tracing."
"IBM is stable and accurate to monitor. It's easy to understand to monitor the data lineage from source to target."
"The most valuable feature is the product's versatility to inject data."
"The most valuable feature of the solution is the ability to incorporate very complex business rules in Data Stage."
"The concept of integration is a valuable feature of the product."
"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's a robust solution."
"Highly customizable: Allowing you to handle multiple data latencies (scheduled batch, on-demand, and real-time) in the same job."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"It has good data integration and good processes."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The solution is easy to use and developer friendly."
"The solution should be more user-friendly."
"Its documentation is not up to the mark. While building APIs, we had a lot of problems trying to get around it because it is not very user-friendly. We tried to get hold of API documentation, but the documentation is not very well thought out. It should be more structured and elaborate. In terms of additional features, I would like to see good reporting on performance and performance-tuning recommendations that can be based on AI. I would also like to see better data profiling information being reported on InfoSphere."
"The troubleshooting guide is very bad."
"The solution can be a bit more user-friendly, similar to Informatica."
"I really like this tool, but the administration should be on the same client application because a lot of administration features are not on the client-side, and they usually need to have administrative access. It's quite complicated to force IT teams to have separate administrative access from the developers."
"Working with some of the big data components is good, but I can see improvements are needed."
"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."
"The documentation and in-application help for this solution need to be improved, especially for new features."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"The performance of SSIS could improve when comparing it to Oracle Database."
"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."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
IBM InfoSphere DataStage is ranked 7th in Data Integration with 37 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. IBM InfoSphere DataStage is rated 7.8, while SSIS is rated 7.6. The top reviewer of IBM InfoSphere DataStage writes "User-friendly with a lot of functions for transmission rules, but has slow performance and not suitable for a huge volume of data". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". IBM InfoSphere DataStage is most compared with IBM Cloud Pak for Data, Azure Data Factory, Talend Open Studio, Informatica PowerCenter and IBM InfoSphere Information Server, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), AWS Glue and Azure Data Factory. See our IBM InfoSphere DataStage vs. SSIS report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.