

SSIS and IBM Cloud Pak for Data are competing in the data integration and analytics category. IBM Cloud Pak for Data has the upper hand due to its advanced analytics capabilities and scalability, while SSIS offers benefits like lower setup costs and seamless Microsoft integration.
Features: SSIS provides strong ETL capabilities, seamless integration with SQL Server, and flexibility to add custom code through its scripting component. IBM Cloud Pak for Data offers extensive AI and machine learning features, data virtualization, and data governance with Watson Knowledge Catalog.
Room for Improvement: SSIS could improve in handling large data volumes, further enhancing cloud integration, and simplifying work with non-Microsoft environments. IBM Cloud Pak for Data can enhance user-friendliness, reduce high pricing for smaller firms, and streamline initial setup processes to be less complex.
Ease of Deployment and Customer Service: SSIS is easier to deploy for those familiar with Microsoft systems, providing straightforward integration with SQL Server. IBM Cloud Pak for Data caters to enterprise needs with a scalable, hybrid-cloud-friendly model. IBM's customer service is adept at handling complex, diverse environments, offering tailored support.
Pricing and ROI: SSIS offers a cost-effective solution, especially for businesses already invested in Microsoft products, with affordable setup costs. IBM Cloud Pak for Data, although more expensive, promises higher ROI via deep data insights and analytics. The pricing models vary, with SSIS being budget-friendly initially, while IBM presents higher strategic value over time.
We have been able to drive responsible, transparent, and explainable AI workflow to operationalize AI and mitigate risk and regulatory compliance easily.
It is easy to collect, organize, and analyze data no matter where it is, hence being able to make data-driven decisions.
The tool has made us tremendously more efficient and saved us a significant amount of money.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
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.
Cloud Pak is a complicated system, and it's often difficult to find the right resource in IBM to help with specific issues.
The customer support for IBM Cloud Pak for Data is great and responsive.
The first line of support needs to be more knowledgeable.
I have not noticed any downtime or lagging, especially when dealing with large data, so it is relatively very scalable.
IBM Cloud Pak for Data's scalability is very good; it can be used by any size of organization.
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.
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.
The overall performance of IBM Cloud Pak for Data, particularly with IBM DataStage for ETL processes, is very good.
It processes large volumes of data quickly.
Setting up the hybrid and multi-cloud environments is a long job and it takes time.
IBM Cloud Pak for Data can be improved because processing speeds are sometimes slow.
To improve IBM Cloud Pak for Data, I suggest more out-of-the-box integration.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS has a difficult learning curve when dealing with complex transformations.
The logging capabilities could be improved, particularly for error logging.
The setup cost is very expensive.
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.
The list price is high, but the flexibility in pricing is adequate.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
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.
However, it could be a bit cheaper.
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.
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.
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.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
SSAS is included in the base installation of SQL Server.
| Product | Mindshare (%) |
|---|---|
| SSIS | 3.7% |
| IBM Cloud Pak for Data | 1.0% |
| Other | 95.3% |


| Company Size | Count |
|---|---|
| Small Business | 10 |
| Large Enterprise | 20 |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 58 |
IBM Cloud Pak for Data is a comprehensive platform integrating data management, AI, and machine learning capabilities tailored for hybrid environments. It's renowned for enhancing productivity through efficient data analytics and management.
This platform offers data virtualization, robust analytics, and AI-driven processes. Its integration capabilities, including IBM MQ and App Connect, facilitate seamless data connections. Users benefit from containerization, data governance, and compatibility with hybrid systems, improving decision-making and management productivity. However, the requirement of extensive infrastructure and performance challenges can impact scalability for small businesses.
What are the key features of IBM Cloud Pak for Data?In the financial and banking sectors, IBM Cloud Pak for Data is utilized for data management tasks like spend analytics and contract leakage analysis. It's used for data integration, machine learning, and AI-driven analytics to transform data into valuable insights in industries such as FinTech and consultancy.
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
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.