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.
"The most valuable feature is the data integration for data warehousing."
"The most valuable feature is the ability to transfer information via notes."
"DataStage works better with Linux operating systems when the application services are hosted on Linux system equipment, but it's powerful on Windows too."
"The best feature of IBM InfoSphere DataStage for me was that it was very much user-friendly. The solution didn't require that much raw coding because most of its features were drag and drop, plus it had a large number of functionalities."
"We like the flexibility of modeling."
"Highly customizable: Allowing you to handle multiple data latencies (scheduled batch, on-demand, and real-time) in the same job."
"ETL is the most valuable feature."
"When we have needed help from the IBM team, they were helpful. Our company is a premium partner so we get fast responses."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The solution is easy to use and developer friendly."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The scalability of SSIS is good."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"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."
"The interface needs improvement."
"The interface needs work to 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."
"Currently lacking virtualization ability."
"Working with some of the big data components is good, but I can see improvements are needed."
"DataStage is quite expensive. It is too hard to find a consultant using DataStage in Turkey."
"The setup is extremely difficult."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"I would like to see better integration with Power BI."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"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."
"The solution could improve on integrating with other types of data sources."
"We'd like them to develop data exploration more."
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.