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."
"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."
"Cloud Pak for Integration is definitely scalable. That is the most important criteria."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"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."
"It is easy to set up. The deployment is also very quick."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"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 initial setup is not easy."
"Its queuing and messaging features need improvement."
"The pricing can be improved."
"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."
"The creation of the measure in the DAC's model could be improved."
"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."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"The high prices attached to the product can be an area of concern where improvements are required."
"Options for scaling could be improved."
"I would like to see better technical documentation because many times information is missing."
"Tuning using this solution requires extensive expertise to improve performance."
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.