We performed a comparison between Boomi iPaaS and StreamSets 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 most valuable feature of the solution is its monitoring part to debug certain issues and find problems."
"The iPaaS functionality is very mature. The browser based IDE is also very mature and stable."
"The solution has a lot of connectors, which is quite helpful."
"I like the tool's optimization feature."
"The product's integration features are quite rich and low code. It is easy to use."
"It has been a stable product."
"It's very user-friendly and designed to be easy to use for the end user."
"Very effective with its drag-and-drop feature."
"The ETL capabilities are very useful for us. We extract and transform data from multiple data sources, into a single, consistent data store, and then we put it in our systems. We typically use it to connect our Apache Kafka with data lakes. That process is smooth and saves us a lot of time in our production systems."
"I have used Data Collector, Transformer, and Control Hub products from StreamSets. What I really like about these products is that they're very user-friendly. People who are not from a technological or core development background find it easy to get started and build data pipelines and connect to the databases. They would be comfortable like any technical person within a couple of weeks."
"The Ease of configuration for pipes is amazing. It has a lot of connectors. Mainly, we can do everything with the data in the pipe. I really like the graphical interface too"
"What I love the most is that StreamSets is very light. It's a containerized application. It's easy to use with Docker. If you are a large organization, it's very easy to use Kubernetes."
"StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or data type changes, it lands automatically into the data lake without any intervention from us, but then that information is crucial to fix for downstream pipelines, which process the data into models, like Tableau and Power BI models. This is actually very useful for us. We are already seeing benefits. Our pipelines used to break when there were data drift changes, then we needed to spend about a week fixing it. Right now, we are saving one to two weeks. Though, it depends on the complexity of the pipeline, we are definitely seeing a lot of time being saved."
"The most valuable features are the option of integration with a variety of protocols, languages, and origins."
"The scheduling within the data engineering pipeline is very much appreciated, and it has a wide range of connectors for connecting to any data sources like SQL Server, AWS, Azure, etc. We have used it with Kafka, Hadoop, and Azure Data Factory Datasets. Connecting to these systems with StreamSets is very easy."
"Important features include that it comprises lots of functionality to connect data from various sources through connector availability, scheduling pipelines at any time, and integration with third-party and security solutions for encryption."
"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."
"Boomi AtomSphere Integration is not yet exposed to the world as a good product owing to certain shortcomings in the area of marketing where improvements are required."
"The product could be a little bit more user-friendly."
"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 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."
"Have to create some of our own pre-built connectors."
"They should create a custom connector option. With this, they could improve where the user can create the connector, based on their usage."
"The solution is complex. There's a few items and features that are hard to understand. They should work to simplify the functionality so new users don't struggle."
"Using ETL pipelines is a bit complicated and requires some technical aid."
"They need to improve their customer care services. Sometimes it has taken more than 48 hours to resolve an issue. That should be reduced. They are aware of small or generic issues, but not the more technical or deep issues. For those, they require some time, generally 48 to 72 hours to respond. That should be improved."
"Visualization and monitoring need to be improved and refined."
"The design experience is the bane of our existence because their documentation is not the best. Even when they update their software, they don't publish the best information on how to update and change your pipeline configuration to make it conform to current best practices. We don't pay for the added support. We use the "freeware version." The user community, as well as the documentation they provide for the standard user, are difficult, at best."
"StreamSet works great for batch processing but we are looking for something that is more real-time. We need latency in numbers below milliseconds."
"We often faced problems, especially with SAP ERP. We struggled because many columns weren't integers or primary keys, which StreamSets couldn't handle. We had to restructure our data tables, which was painful. Also, pipeline failures were common, and data drifting wasn't addressed, which made things worse. Licensing was another issue we encountered."
"Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful."
"StreamSets should provide a mechanism to be able to perform data quality assessment when the data is being moved from one source to the target."
Boomi iPaaS is ranked 5th in Integration Platform as a Service (iPaaS) with 25 reviews while StreamSets is ranked 8th in Data Integration with 24 reviews. Boomi iPaaS is rated 7.8, while StreamSets is rated 8.4. The top reviewer of Boomi iPaaS writes "Stable product, suitable for limited integrations and lacks flexibility ". On the other hand, the top reviewer of StreamSets writes "We no longer need to hire highly skilled data engineers to create and monitor data pipelines". Boomi iPaaS is most compared with Microsoft Azure Logic Apps, webMethods Integration Server, SSIS, Oracle Integration Cloud Service and AWS Glue, whereas StreamSets is most compared with Fivetran, Informatica PowerCenter, Azure Data Factory, SSIS and IBM InfoSphere DataStage. See our Boomi iPaaS vs. StreamSets 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.