IBM Cloud Pak for Integration vs SSIS comparison

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

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

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

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

"Like most Microsoft products, SSIS is user-friendly and easy to use."

"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."

"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 script component is very powerful, things that you cannot normally do, is feasible through C#."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."

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

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

"The initial setup is not easy."

"Its queuing and messaging features need improvement."

"The creation of the measure in the DAC's model could be improved."

"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."

"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

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

"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."

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

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

"It is an expensive solution."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

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

"All of my clients have this product included as part of their Microsoft license."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

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