Try our new research platform with insights from 80,000+ expert users

Boomi iPaaS vs StreamSets comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Boomi iPaaS
Average Rating
8.0
Reviews Sentiment
7.0
Number of Reviews
27
Ranking in other categories
Integration Platform as a Service (iPaaS) (6th)
StreamSets
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
20
Ranking in other categories
Data Integration (15th)
 

Mindshare comparison

Boomi iPaaS and StreamSets aren’t in the same category and serve different purposes. Boomi iPaaS is designed for Integration Platform as a Service (iPaaS) and holds a mindshare of 10.2%, up 7.7% compared to last year.
StreamSets, on the other hand, focuses on Data Integration, holds 1.6% mindshare, up 1.3% since last year.
Integration Platform as a Service (iPaaS)
Data Integration
 

Featured Reviews

Eugene Paden - PeerSpot reviewer
Integration solution proves maturity and drives productivity
There are many features we're using. We're starting to do AI now regarding integration with other platforms, focusing on creating integrations. A significant area for improvement is version control. Currently, you develop and cannot properly roll back to a previous version unless you create different versions. With proper version control, you could know which version to revert to and test other versions.
Reyansh Kumar - PeerSpot reviewer
We no longer need to hire highly skilled data engineers to create and monitor data pipelines
The things I like about StreamSets are its * overall user interface * efficiency * product features, which are all good. Also, 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. You just need to configure the data sources, the paths and their configurations, and you are ready to go. It is very efficient and very easy to use for ETL pipelines. It is a GUI-based interface in which you can easily create or design your own data pipelines with just a few clicks. As for moving data into modern analytics systems, we are using it with Microsoft Power BI, AWS, and some on-premises solutions, and it is very easy to get data from StreamSets into them. No hardcore coding or special technical expertise is required. It is also a no-code platform in which you can configure your data sources and data output for easy configuration of your data pipeline. This is a very important aspect because if a tool requires code development, we need to hire software developers to get the task done. By using StreamSets, it can be done with a few clicks.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The platform is user-friendly."
"The Salesforce and NetSuite Application specific “connectors” provide a layer of abstraction on top of the SOAP-based APIs to streamline integration development."
"The product's initial setup phase was easy."
"It is easy to learn and implement."
"Boomi AtomSphere Integration is stable."
"AtomSphere Integration will suit those looking for small automation and simple integrations."
"This is a fairly easy-to-use tool for integration which can be self-taught for those with a bit of a technical background."
"Very effective with its drag-and-drop feature."
"The entire user interface is very simple and the simplicity of creating pipelines is something that I like very much about it. The design experience is very smooth."
"I really appreciate the numerous ready connectors available on both the source and target sides, the support for various media file formats, and the ease of configuring and managing pipelines centrally."
"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."
"StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes."
"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 best feature that I really like is the integration."
"Also, the intuitive canvas for designing all the streams in the pipeline, along with the simplicity of the entire product are very big pluses for me. The software is very simple and straightforward. That is something that is needed right now."
"In StreamSets, everything is in one place."
 

Cons

"There is no validation in the mapping profile custom scripting, such as IntelliSense or advanced error checking."
"It crashes if we run high-volume integration."
"The most valuable features of Boomi are the integration capabilities, the Data Hub product, and the UDI integration."
"There are stability issues."
"They should create a custom connector option. With this, they could improve where the user can create the connector, based on their usage."
"Documentation could be improved."
"The product could be a little bit more user-friendly."
"Have to create some of our own pre-built connectors."
"There aren't enough hands-on labs, and debugging is also an issue because it takes a lot of time. Logs are not that clear when you are debugging, and you can only select a single source for a pipeline."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
"In terms of the product, I don't think there is any room for improvement because it is very good. One small area of improvement that is very much needed is on the knowledge base side. Sometimes, it is not very clear how to set up a certain process or a certain node for a person who's using the platform for the first time."
"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."
"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've seen a couple of cases where it appears to have a memory leak or a similar problem."
"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."
"I would like to see it integrate with other kinds of platforms, other than Java. We're going to have a lot of applications using .NET and other languages or frameworks. StreamSets is very helpful for the old Java platform but it's hard to integrate with the other platforms and frameworks."
 

Pricing and Cost Advice

"AtomSphere Integration's pricing is competitive, and I would rate it seven out of ten."
"The pricing is not reasonable at all. It's very high."
"Boomi AtomSphere Integration is expensive. I rate its pricing an eight out of ten."
"This solution is very economical (based on the connections)."
"The pricing is a bit complex. While the entry fee may be lower than other solutions, it could be expensive depending on your usage."
"Approximately 20k annually."
"When it comes to pricing, it's not so much about being less expensive as it is about how they don't tie to the hardware on the underlined VMware that you run on, as other vendors do"
"They do not charge by the number of people using the software (client-server model), but rather they charge based on the number of connections used. This makes it very cost effective."
"The pricing is too fixed. It should be based on how much data you need to process. Some businesses are not so big that they process a lot of data."
"There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."
"We use the free version. It's great for a public, free release. Our stance is that the paid support model is too expensive to get into. They should honestly reevaluate that."
"The pricing is affordable for any business."
"It has a CPU core-based licensing, which works for us and is quite good."
"We are running the community version right now, which can be used free of charge."
"The licensing is expensive, and there are other costs involved too. I know from using the software that you have to buy new features whenever there are new updates, which I don't really like. But initially, it was very good."
"Its pricing is pretty much up to the mark. For smaller enterprises, it could be a big price to pay at the initial stage of operations, but the moment you have the Seed B or Seed C funding and you want to scale up your operations and aren't much worried about the funds, at that point in time, you would need a solution that could be scaled."
report
Use our free recommendation engine to learn which Integration Platform as a Service (iPaaS) solutions are best for your needs.
839,422 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
15%
Manufacturing Company
11%
Financial Services Firm
10%
Government
6%
Financial Services Firm
16%
Computer Software Company
11%
Manufacturing Company
10%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Boomi AtomSphere Integration?
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...
What is your experience regarding pricing and costs for Boomi AtomSphere Integration?
Pricing varies and they have changed it over the years. It depends on the company size and the value derived from the platform. While pricing is relative, compared to others, it is favorable. Clien...
What needs improvement with Boomi AtomSphere Integration?
There are many features we're using. We're starting to do AI now regarding integration with other platforms, focusing on creating integrations. A significant area for improvement is version control...
What do you like most about StreamSets?
The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customiz...
What needs improvement with StreamSets?
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 ...
What is your primary use case for StreamSets?
StreamSets is used for data transformation rather than ETL processes. It focuses on transforming data directly from sources without handling the extraction part of the process. The transformed data...
 

Comparisons

 

Also Known As

Boomi
No data available
 

Overview

 

Sample Customers

DocuSign Inc., Innotas, Certent, Renesas Electronics America (REA), Kelly-Moore Paints, Mindjet, City of McKinney, Ritchie Bros. Auctioneers (RBA), Daylight Transport, A10 Networks
Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
Find out what your peers are saying about Boomi iPaaS vs. StreamSets and other solutions. Updated: July 2023.
839,422 professionals have used our research since 2012.