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."The iPaaS functionality is very mature. The browser based IDE is also very mature and stable."
"Very effective with its drag-and-drop feature."
"I really appreciate the on-the-go access through the browser and the B2B integration."
"AtomSphere Integration will suit those looking for small automation and simple integrations."
"The most valuable feature of the solution is its monitoring part to debug certain issues and find problems."
"The product's integration features are quite rich and low code. It is easy to use."
"The connection configuration part and the drag-and-drop integration module are the most valuable features for me."
"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 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 most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"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 most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The technical support is very good."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"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."
"It has good data integration and good processes."
"It crashes if we run high-volume integration."
"The deployment was simple, but the implementation is missing a lot of capabilities."
"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."
"There are still some areas that need improvement. For example, when updates are going on, the product becomes very slow."
"It is a costly platform. Its pricing could be better."
"The product could be a little bit more user-friendly."
"In day-to-day operations, tracking transactions is a major challenge. It takes hours to track a single transaction. It is not a straightforward process."
"I would like to see more features in terms of the integration with Azure Data Factory."
"It's a legacy tool, that is nearing the end of its useful life."
"Future releases should improve the data lineage, as it currently is not good."
"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."
"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."
"I would like to see better integration with Power BI."
"The high prices attached to the product can be an area of concern where improvements are required."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
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.