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."We work on the flow between systems and the most valuable features for that purpose are the mapping of data, interface mapping, and data integration."
"I really appreciate the on-the-go access through the browser and the B2B integration."
"It is easy to learn and implement."
"It has been a stable product."
"The platform is user-friendly."
"I like the tool's optimization feature."
"AtomSphere Integration will suit those looking for small automation and simple integrations."
"It's very user-friendly and designed to be easy to use for the end user."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"SSIS is easy to use."
"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 most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The product could be a little bit more user-friendly."
"Documentation could be improved."
"There should be more scripting possibilities."
"We would like to see more involvement between Dell Boomi and the end-users to help improve the customer experience."
"The deployment was simple, but the implementation is missing a lot of capabilities."
"There are very few string handling functions and few mathematical functions are available."
"They need to introduce more configurable functions to remove scripting or coding. Scripting should be minimized. It should have exhaustive functions. Currently, it lacks in this aspect."
"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."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Improvement as per customer requirements."
"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."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"Performance could be better."
"This solution needs full support for real-time processing."
"At one point, we did have to purchase an add-on."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
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.