We performed a comparison between Boomi AtomSphere Integration 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."Very effective with its drag-and-drop feature."
"AtomSphere Integration will suit those looking for small automation and simple integrations."
"It has been a stable product."
"This is a fairly easy-to-use tool for integration which can be self-taught for those with a bit of a technical background."
"This solution has a user-friendly interface and very good documentation with solutions that helped us in working with the tool efficiently."
"It's very user-friendly and designed to be easy to use for the end user."
"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."
"It is easy to learn and implement."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The most important features are it works well and provides self-service BI."
"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."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The setup was easy. All Microsoft products are easy to set up."
"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."
"There are more mature (dedicated) API management and master data management (MDM) solutions available in the market."
"In my experience, I haven't encountered any major issues with the tool. However, there could be a learning curve for new users, especially depending on which tool you're using. For example, I've used MuleSoft in the past, which is more code-oriented and requires knowledge of Java. Transitioning to Boomi AtomSphere Integration took me a couple of months because of differences in terminology."
"The product could be a little bit more user-friendly."
"We encountered stability issues occasionally, one to two times a year."
"We would like to see more involvement between Dell Boomi and the end-users to help improve the customer experience."
"They are lacking in some streaming features, and messaging features from a listener's point of view."
"The API can use some work to come up to speed with the competition but Dell has plans and is working on resolving that."
"Documentation could be improved."
"The security could be improved, as it is more important in our context."
"At one point, we did have to purchase an add-on."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"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."
"Performance could be better."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
Boomi AtomSphere Integration 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 AtomSphere Integration is rated 7.8, while SSIS is rated 7.6. The top reviewer of Boomi AtomSphere Integration 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 AtomSphere Integration is most compared with Microsoft Azure Logic Apps, webMethods Integration Server, Oracle Integration Cloud Service, Azure Data Factory and AWS Glue, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage and Oracle Data Integrator (ODI). See our Boomi AtomSphere Integration 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.