Denodo vs StreamSets comparison

Cancel
You must select at least 2 products to compare!
Denodo Logo
5,210 views|3,227 comparisons
93% willing to recommend
StreamSets Logo
4,200 views|2,349 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Denodo 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.
To learn more, read our detailed Denodo vs. StreamSets Report (Updated: May 2024).
771,740 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It can support a number of data sources, and it can pull flat files, from cloud-based databases or from those on-premises. Denodo can pull from any data source and interface with the view. Then, we can publish the view.""The ability to transfer data is very valuable.""In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously.""Denodo's best features are its performance, easy data transformation, and the job scheduler.""The most valuable aspects of this solution are the short time frame in which you can deliver and connect.""The performance and the speed to market are the most valuable features of this solution.""Denodo makes it easy to export data as a service or data link to other services.""This solution provides us with the ability to sync data, and make it available for anyone to use across the business."

More Denodo Pros →

"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.""The most valuable feature is the pipelines because they enable us to pull in and push out data from different sources and to manipulate and clean things up within them.""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""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.""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.""The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows.""It is a very powerful, modern data analytics solution, in which you can integrate a large volume of data from different sources. It integrates all of the data and you can design, create, and monitor pipelines according to your requirements. It is an all-in-one day data ops solution.""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."

More StreamSets Pros →

Cons
"The feature that you have to connect on LDAP needs improvement.""The support is not the best and should be improved.""The git configuration really should be improved.""Denodo's training documentation could be improved by providing more material. From an administrative standpoint, I've found that only Denodo websites provide the usual tutorials. It may be because it's a bit of a restricted tool, but it results in trouble with learning. Normally, I can find help and solutions from other sources, but I haven't been able to find any for Denodo. Other that, it's fine and it performs well. I only have six months of experience, so I can't accurately suggest improvements.""Denodo can improve usage management-related aspects. If you deal with the mini views, it gets stuck. The performance is very slow when we go with a large number of views and high volume.""Performance management could be improved.""It would be good if the solution provided a much-needed cellular platform.""I would like to see a proper way to avoid killing the sourcing systems."

More Denodo Cons →

"We've seen a couple of cases where it appears to have a memory leak or a similar problem.""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.""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.""The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base.""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.""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.""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.""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."

More StreamSets Cons →

Pricing and Cost Advice
  • "The licensing should be improved, as the cost per connector is quite expensive."
  • "I don't know the actual cost, but it's tens of thousands of dollars per month."
  • "The licensing charges for this solution are payable annually."
  • "The pricing is pretty good, and I would rate it at four out of five."
  • "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."
  • "Depending on the size of the client you want to work with, it can be prohibitively expensive at times."
  • "There is an express edition and a licensed enterprise edition."
  • "Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."
  • More Denodo Pricing and Cost Advice →

  • "We are running the community version right now, which can be used free of charge."
  • "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."
  • "It has a CPU core-based licensing, which works for us and is quite good."
  • "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."
  • "The pricing is good, but not the best. They have some customized plans you can opt for."
  • "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 overall cost for small and mid-size organizations needs to be better."
  • "There are two editions, Professional and Enterprise, and there is a free trial. We're using the Professional edition and it is competitively priced."
  • More StreamSets Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    771,740 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 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 it… more »
    Top Answer: 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… more »
    Top Answer: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… more »
    Top Answer: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 customize… more »
    Top Answer: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… more »
    Top Answer: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 is… more »
    Ranking
    12th
    out of 101 in Data Integration
    Views
    5,210
    Comparisons
    3,227
    Reviews
    20
    Average Words per Review
    718
    Rating
    7.8
    8th
    out of 101 in Data Integration
    Views
    4,200
    Comparisons
    2,349
    Reviews
    22
    Average Words per Review
    1,306
    Rating
    8.4
    Comparisons
    Azure Data Factory logo
    Compared 15% of the time.
    AWS Glue logo
    Compared 6% of the time.
    Delphix logo
    Compared 6% of the time.
    Mule Anypoint Platform logo
    Compared 6% of the time.
    Informatica PowerCenter logo
    Compared 5% of the time.
    Learn More
    StreamSets
    Video Not Available
    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.

    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.

    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
    Top Industries
    REVIEWERS
    Financial Services Firm25%
    Manufacturing Company19%
    Computer Software Company13%
    Comms Service Provider6%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Manufacturing Company10%
    Computer Software Company9%
    Energy/Utilities Company8%
    REVIEWERS
    Financial Services Firm21%
    Energy/Utilities Company21%
    Comms Service Provider14%
    Computer Software Company14%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company13%
    Manufacturing Company8%
    Government7%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise13%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise9%
    Large Enterprise78%
    REVIEWERS
    Small Business40%
    Midsize Enterprise12%
    Large Enterprise48%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise74%
    Buyer's Guide
    Denodo vs. StreamSets
    May 2024
    Find out what your peers are saying about Denodo vs. StreamSets and other solutions. Updated: May 2024.
    771,740 professionals have used our research since 2012.

    Denodo is ranked 12th in Data Integration with 29 reviews while StreamSets is ranked 8th in Data Integration with 24 reviews. Denodo is rated 7.8, while StreamSets is rated 8.4. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". 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". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Informatica PowerCenter, whereas StreamSets is most compared with Fivetran, Azure Data Factory, Informatica PowerCenter, SSIS and IBM InfoSphere DataStage. 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.