IBM Cloud Pak for Integration vs SSIS comparison

"Redirection is a key feature. It helps in managing multiple microservices by centralizing control and access."

"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."

"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 performance and stability are good."

"The most valuable feature of SSIS is that it can handle real complex transformations."

"We can connect with multiple data sources easily using an external connector in SSIS."

"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."

"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."

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."

"The scalability of SSIS is good."

"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."

"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."

"Enterprise bots are needed to balance products like Kafka and Confluent."

"The initial setup is not easy."

"Its queuing and messaging features need improvement."

"The pricing can be improved."

"We'd like them to develop data exploration more."

"We have issues with SSIS connectors while extracting data from Excel sources."

"We'd like more integration capabilities."

"Tuning using this solution requires extensive expertise to improve performance."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

"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."

"SSIS is stable, but extensive ETL data processing can have some performance issues."

"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."

"It is an expensive solution."

"The solution's pricing model is very flexible."

"It would be beneficial if the solution had a less costly cloud offering."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"The solution is available at a lesser price than that of Informatica."

"This solution is included with the MSSQL server package."

"We have an enterprise license for this solution."

"SSIS' licensing is a little high, but it gives good value for money."

"Our license with SSIS is annual."