Denodo vs StreamSets comparison

Denodo and IBM are both solutions in the Data Integration category. Denodo is ranked #10 with an average rating of 8.9, while IBM is ranked #9 with an average rating of 8.5. Denodo holds a 1.8% mindshare in DI, compared to IBM’s 1.6% mindshare. Additionally, 94% of Denodo users are willing to recommend the solution, compared to 100% of IBM users who would recommend it.

Denodo

Read 36 Denodo reviews

4,082 Views
2,471 Comparison Views

94% willing to recommend

StreamSets

Read 20 StreamSets reviews

2,753 Views
1,836 Comparison Views

100% willing to recommend

Denodo

StreamSets

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

Denodo and StreamSets compete in the data management category. Denodo has the upper hand with its data virtualization and integration, while StreamSets stands out for its ETL and data migration capabilities.

Features: Denodo excels in data virtualization and integration with notable features such as data abstraction, seamless integration, and advanced performance. StreamSets is recognized for its intuitive pipeline design, data manipulation, and integration capabilities with modern analytics platforms.

Room for Improvement: Denodo users point out the need for a better data catalog, improved integration, and enhanced support documentation. StreamSets users suggest simpler GUI, a better security model, and faster data processing. Both products could benefit from improved troubleshooting documentation and more straightforward logging and debugging processes.

Ease of Deployment and Customer Service: Denodo is versatile with on-premises, hybrid, and public cloud deployment models, receiving positive feedback for support and documentation. StreamSets is predominantly used in public and hybrid clouds, praised for robust technical support. Both could improve by offering more training and better documentation.

Pricing and ROI: Denodo is expensive and caters to large enterprises but offers quick ROI due to data processing efficiencies. StreamSets provides flexible pricing, including free and paid versions; however, costs can be challenging for smaller businesses. Both deliver significant ROI by enhancing data management and reducing operational times.

To learn more, read our detailed Denodo vs. StreamSets Report (Updated: January 2025).

Buyer's Guide

Denodo vs. StreamSets

January 2025

Download the complete report

Helped 832,138 peers since 2012

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

Denodo

Ranking in Data Integration

10th

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Virtualization (1st), Cloud Data Integration (6th)

StreamSets

Ranking in Data Integration

9th

Average Rating

8.4

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of Denodo is 1.8%, down from 1.9% compared to the previous year. The mindshare of StreamSets is 1.6%, up from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Vishal_Goyal

Director Software Engineer at Clarivate

The data catalog feature helps define data structures without storing data

The data catalog feature is valuable as it helps define data structures without storing data. Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy. It supports API usage to call and present data in JSON or Tableau format without visualization capabilities.

Read full review

Reyansh Kumar

Technical Specialist at Accenture

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.

Read full review

Quotes from Members

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

Pros

"Denodo's capabilities offer a strong and intuitive solution for data access."

"The most valuable feature in Denodo is data virtualization."

"Denodo provides high reliability, with features like vertical scaling, horizontal scaling, and failover nodes."

"The data abstraction is the most valuable feature."

"The ability to transfer data is very valuable."

"In general, it's good for us to make tests so we can scout the data."

"The most valuable feature is Data Catalogs."

"The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."

More Denodo pros

"The most valuable features are the option of integration with a variety of protocols, languages, and origins."

"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."

"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."

"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."

"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."

"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."

"The ability to have a good bifurcation rate and fewer mistakes is valuable."

More StreamSets pros

Cons

"The stability of the features can be improved."

"It requires improving the story of how it can solve specific problems."

"The solution should have its own acceleration technology."

"Tasks such as conversion of a date format or conversion of a number format that can be done in a very easy way in different languages, like SQL or Oracle, are not so easy to do in Denodo. For example, if you want to convert a date from one format to another, in Oracle it's pretty easy; in Denodo, however, it requires so many lines of code. Simple things that can be done very quickly in other database languages require more lines of code in Denodo."

"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."

"I would like to see a proper way to avoid killing the sourcing systems."

"Denodo has some difficulty supporting large numbers of records."

"Data transformation must be improved."

More Denodo cons

"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."

"If you use JDBC Lookup, for example, it generally takes a long time to process data."

"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."

"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."

"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."

"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."

"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."

"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."

More StreamSets cons

Pricing and Cost Advice

"The cost for Denodo is in line with other similar products."

"I am not super familiar with the pricing, but so far, it seems good. We have been happy. We haven't seen any problems. The only time we had to pay extra was during the upgrade. We didn't upgrade at the time they told us to upgrade, and we had to pay extra to keep the service. They had stopped the support for the older version and moved to the newer version. It was not their fault. It was our fault because we didn't get on board quickly."

"Cost wise, on a scale from one to five, with one being the cheapest and five being the most expensive, Denodo would be at three. We get all the features in a bundle."

"For us, the cost has been okay. Also, there are no additional costs; it's just the standard licensing fee."

"The licensing charges for this solution are payable annually."

"The licensing should be improved, as the cost per connector is quite expensive."

"Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."

"The pricing is pretty good, and I would rate it at four out of five."

More Denodo pricing and cost advice

"It's not so favorable for small companies."

"The pricing is affordable for any business."

"There are two editions, Professional and Enterprise, and there is a free trial. We're using the Professional edition and it is competitively priced."

"We are running the community version right now, which can be used free of charge."

"StreamSets is an expensive solution."

"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 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."

"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."

More StreamSets pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

832,138 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

21%

Manufacturing Company

11%

Computer Software Company

10%

Government

Financial Services Firm

18%

Computer Software Company

11%

Manufacturing Company

10%

Insurance Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

Does Denodo provide useful data virtualization education? Is it useful to attend their training?

If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit from it, including administrators, developers, and architects. If you are keen on i...

See all answers

In experience, what might Denodo be lacking or need improvement on?

I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I think make the product less good or effective. The only thing I can point out is...

See all answers

Which industries can benefit from Denodo the most?

Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data fabric Master data management In my opinion, organizations in different fields...

See all answers

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...

See all answers

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 ...

See all answers

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...

See all answers

Comparisons

Azure Data Factory vs Denodo

Compared 14% of the time

MuleSoft Anypoint Platform vs Denodo

Compared 9% of the time

Delphix vs Denodo

Compared 8% of the time

Informatica PowerCenter vs Denodo

Compared 6% of the time

AWS Glue vs Denodo

Compared 6% of the time

More Denodo Competitors

Informatica PowerCenter vs StreamSets

Compared 13% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 11% of the time

Fivetran vs StreamSets

Compared 9% of the time

webMethods.io vs StreamSets

Compared 9% of the time

Azure Data Factory vs StreamSets

Compared 8% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Denodo

February 2025

Download Denodo product report

Buyer's Guide

StreamSets

January 2025

Download StreamSets product report

Overview

Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.

The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.

Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.

Denodo Features

At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:

Scalability: Denodo can scale from departmental or project to enterprise-wide with geographically distributed nodes. It can also handle large transactional loads of users, sources, and transactions as well as analytical loads of data volumes.
Query optimizers: This feature offers advanced cost-based and source constraint-based query optimization that includes query rewrite, query delegations, data movements, and join optimization.
Intelligent caching: This feature makes full, portal, and time-based caching possible.
Fine-grained security model: This Denodo feature makes integration with external systems possible.
Monitoring and auditing: Denodo offers enterprise-grade monitoring and auditing, which allows for integration with system management products, including Tivoli, Unicenter, and HP BTO.
Development and deployment support: The product offers full lifecycle support for the development and deployment of applications, providing users with all required tools.

Denodo Benefits

Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:

The solution accelerates time to market for all types of business data through its services.
Denodo provides IT agility, which helps companies respond to business-changing demands in a timely manner.
Users can decide how much data replication they want to reduce through Denodo and use the product in full control.
The solution meets the industry's security and privacy requirements by providing high-grade protection for users' data.
Users can benefit from centralized control of data query executions for complete governance and full security.
Denodo offers legacy replacement, multi-cloud deployments, and cloud migrations with minimal disruptions and a fair price.
The solution utilizes artificial intelligence (AI) and machine learning (ML) to unlock data potential for customers.

Reviews from Real Users

Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.

Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.

Denodo

StreamSets is a data integration platform that enables organizations to efficiently move and process data across various systems. It offers a user-friendly interface for designing, deploying, and managing data pipelines, allowing users to easily connect to various data sources and destinations. StreamSets also provides real-time monitoring and alerting capabilities, ensuring that data is flowing smoothly and any issues are quickly addressed.

IBM

Sample Customers

Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta

Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge

Buyer's Guide

Denodo vs. StreamSets

January 2025

Free Report: Denodo vs. StreamSets

Find out what your peers are saying about Denodo vs. StreamSets and other solutions. Updated: January 2025.

DOWNLOAD NOW

832,138 professionals have used our research since 2012.

See our Denodo vs. StreamSets report.

See our list of best Data Integration vendors and best Cloud 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.