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."This solution has a user-friendly interface and very good documentation with solutions that helped us in working with the tool efficiently."
"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."
"This is a fairly easy-to-use tool for integration which can be self-taught for those with a bit of a technical background."
"It's very user-friendly and designed to be easy to use for the end user."
"AtomSphere Integration will suit those looking for small automation and simple integrations."
"Extremely flexible for any kind of integration between systems."
"The connection configuration part and the drag-and-drop integration module are the most valuable features for me."
"The platform is user-friendly."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The performance and stability are good."
"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 good data integration and good processes."
"Overall, it's a good product."
"SSIS' best feature is SFTP connectivity."
"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's UI could be more convenient."
"There are still some areas that need improvement. For example, when updates are going on, the product becomes very slow."
"We encountered stability issues occasionally, one to two times a year."
"The high price of the solution is an area of concern where improvements are required."
"We would like to see more involvement between Dell Boomi and the end-users to help improve the customer experience."
"The API can use some work to come up to speed with the competition but Dell has plans and is working on resolving that."
"Lots of enhancements are needed in the API portal so that the developers can view the definitions, try out the APIs, etc."
"There should be more scripting possibilities."
"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."
"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."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"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."
"I would like to see better technical documentation because many times information is missing."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"The high prices attached to the product can be an area of concern where improvements are required."
"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."
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.