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

IBM Cloud Pak for Integration 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:
 

Categories and Ranking

IBM Cloud Pak for Integration
Average Rating
8.6
Reviews Sentiment
7.0
Number of Reviews
5
Ranking in other categories
API Management (24th), Cloud Data Integration (15th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
 

Featured Reviews

Neelima Golla - PeerSpot reviewer
A hybrid integration platform that applies the functionality of closed-loop AI automation
I recommend using it because, in today's context, the cloud plays a significant role. Within the same user interface, you can develop applications and manage multiple applications, making it a more user-friendly option. Moreover, you can explore various other technologies while deploying on the cloud, broadening your knowledge of cloud technologies. In my case, the transition led to my learning of Kubernetes, enabling multi-scaling and expanding my technical skills. It was a valuable experience, and I had the opportunity to learn many new things during the migration process. I can easily rate it an eight or nine out of ten.
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.

Quotes from Members

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

Pros

"The most preferable aspect would be the elimination of the command, which was a significant improvement. In the past, it was a challenge, but now we can proceed smoothly with the implementation of our policies and everything is managed through JCP. It's still among the positive aspects, and it's a valuable feature."
"Cloud Pak for Integration is definitely scalable. That is the most important criteria."
"It is a stable solution."
"The most valuable aspect of the Cloud Pak, in general, is the flexibility that you have to use the product."
"Redirection is a key feature. It helps in managing multiple microservices by centralizing control and access."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The interface is very user-friendly."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The setup was easy. All Microsoft products are easy to set up."
"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."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The data reader is the most valuable feature."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
 

Cons

"Enterprise bots are needed to balance products like Kafka and Confluent."
"The pricing can be improved."
"The initial setup is not easy."
"Setting up Cloud Pak for Integration is relatively complex. It's not as easy because it has not yet been fully integrated. You still have some products that are still not containerized, so you still have to run them on a dedicated VM."
"Its queuing and messaging features need improvement."
"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."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Video training would be a helpful addition."
"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"It needs more integration tools, so you can connect to different sources."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
 

Pricing and Cost Advice

"The solution's pricing model is very flexible."
"It is an expensive solution."
"We have an enterprise license for this solution."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"The solution comes free of cost."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"People have to opt for a perpetual-based licensing model."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"All of my clients have this product included as part of their Microsoft license."
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
Financial Services Firm
19%
Computer Software Company
12%
Government
9%
Manufacturing Company
8%
Financial Services Firm
18%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about IBM Cloud Pak for Integration?
The most preferable aspect would be the elimination of the command, which was a significant improvement. In the past, it was a challenge, but now we can proceed smoothly with the implementation of ...
What needs improvement with IBM Cloud Pak for Integration?
Enterprise bots are needed to balance products like Kafka and Confluent.
What is your primary use case for IBM Cloud Pak for Integration?
It manages APIs and integrates microservices at the enterprise level. It offers a range of capabilities for handling APIs, microservices, and various integration needs. The platform supports thousa...
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

No data available
SQL Server Integration Services
 

Overview

 

Sample Customers

CVS Health Corporation
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 Cloud Pak for Integration vs. SSIS and other solutions. Updated: April 2025.
847,862 professionals have used our research since 2012.