We performed a comparison between Boomi iPaaS and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Integration Platform as a Service (iPaaS) solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It has been a stable product."
"Extremely flexible for any kind of integration between systems."
"The iPaaS functionality is very mature. The browser based IDE is also very mature and stable."
"This is a fairly easy-to-use tool for integration which can be self-taught for those with a bit of a technical background."
"Very effective with its drag-and-drop feature."
"It is easy to learn and implement."
"AtomSphere Integration will suit those looking for small automation and simple integrations."
"This solution has a user-friendly interface and very good documentation with solutions that helped us in working with the tool efficiently."
"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."
"The interface is very user-friendly."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"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."
"It is easy to set up. The deployment is also very quick."
"The UI is very user-friendly."
"We encountered stability issues occasionally, one to two times a year."
"Lots of enhancements are needed in the API portal so that the developers can view the definitions, try out the APIs, etc."
"The deployment was simple, but the implementation is missing a lot of capabilities."
"The solution is complex. There's a few items and features that are hard to understand. They should work to simplify the functionality so new users don't struggle."
"The product's UI could be more convenient."
"The product could be a little bit more user-friendly."
"There are more mature (dedicated) API management and master data management (MDM) solutions available in the market."
"Documentation could be improved."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"Generic processes should be used instead of custom code for each table."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"We'd like them to develop data exploration more."
"I would like to see better integration with Power BI."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"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."
"Future releases should improve the data lineage, as it currently is not good."
Boomi iPaaS is ranked 5th in Integration Platform as a Service (iPaaS) with 25 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Boomi iPaaS is rated 7.8, while SSIS is rated 7.6. The top reviewer of Boomi iPaaS writes "Stable product, suitable for limited integrations and lacks flexibility ". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Boomi iPaaS is most compared with Microsoft Azure Logic Apps, webMethods Integration Server, Oracle Integration Cloud Service, AWS Glue and Azure Data Factory, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage and Oracle Data Integrator (ODI). See our Boomi iPaaS vs. SSIS report.
We monitor all Integration Platform as a Service (iPaaS) 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.