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.
"Finding logs is very easy on the solution."
"The concept of integration is a valuable feature of the product."
"The product is easy to deploy."
"The solution has improved the time it takes to perform tasks related to batch applications."
"The data lineage report can be filtered for reporting. The reports are user-friendly and take less time to find what you need."
"Offers great flexibility."
"I am impressed with the tool's ETL tracing."
"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."
"It has good data integration and good processes."
"The data reader is the most valuable feature."
"SSIS integrates well with SQL servers and Microsoft products."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"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."
"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."
"It would be useful to provide support for Python, AR, and Java."
"The interface needs improvement. It is really too technical. That is the main problem."
"The interface needs work to be more user-friendly."
"Working with some of the big data components is good, but I can see improvements are needed."
"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 interface needs improvement."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"We have issues with SSIS connectors while extracting data from Excel sources."
"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."
"It's a legacy tool, that is nearing the end of its useful life."
"The solution could improve by having quicker release updates."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
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.