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

Boomi iPaaS vs StreamSets comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Boomi iPaaS
Average Rating
7.8
Reviews Sentiment
7.0
Number of Reviews
26
Ranking in other categories
Integration Platform as a Service (iPaaS) (6th)
StreamSets
Average Rating
8.4
Number of Reviews
24
Ranking in other categories
Data Integration (9th)
 

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 8.9%, up 8.4% compared to last year.
StreamSets, on the other hand, focuses on Data Integration, holds 1.7% mindshare, up 1.3% since last year.
Integration Platform as a Service (iPaaS)
Data Integration
 

Featured Reviews

Berniem Elfrink - PeerSpot reviewer
Dec 7, 2023
A tool that is easy to use, cost-effective, and offers a large set of functionalities
I use Boomi AtomSphere Integration in my company to manage all types of integrations, including SAP integrations, database integrations, and other enterprise-level integrations The most valuable features of the solution are its mapping functionality and the low-code, no-code nature of the…
Reyansh Kumar - PeerSpot reviewer
Mar 10, 2023
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 Salesforce and NetSuite Application specific “connectors” provide a layer of abstraction on top of the SOAP-based APIs to streamline integration development."
"It has been a stable product."
"The most valuable feature of the solution is its monitoring part to debug certain issues and find problems."
"I have found the solution to be scalable."
"It's very user-friendly and designed to be easy to use for the end user."
"Boomi iPaaS has substantially reduced operational costs by providing out-of-the-box connectors that expedite the integration process with enterprise systems."
"The integration landscape has become complex, and having a data strategy with unified data models would make integration easier for any platform, including Boomi."
"I really appreciate the on-the-go access through the browser and the B2B integration."
"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."
"It is really easy to set up and the interface is easy to use."
"One of the things I like is the data pipelines. They have a very good design. Implementing pipelines is very straightforward. It doesn't require any technical skill."
"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 UI is user-friendly, it doesn't require any technical know-how and we can navigate to social media or use it more easily."
"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."
"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."
 

Cons

"It crashes if we run high-volume integration."
"There are very few string handling functions and few mathematical functions are available."
"The API can use some work to come up to speed with the competition but Dell has plans and is working on resolving that."
"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."
"Documentation could be improved."
"They are lacking in some streaming features, and messaging features from a listener's point of view."
"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."
"Lots of enhancements are needed in the API portal so that the developers can view the definitions, try out the APIs, etc."
"Sometimes, it is not clear at first how to set up nodes. A site with an explanation of how each node works would be very helpful."
"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."
"Visualization and monitoring need to be improved and refined."
"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."
"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."
"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."
"The execution engine could be improved. When I was at their session, they were using some obscure platform to run. There is a controller, which controls what happens on that, but you should be able to easily do this at any of the cloud services, such as Google Cloud. You shouldn't have any issues in terms of how to run it with their online development platform or design platform, basically their execution engine. There are issues with that."
"Using ETL pipelines is a bit complicated and requires some technical aid."
 

Pricing and Cost Advice

"The cost of the solution is in the neighborhood of $20,000 annually. There are no costs above the standard licensing fee."
"I rate the product's price an eight on a scale of one to ten, where one is cheap and ten is expensive."
"The Platinum package is good for licensing, but I’m not sure about the cost and improvements."
"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."
"There could be an easy-to-understand licensing model."
"This solution is very economical (based on the connections)."
"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."
"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."
"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."
"The overall cost is very flexible so it is not a burden for our organization... However, the cost should be improved. For small and mid-size organizations it might be a challenge."
"StreamSets is expensive, especially for small businesses."
"StreamSets is an expensive solution."
"The pricing is affordable for any business."
"It's not so favorable for small companies."
"It has a CPU core-based licensing, which works for us and is quite good."
report
Use our free recommendation engine to learn which Integration Platform as a Service (iPaaS) solutions are best for your needs.
815,854 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
18%
Manufacturing Company
10%
Financial Services Firm
9%
Government
6%
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
8%
Insurance Company
6%
 

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?
Boomi AtomSphere Integration is a relatively cheap and cost-effective product compared to other products like SAP or Oracle. I don't know the exact price of the product.
What needs improvement with Boomi AtomSphere Integration?
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 us...
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
 

Learn More

Video not 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.
815,854 professionals have used our research since 2012.