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 product's versatility to inject data."
"The most valuable feature of the solution is the ability to incorporate very complex business rules in Data Stage."
"Offers great flexibility."
"We like the flexibility of modeling."
"The solution is stable."
"The product is a stable and powerful data management solution that can run in parallel mode for enhanced speed."
"The ETL tools are probably the most valuable feature. It has an IBM tool, a friendly UI and it makes things more comfortable."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"SSIS integrates well with SQL servers and Microsoft products."
"SSIS' best feature is SFTP connectivity."
"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 performance and stability are good."
"It's a competent product."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The response time from support is slow and needs to be improved."
"The initial setup can be complex."
"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 setup is extremely difficult."
"In the future, I would like to see more integration with cloud technologies."
"I'd like to be able to do more with the data and metadata, including copy and pasting, et cetera."
"The pricing should be lower."
"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."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"We have issues with SSIS connectors while extracting data from Excel sources."
"I would like to see better technical documentation because many times information is missing."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The security could be improved, as it is more important in our context."
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.