We performed a comparison between SAP Data Services and StreamSets based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature is the logging capability."
"It is a powerful product with a broad range of features."
"It's easy to understand and deploy. It's easy to create new applications, and depending on the complexity of the application, it is easy to deploy the new requirements."
"The logic is also simple. It makes it easy to build your extraction."
"Data Services' table comparison mechanism is very powerful. It's pretty hard to find a similar feature in other solutions."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"The feature of SAP Data Services has enhanced our company's business processes because we are able to run around 800 jobs in areas like data extraction and transaction objects."
"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 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."
"StreamSets Transformer is a good feature because it helps you when you are developing applications and when you don't want to write a lot of code. That is the best feature overall."
"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 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."
"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."
"The description of error messages isn't extensive, although they point to the problem. With other solutions, like Talend, I was able to use the debugger to get directly to the problem, but with SAP Data Services the debugger is not working. I'm not sure if it's a problem with the version specifically, but I'm using it in an enterprise environment and I can't do an upgrade."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"The solution shows a lack of cloud support data services."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"The migration of the solution between different environments is quite complex."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"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."
"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."
"We've seen a couple of cases where it appears to have a memory leak or a similar problem."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
"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."
"I would like to see further improvement in the UI. In addition, upgrades are not automatic and they should be automated. Currently, we have to manually upgrade versions."
"The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base."
"Sometimes, when we have large amounts of data that is very efficiently stored in Hadoop or Kafka, it is not very efficient to run it through StreamSets, due to the lack of efficiency or the resources that StreamSets is using."
"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."
SAP Data Services is ranked 10th in Data Integration with 45 reviews while StreamSets is ranked 8th in Data Integration with 24 reviews. SAP Data Services is rated 8.0, while StreamSets is rated 8.4. The top reviewer of SAP Data Services writes "Responsive support, scalable, and beneficial integration". 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". SAP Data Services is most compared with Azure Data Factory, Syniti Data Quality, Informatica PowerCenter, SAP Process Orchestration and Palantir Foundry, whereas StreamSets is most compared with Fivetran, Azure Data Factory, Informatica PowerCenter, SSIS and IBM InfoSphere DataStage. See our SAP Data Services vs. StreamSets report.
See our list of best Data Integration vendors.
We monitor all Data Integration 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.