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."The Salesforce and NetSuite Application specific “connectors” provide a layer of abstraction on top of the SOAP-based APIs to streamline integration development."
"The best features are that it is a cloud-based and a multi-tenant tool."
"It is easy to learn and implement."
"The tool's most valuable features I've found are related to debugging and testing. It makes it easy to track execution, documents, and process history. This functionality is particularly useful for identifying issues with data and providing insights to the business."
"The platform is user-friendly."
"I like the tool's optimization feature."
"The product's integration features are quite rich and low code. It is easy to use."
"It has been a stable product."
"SSIS is easy to use."
"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."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"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 setup was easy. All Microsoft products are easy to set up."
"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."
"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 product could be a little bit more user-friendly."
"We encountered stability issues occasionally, one to two times a year."
"They are lacking in some streaming features, and messaging features from a listener's point of view."
"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."
"There are still some areas that need improvement. For example, when updates are going on, the product becomes very slow."
"There are more mature (dedicated) API management and master data management (MDM) solutions available in the market."
"There should be more scripting possibilities."
"The high price of the solution is an area of concern where improvements are required."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"We'd like them to develop data exploration more."
"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."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Tuning using this solution requires extensive expertise to improve performance."
"I would like to see better technical documentation because many times information is missing."
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.
