What is our primary use case?
We use Denodo to improve data governance and self-service BI.
We had several data environments, one data lake, one data warehouse, and another instance of data in another silo, and we needed to deliver this data to our end users in an organized manner.
It was very, powerful because we could deliver this data in a short time and with some data governance, because you deliver it through a data catalog and you have the data lineage, and you can put there the role level security, column level security, and it was very helpful for us, and the end-user was very happy to have it.
What is most valuable?
The most valuable aspects of this solution are the short time frame in which you can deliver and connect.
I don't have a single feature because I believe the ability to connect disparate data sources is extremely useful.
You can create a layer over these various data sources and deliver the data to the end user as a single data source. This, I believe, is the most powerful feature in Denodo, because it is data virtualization.
Consuming metadata from pipelines is something that would most likely be interesting. If we could integrate it, for example, with some ODI or some Data Factory, because if you have this, you might be able to take advantage of the work that the tech engineer has already done, and you might be able to turn Denodo into a more powerful solution because it can be used for more than just data virtualization.
What needs improvement?
The feature that you have to connect on LDAP needs improvement.
I am not sure if it's on Denodo's side, but sometimes it is very difficult to connect on LDAP, and you can take advantage of this by using the roles that have already been created there.
I have no complaints about Denodo's features, except perhaps the price.
For how long have I used the solution?
I have been using Denodo for approximately one and a half years.
I no longer use it, but when I did, I started with version 7 and by the end of the semester, I was using version 8.
It was deployed both on-premises and on the Cloud.
In one company, I use on-premise, and when I worked at a consulting firm, I assisted in deploying a cloud environment for our clients.
Buyer's Guide
Denodo
November 2024
Learn what your peers think about Denodo. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
What do I think about the stability of the solution?
Denodo is a stable solution.
Version 8 is much more stable than version 7.
What do I think about the scalability of the solution?
Denodo is scalable.
We had approximately 1,000 users.
I no longer work for the same company. However, as a consultant, I always try to bring it to my manager in order to sell it to our clients, because as someone who works with data governance, I believe Denodo is a powerful tool for reducing the time it takes to implement data governance while also providing organized self-service BI.
How are customer service and support?
The technical support is great.
I would rate them a five out of five.
Which solution did I use previously and why did I switch?
Previously, we used Dremio, which was the only solution that allowed us to use it for free due to its open-source nature. We tried Dremio, and during the PoC, we didn't try any other tool, but we could see some presentations about Data Virtuality, which is a German company if I'm not mistaken.
How was the initial setup?
It was a pleasant surprise to discover how simple it is to set up this environment.
We have a development team of five to maintain this solution.
What about the implementation team?
When doing the PoC, we did use the consultant.
When we went to production to deploy on our side, we did it ourselves, with Denodo's help, because it was included in our license.
What was our ROI?
Yes, we saw a return on investment.
What's my experience with pricing, setup cost, and licensing?
Depending on the size of the client you want to work with, it can be prohibitively expensive at times.
I am not sure how much it costs right now, but we did the PoC to justify purchasing the solution. It was approximately 1 million reais.
What other advice do I have?
I would say that it is critical that you have some business model built, because it will guide you on how to implement the data sets in Denodo because you need to consume several data sources, but you must put them in some way that has some meaning to the business, you must migrate from physical modeling to logical modeling and business modeling.
I would say you should incorporate these three layers into Denodo. To take advantage of Denodo, you must consider these three layers. Otherwise, you will just put some data there and no one will find it.
I would rate Denodo an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.