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."It is a stable solution."
"Cloud Pak for Integration is definitely scalable. That is the most important criteria."
"The most valuable aspect of the Cloud Pak, in general, is the flexibility that you have to use the product."
"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."
"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."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The setup is straightforward. It's very easy to install."
"The product's deployment phase is easy."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The simplicity of the solution is great. The solution also offers excellent integration."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The initial setup is not easy."
"Its queuing and messaging features need improvement."
"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."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"The solution could improve on integrating with other types of data sources."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"Generic processes should be used instead of custom code for each table."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"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.