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 solution is very easy to use."
"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."
"Compared to other ETL tools, DataStage has excellent debugging and development capabilities. And the availability of connectors, even though we sometimes have to opt for specific ones. Also, the availability of patches is good."
"The most valuable feature of the solution is the ability to incorporate very complex business rules in Data Stage."
"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 product is a stable and powerful data management solution that can run in parallel mode for enhanced speed."
"DataStage works better with Linux operating systems when the application services are hosted on Linux system equipment, but it's powerful on Windows too."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The data reader is the most valuable feature."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The setup is straightforward. It's very easy to install."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"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."
"I want the tool to continue with the on-prem version, not the cloud one."
"The pricing should be lower."
"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."
"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."
"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."
"There are three things that could improve - the cloud, monitoring and cloud integration. It's a solid product but not a modern one and of course it depends what you're looking for."
"The initial setup can be complex."
"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."
"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."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Future releases should improve the data lineage, as it currently is not good."
"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."
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.