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."The iPaaS functionality is very mature. The browser based IDE is also very mature and stable."
"Very effective with its drag-and-drop feature."
"The platform is user-friendly."
"This solution has a user-friendly interface and very good documentation with solutions that helped us in working with the tool efficiently."
"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."
"Low-code development is the most valuable feature."
"The most valuable feature of the solution is its monitoring part to debug certain issues and find problems."
"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 is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"SSIS' best feature is SFTP connectivity."
"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."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The initial setup of this solution is very straightforward."
"The setup was easy. All Microsoft products are easy to set up."
"The product could be a little bit more user-friendly."
"They are lacking in some streaming features, and messaging features from a listener's point of view."
"The deployment was simple, but the implementation is missing a lot of capabilities."
"They should create a custom connector option. With this, they could improve where the user can create the connector, based on their usage."
"The API can use some work to come up to speed with the competition but Dell has plans and is working on resolving that."
"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."
"The product's UI could be more convenient."
"It is a costly platform. Its pricing could be better."
"It needs more integration tools, so you can connect to different sources."
"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."
"I would like to see more features in terms of the integration with Azure Data Factory."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
"The high prices attached to the product can be an area of concern where improvements are required."
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.