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.
"Offers great flexibility."
"The most valuable feature of the solution is the ability to incorporate very complex business rules in Data Stage."
"When we have needed help from the IBM team, they were helpful. Our company is a premium partner so we get fast responses."
"ETL is the most valuable feature."
"The solution is very easy to use."
"We are mostly using transmission rules. It has a lot of functions and logic related to transmission. It is a user-friendly tool with in-built functions."
"The product is easy to deploy."
"It works with multiple servers and offers high availability."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"It's a competent product."
"The product's deployment phase is easy."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It has good data integration and good processes."
"SSIS integrates well with SQL servers and Microsoft products."
"The solution should be more user-friendly."
"It would be great if they can include some basic version of data quality checking features."
"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."
"The initial setup can be complex."
"The graphical user interface (GUI) feels a lot like the interfaces from the 1980s."
"The troubleshooting guide is very bad."
"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."
"The solution could improve on integrating with other types of data sources."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
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.