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."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."
"Cloud Pak for Integration is definitely scalable. That is the most important criteria."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The most important features are it works well and provides self-service BI."
"SSIS' most valuable feature is its reporting services."
"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."
"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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"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."
"The pricing can be improved."
"The initial setup is not easy."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"The performance of SSIS could improve when comparing it to Oracle Database."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"Video training would be a helpful addition."
"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."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
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, MuleSoft Anypoint API Manager and Microsoft Azure API Management, 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.