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.
"It's a robust solution."
"Once you have Infosphere up and running properly, it is stable."
"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."
"The performance optimization is quite good in DataStage. It provides parallelism and pipelining mechanisms"
"The product is easy to deploy."
"Highly customizable: Allowing you to handle multiple data latencies (scheduled batch, on-demand, and real-time) in the same job."
"Offers great flexibility."
"It works with multiple servers and offers high availability."
"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."
"The solution is stable."
"The UI is very user-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 most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"It has good data integration and good processes."
"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."
"SSIS is easy to use."
"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."
"DataStage is quite expensive. It is too hard to find a consultant using DataStage in Turkey."
"It would be great if they can include some basic version of data quality checking features."
"The graphical user interface (GUI) feels a lot like the interfaces from the 1980s."
"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."
"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."
"The initial setup can be complex."
"At one point, we did have to purchase an add-on."
"The security could be improved, as it is more important in our context."
"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."
"I would like to see better integration with Power BI."
"Performance could be better."
"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."
"This solution needs full support for real-time processing."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
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.