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."Boomi AtomSphere Integration is stable."
"The iPaaS functionality is very mature. The browser based IDE is also very mature and stable."
"The platform is user-friendly."
"It is easy to learn and implement."
"It is a low-code and high-configuration platform, which is very valuable. Develop once and run anywhere is another useful feature. It also has connectors for more than 200 applications. It provides value for money. Our customers who have implemented this solution have a very high ROI."
"The most valuable feature of the solution is its monitoring part to debug certain issues and find problems."
"The product's initial setup phase was easy."
"The Salesforce and NetSuite Application specific “connectors” provide a layer of abstraction on top of the SOAP-based APIs to streamline integration development."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The data reader is the most valuable feature."
"SSIS' most valuable feature is its reporting services."
"SSIS is easy to use."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"Like most Microsoft products, SSIS is user-friendly and 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."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"Boomi AtomSphere Integration should scale up on the migration area."
"We would like to see more involvement between Dell Boomi and the end-users to help improve the customer experience."
"There are more mature (dedicated) API management and master data management (MDM) solutions available in the market."
"The high price of the solution is an area of concern where improvements are required."
"There should be more scripting possibilities."
"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."
"Have to create some of our own pre-built connectors."
"Documentation could be improved."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"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."
"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."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
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.