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

SAP Data Services vs StreamSets comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024
 

Categories and Ranking

SAP Data Services
Ranking in Data Integration
10th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
48
Ranking in other categories
Data Quality (2nd)
StreamSets
Ranking in Data Integration
9th
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
22
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the Data Integration category, the mindshare of SAP Data Services is 2.8%, down from 3.4% compared to the previous year. The mindshare of StreamSets is 1.8%, up from 1.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

RambabuMandala - PeerSpot reviewer
Responsive support, scalable, and beneficial integration
The BA reporting tools, such as Data Services, and ETL tool in SAP Data Services are the most valuable. When we had in-memory requirements, we used HANA. HANA is most preferably for most the customers for in-memory. SAP is the first company that created the in-memory concept. There are a lot of SAP applications and they have good integration with SAP packages. In the next release, they should be more advanced cloud functionalities and web services. More integration with other applications including SAPs and other applications. They should not switch to a complete solution but provide better integration with other applications.
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 fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
"The product's most valuable features are data validation and rules."
"The initial setup is not complex."
"Its integration capabilities and the data migration capabilities are the most valuable. It is very good for SAP and non-SAP tools. It has very good integration with SAP, but it also has the capabilities to connect to other systems. We find it very helpful and stable."
"You can always manipulate a lot of things as long as you have the skill level."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"The maintenance of data services is the solution's most valuable feature."
"I appreciate having access to the SAP data."
"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."
"The ability to have a good bifurcation rate and fewer mistakes is valuable."
"For me, the most valuable features in StreamSets have to be the Data Collector and Control Hub, but especially the Data Collector. That feature is very elegant and seamlessly works with numerous source 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 best feature that I really like is the integration."
"It's very easy to integrate. It integrates with Snowflake, AWS, Google Cloud, and Azure. It's very helpful for DevOps, DataOps, and data engineering because it provides a comprehensive solution, and it's not complicated."
"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."
"It is really easy to set up and the interface is easy to use."
 

Cons

"Some of the jobs that are built within Data Services require local files, and during initial deployment, those local files cannot be transported between machines simply because of security issues."
"An area for improvement in SAP Data Services could involve making the product more accessible to non-technical end-users."
"The solution should improve connectivity with more source systems and target systems."
"At the integration level, there could be certain set of improvement to connect to various other systems."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
"The initial setup is complex."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"It's an ETL that is very good with relational databases but not as good with files and semi-structured files."
"The data collector in StreamSets has to be designed properly. For example, a simple database configuration with MySQL DB requires the MySQL Connector to be installed."
"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."
"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."
"The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base."
"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."
"The software is very good overall. Areas for improvement are the error logging and the version history. I would like to see better, more detailed error logging information."
"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."
"StreamSet works great for batch processing but we are looking for something that is more real-time. We need latency in numbers below milliseconds."
 

Pricing and Cost Advice

"Speaking about prices, Oracle and SAP are market leaders. So, the prices are more."
"The license price is expensive but medium to large-scale companies, should be able to afford it. Other solutions, such as Talend are easier to afford for smaller companies. Depending on the sources of the data where you are receiving your data you could be paying for more than one license."
"There is a one time purchase fee plus annual maintenance."
"The pricing is a little high to make the product more competetive in the marketplace."
"The product’s on-premise version is expensive for a medium-sized company."
"The price of SAP Data Services is a little high when compared to other solutions. Due to the pricing and capabilities, many clients are switching to other solutions."
"I rate the product price as one or two on a scale of one to ten, where one is a low price, and ten is a high price."
"The enterprise version of SAP Data Services is free."
"StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."
"There are two editions, Professional and Enterprise, and there is a free trial. We're using the Professional edition and it is competitively priced."
"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."
"We are running the community version right now, which can be used free of charge."
"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."
"It's not expensive because you pay per month, and the tasks you can perform with it are huge. It's reliable and cost-effective."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
824,067 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
16%
Computer Software Company
12%
Financial Services Firm
9%
Government
8%
Financial Services Firm
17%
Computer Software Company
10%
Manufacturing Company
10%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How do you evaluate the ratio of price to quality for SAP Data Services?
I believe the license for the product is fair, even though some competitors offer similar services at lower prices. The difference between the Edge edition and the next one up is significant in pr...
Would you recommend SAP Data Services to complete beginners?
I think after some preparation, a beginner will be able to use SAP Data Services, however, if you are completely unprepared, you may have some issues. I think that in particular you will need a mo...
How has SAP Data Services helped your organization?
SAP Data Services has helped our whole staff understand the data across various sources and systems within the company. Not everyone who works at my organization is an IT expert - most just have av...
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...
 

Also Known As

SAP BusinessObjects Data Services, SAP BusinessObjects Data Integrator, BusinessObjects Data Integrator
No data available
 

Learn More

Video not available
 

Overview

 

Sample Customers

EMC Corporation, LivePerson, Eldorado, Mozzart, The VELUX Group, AOK Bundesverband, Hilti Group, Nissha Printing Company Ltd., Asian Paints, Aareal Bank Group, Migros Group
Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
Find out what your peers are saying about SAP Data Services vs. StreamSets and other solutions. Updated: November 2024.
824,067 professionals have used our research since 2012.