Try our new research platform with insights from 80,000+ expert users

IBM App Connect vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
7.2
IBM App Connect enhances ROI and operational efficiency with integration, requiring skilled personnel for optimal long-term benefits.
Sentiment score
7.3
SSIS provides cost-effective data management efficiency, delivering ROI without extra costs apart from the SQL Server license.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
 

Customer Service

Sentiment score
6.6
IBM App Connect's customer support is mostly praised, with effective escalation, though first-tier and onsite assistance require improvement.
Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
 

Scalability Issues

Sentiment score
7.4
IBM App Connect is praised for scalability and flexibility, despite some challenges with Hypervisor Edition and XML payload sizes.
Sentiment score
6.8
SSIS is moderately scalable, better for batch processing, with varied performance depending on infrastructure and implementation challenges.
I would rate the scalability of IBM App Connect as nine out of ten.
 

Stability Issues

Sentiment score
7.6
IBM App Connect is praised for stability, with rare issues quickly resolved, maintaining high user satisfaction and performance.
Sentiment score
7.4
SSIS is a reliable, mature tool with minor performance concerns, praised for stability in diverse projects despite occasional issues.
It processes large volumes of data quickly.
 

Room For Improvement

IBM App Connect needs better logging, support, connectors, UI, command line integration, and simpler installation to address user concerns.
SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
I find it particularly good for on-premises and now cloud use.
SSIS has a difficult learning curve when dealing with complex transformations.
 

Setup Cost

IBM App Connect pricing is high, dependent on volume and status, yet offers flexibility and quality justifying its cost.
SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
 

Valuable Features

IBM App Connect offers user-friendly integration with minimal coding, scalability, and security, supporting complex environments and efficient automation.
SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
The features I find most valuable are message routing, message transformation, and protocol translation.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
 

Categories and Ranking

IBM App Connect
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
24
Ranking in other categories
Cloud Data Integration (11th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
 

Featured Reviews

Mehdi El Filahi - PeerSpot reviewer
Offers flexible adapters, good scalability but logging can be difficult at times
There is room for improvement in the logging messages. Sometimes, if you put someone new into App Connect, they can abandon it the same day. The logging is really painful. However, IBM has made efforts to integrate with Elasticsearch for logging, so that's an improvement. Overall, the logging can be difficult at times. One more important point is that if IBM improves its CI/CD capabilities, it will make a big difference. Right now, I have to create my own CI/CD setup from scratch for every client, which is inefficient. Back in 2013, I worked with Sonic ESB, and even then, it had CI/CD with Maven. With App Connect, you need to build everything yourself when using tools like Jenkins, Bamboo, or CircleCI. IBM really needs to provide official support for this.
BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
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. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
847,862 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Educational Organization
50%
Computer Software Company
9%
Financial Services Firm
8%
Manufacturing Company
5%
Financial Services Firm
18%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM App Connect?
I like the adapters. The adapters help us achieve scalability. If you want to connect to SAP, there's an adapter. Salesforce? There's an adapter. You want to connect to another system? There's like...
What is your experience regarding pricing and costs for IBM App Connect?
IBM App Connect's pricing is high compared to other products.
What is your primary use case for IBM App Connect?
Our company has a big project for delivery and e-commerce sites. We use IBM App Connect to deliver information to our end users after they buy our products. We get information from many places, suc...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Also Known As

IBM Cast Iron
SQL Server Integration Services
 

Overview

 

Sample Customers

United Way of Allegheny County, Saint-Gobain CPS, Ricoh, SunTrust Banks Inc.
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about IBM App Connect vs. SSIS and other solutions. Updated: April 2025.
847,862 professionals have used our research since 2012.