We performed a comparison between IBM Cloud Pak for Integration and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Cloud Pak for Integration is definitely scalable. That is the most important criteria."
"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."
"The most valuable aspect of the Cloud Pak, in general, is the flexibility that you have to use the product."
"It is a stable solution."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The most important features are it works well and provides self-service BI."
"The performance is good."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The solution is easy to use and developer friendly."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"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."
"The pricing can be improved."
"Its queuing and messaging features need improvement."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Tuning using this solution requires extensive expertise to improve performance."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
More IBM Cloud Pak for Integration Pricing and Cost Advice →
IBM Cloud Pak for Integration is ranked 14th in Cloud Data Integration with 4 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. IBM Cloud Pak for Integration is rated 8.6, while SSIS is rated 7.6. The top reviewer of IBM Cloud Pak for Integration writes "A hybrid integration platform that applies the functionality of closed-loop AI automation". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". IBM Cloud Pak for Integration is most compared with IBM App Connect, IBM API Connect, IBM DataPower Gateway, Microsoft Azure API Management and MuleSoft Anypoint API Manager, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our IBM Cloud Pak for Integration vs. SSIS report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.