No more typing reviews! Try our Samantha, our new voice AI agent.

IBM Cloud Pak for Data vs SSIS comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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
5.1
Users see improved efficiency and ROI with IBM Cloud Pak for Data, streamlining management and boosting compliance and satisfaction.
Sentiment score
6.5
SSIS is cost-effective, enhancing data management efficiency and integration with SQL Server, providing significant operational and financial benefits.
We have been able to drive responsible, transparent, and explainable AI workflow to operationalize AI and mitigate risk and regulatory compliance easily.
Senior Data Analyst at Wipro Limited
It is easy to collect, organize, and analyze data no matter where it is, hence being able to make data-driven decisions.
Engineer at Turner Construction
The tool has made us tremendously more efficient and saved us a significant amount of money.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
Managing Partner at Dynamis Informatica
 

Customer Service

Sentiment score
7.1
IBM Cloud Pak for Data's support is responsive, rated highly, and cost-effective, but lacks local language options and has occasional delays.
Sentiment score
6.0
Users find Microsoft support adequate for critical issues but often use online resources and community support for minor ones.
I rate the technical support from IBM a nine out of ten because the support has been very top-notch, unparalleled, and also very professional.
Manager at teshama
Cloud Pak is a complicated system, and it's often difficult to find the right resource in IBM to help with specific issues.
Data asset management engineer at a tech services company with 1-10 employees
The customer support for IBM Cloud Pak for Data is great and responsive.
Engineer at Turner Construction
The first line of support needs to be more knowledgeable.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Scalability Issues

Sentiment score
6.6
IBM Cloud Pak for Data is scalable, efficiently managing growth and large data, with high resource use noted.
Sentiment score
6.7
SSIS is effective for small to medium enterprises but may face challenges with scalability and performance for large datasets.
I have not noticed any downtime or lagging, especially when dealing with large data, so it is relatively very scalable.
Senior Data Analyst at Wipro Limited
IBM Cloud Pak for Data's scalability is very good; it can be used by any size of organization.
Engineer at Turner Construction
For scalability, I rate it a nine out of ten because it is a very scalable solution that has been able to handle my organization's growth efficiently.
Manager at teshama
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
Tech Lead at a consultancy with 11-50 employees
 

Stability Issues

Sentiment score
7.8
IBM Cloud Pak for Data is stable with positive performance and integration, though scalability improvements are desired by some users.
Sentiment score
7.4
SSIS is highly rated for stability and performance, though minor issues and cloud discrepancies are occasionally noted by users.
The overall performance of IBM Cloud Pak for Data, particularly with IBM DataStage for ETL processes, is very good.
Sales Director at Jordan Business Systems
It processes large volumes of data quickly.
Managing Partner at Dynamis Informatica
 

Room For Improvement

IBM Cloud Pak for Data needs better integration, enhanced performance, simplified setup, cost management, and improved analytics for broader adoption.
SSIS needs enhanced error logging, diverse data integration, user management, ease of use, scalability, and better documentation support.
Setting up the hybrid and multi-cloud environments is a long job and it takes time.
Senior Data Analyst at Wipro Limited
IBM Cloud Pak for Data can be improved because processing speeds are sometimes slow.
Engineer at Turner Construction
To improve IBM Cloud Pak for Data, I suggest more out-of-the-box integration.
Senior Project Manager at EY
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
Managing Director at Knights Innovation Support Centre
SSIS has a difficult learning curve when dealing with complex transformations.
Managing Partner at Dynamis Informatica
The logging capabilities could be improved, particularly for error logging.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Setup Cost

IBM Cloud Pak for Data is costly, suitable for large enterprises, with pricing based on usage and deployment.
SSIS is economical with SQL Server licenses, offering favorable pricing and integration, though add-ons may increase costs.
The setup cost is very expensive.
Data asset management engineer at a tech services company with 1-10 employees
Regarding my experience with pricing, setup cost, and licensing, for a small organization, the price might be relatively high, but for huge enterprises such as ours, the price is relatively affordable.
Senior Data Analyst at Wipro Limited
The list price is high, but the flexibility in pricing is adequate.
Solution Manager at Intalion
Utilizing SSIS involves no extra charges beyond the SQL Server license.
Managing Partner at Dynamis Informatica
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
However, it could be a bit cheaper.
Tech Lead at a consultancy with 11-50 employees
 

Valuable Features

IBM Cloud Pak for Data enhances productivity with AI tools, data governance, and seamless integration across hybrid and multi-cloud environments.
SSIS offers efficient, scalable ETL with seamless Microsoft integration, user-friendly interface, flexibility, and cost-effectiveness, enhancing data processes.
From there, I can work my way into a more granular level, applying all of that information on top of my actual data to understand what my data looks like, where it came from, and where it went wrong, managing it throughout the cycle.
Data asset management engineer at a tech services company with 1-10 employees
The benefits of choosing IBM Cognos, in addition to saving on cost, include having institutional knowledge about maintaining this infrastructure and enough people who have developed on Cognos in the past, which creates comfort in its use.
EDW Manager at a university with 1,001-5,000 employees
We have been able to save approximately 80 percent of our time. We are not doing data analysis manually, so this relieves our data department of dealing with data.
Senior Data Analyst at Wipro Limited
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Managing Partner at Dynamis Informatica
SSAS is included in the base installation of SQL Server.
Managing Director at Knights Innovation Support Centre
 

Categories and Ranking

IBM Cloud Pak for Data
Ranking in Data Integration
17th
Average Rating
8.2
Reviews Sentiment
6.1
Number of Reviews
21
Ranking in other categories
Data Virtualization (3rd)
SSIS
Ranking in Data Integration
2nd
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of August 2026, in the Data Integration category, the mindshare of IBM Cloud Pak for Data is 1.0%, down from 1.9% compared to the previous year. The mindshare of SSIS is 3.7%, down from 7.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
SSIS3.7%
IBM Cloud Pak for Data1.0%
Other95.3%
Data Integration
 

Featured Reviews

ArchanaSingh - PeerSpot reviewer
Senior Data Analyst at Wipro Limited
Collaborative data platform has transformed analytics and now drives faster decisions
The best features IBM Cloud Pak for Data offers include robust data visualization, centralized data analytics, data reliability, and compatibility with hybrid and multi-cloud environments. The compatibility with hybrid and multi-cloud environments has helped our organization as data visualization is very simple. Migrations, reading, analysis, and data management from other sources are performed without problems of requirements. We have a team of experts in IBM Cloud Pak for Data to maintain security and correct data management easily. I find this cloud excellent for visualizing and managing data across networks and also fulfilling fastest data storage, making it less complex and completely improving productivity in my organization. Everything is managed in multiple environments without any problem. IBM Cloud Pak for Data has positively impacted my organization, and I have noticed some improvement since we started using this tool. Configuration with hybrid and multi-cloud environments has been very seamless and easy. It is a robust platform capable of working with multiple data sources where we gain insights to make data-driven decisions easily. It automates data analysis for quick and better performance. We have seen improvements in analysis and data correction from multiple sources. Our productivity in the company is growing, thanks to the data analysis team. We have also seen a robust hybrid and multi-cloud access system working seamlessly. I can share specific outcomes that show how productivity has grown and how performance has improved since the data is automated, and the analysis is done much faster, saving us a lot of time. We have been able to save approximately 80 percent of our time. We are not doing data analysis manually, so this relieves our data department of dealing with data. We have been relieved of a lot of duties, and now we are able to focus on other strategic tasks. Our productivity has greatly increased since we are able to make concrete and data-driven decisions easily.
Chris Farris - PeerSpot reviewer
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
User-friendly interface facilitates efficient data migration and reduces operational overhead
Its usability and ease of use are standout features. It is really easy to use - almost too easy at times. Users don't have to be experts to use their tool set and utilize the clicking mechanisms, drop down boxes, and other features to build a package and run it. The configuration is very easy and the system is very stable. I would rate it at a 10 as it is highly reliable; we have never had any problems with it. Very little maintenance is required on my side. While you need to keep the product up to date, the maintenance requirements are minimal. SSIS integrates with all Microsoft tools seamlessly. We have used it against Oracle, DB2 and SQL. It integrates and can move data around from any data platforms, making it very diverse in that standpoint. It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
908,800 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
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%
Manufacturing Company
10%
Computer Software Company
6%
Outsourcing Company
5%
Financial Services Firm
14%
Construction Company
8%
Government
7%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business10
Large Enterprise20
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise58
 

Questions from the Community

What is your experience regarding pricing and costs for IBM Cloud Pak for Data?
My experience with pricing, setup cost, and licensing is that the cost of the product can be a bit higher, especially for a company working on a tight budget.
What needs improvement with IBM Cloud Pak for Data?
One of the improvements I think should be made to IBM Cloud Pak for Data is that the cost of the product is a bit higher. Besides cost, I think something that is needed for improvement is that more...
What is your primary use case for IBM Cloud Pak for Data?
My main use case for IBM Cloud Pak for Data is that it is fully scalable and a scalable platform for data. I use it to provide data solutions for my customers. I also use it to provide various indu...
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 is your experience regarding pricing and costs for SSIS?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
What needs improvement with SSIS?
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly. The initial setup for SSIS is somewhat complex in the beginning, but once you und...
 

Also Known As

Cloud Pak for Data
SQL Server Integration Services
 

Overview

 

Sample Customers

Qatar Development Bank, GuideWell, Skanderborg Music Festival
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 Data vs. SSIS and other solutions. Updated: August 2026.
908,800 professionals have used our research since 2012.