Denodo for AWS
Effortless Data Virtualization with Top-Notch Security
High-Performance Data Virtualization with Minor Scaling Hiccups
Data virtualization has unified siloed sources and now supports real-time decisions
What is our primary use case?
My main use case for Denodo is that we have very decentralized data sources from different legacy applications, so this tool is very useful for us to connect all these legacy systems. This tool is very helpful for our data discovery and mapping. Getting real data from APIs and combining data from multiple systems were major challenges, which were solved by Denodo within a minimum replication cost.
A specific example of how Denodo helped me connect those legacy systems is that this tool is very easy to use and supports a multi-database infrastructure. We have a very large enterprise and we are blending data across the enterprise. What Denodo has helped us achieve is both federated and non-federated data with the same reusable data structure.
Regarding my main use case with Denodo, I also use it to build and send our data service to our partners and stakeholders and provide a real-time data experience to them. It is really easy to use, fast, and secure. Additionally, it is possible to combine many sources of data and integrate them with one tool.
What is most valuable?
The best features Denodo offers stand out to me as the ability to develop REST web services fast and easily, create and combine new views, integrate different sources of data, and connect with other tools seamlessly.
When I mention fast and easy creation of views and integration, I love the agile data provisioning and integration, where Denodo provides a comprehensive set of capabilities for implementing logical data integration, management, and delivery, which in turn enables agile data analytics and an informed decision-making process to be smooth. I also appreciate the performance optimization with AI, which improves performance optimization through the integration of artificial intelligence capabilities. Furthermore, I appreciate the unified security and governance, where it addresses the need for an organization to effectively manage security, data privacy, and data protection easily, offering a centralized platform that allows the application of governance policies and fine-grained security controls.
Another feature I would add about Denodo is that it also provides a single point of control where we can establish security controls over the entire infrastructure and gain visibility into all our data assets.
Denodo has positively impacted my organization as since we started using this tool, it has been very helpful because it is a huge advantage that we can connect to many different databases to provide data rapidly and accurately and also gain insights, which helps us to make data-driven decisions easily. It has proven to be a valuable environment for deploying data virtualization solutions, and its user community is active in finding and fixing issues more accurately.
Through data insights from Denodo, we have been able to improve our decision making, which helps to better communication between the stakeholders thanks to the real-time experience. It also saves a lot of time.
What needs improvement?
Denodo can be improved as it can be a little buggy, especially when dealing with huge data and is not great if you have very large volumes of data because it can be buggy.
To add more about the needed improvements for Denodo, I think the user interface should be improved to be more user-friendly and intuitive, especially for those new users who find the learning curve a bit steep.
For how long have I used the solution?
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
How are customer service and support?
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
What was our ROI?
I have seen a positive return on investment for one client who was paying too much for an existing legacy reporting platform that has not been updated in decades. For another client that did not have any traditional BI tools, Denodo is the perfect tool. It provides a positive experience for end users who can now run reports using multiple near real-time data sources, and a positive return on investment for those who can connect multiple data sources and make data-driven decisions easily.
What's my experience with pricing, setup cost, and licensing?
Which other solutions did I evaluate?
The reason why we switched from Cisco Composite to Denodo is that we evaluated other data visualization platforms such as Cisco Composite and found that Composite had an even smaller community and less support than Denodo. Denodo is putting a lot of the revenue earned from licensing cost to grow the product, and we did not get that impression from Composite.
What other advice do I have?
The advice I would give to others looking into using Denodo is that it is very well suited for large organizations with siloed datasets. Denodo thrives in these environments since large organizations can afford the licensing cost and are always tasked to mash up data from multiple environments through the organization. It helps to make data-driven decisions more easily and is very cost-effective, so I highly recommend it as a tool. I would rate this product a 9 out of 10.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Virtualized data governance has simplified secure warehousing and accelerated analytics delivery
What is our primary use case?
I am switching from Denodo to other solutions. Currently, I work as a Data Engineer Team Lead, where I work with Oracle Data Integrator (ODI), Power BI, and sometimes Tableau. I use Oracle Data Integrator as my primary tool.
Denodo is part-time work with a Saudi company. My main position involves working as a team lead for ODI and Power BI. As a consultant, I determine whether Denodo is used in companies or if their customers are using it.
My Saudi company is Denodo partner in Egypt, and we work for clients in Saudi Arabia. I have been working with Denodo for the last three years.
What is most valuable?
I find the features related to data governance most valuable. The data catalog is particularly interesting, and it provides an overall point of view that is useful.
From my experience as a data engineering team lead, I can build a data warehouse in just a minute from different sources without needing time for data transfer or any additional work.
What needs improvement?
Denodo can be improved by entering new markets. I am in Egypt now, and I think there are not enough companies dealing with Denodo. I faced issues when trying to find a new job using Denodo in Egypt, as it is very hard to find opportunities.
Denodo should tap into new markets in the Middle East. Last year, I gave training for Saudi clients in Dubai, and even in Dubai, it needs time to find training centers or trainers to help spread Denodo practices.
For how long have I used the solution?
I have been working with Denodo for the last three years.
What do I think about the stability of the solution?
I experienced a performance-related issue the last time I dealt with my client in Saudi Arabia, but I solved it by using some workarounds.
What do I think about the scalability of the solution?
The issue I faced was related to data volume. My client has almost 100 million records, and the performance was impacted in a way that required optimization.
How are customer service and support?
I did not always contact technical support from Denodo. I only contacted them when I took an exam as I am a certified Denodo consultant and developer.
I faced a problem during the installation of Denodo on my laptop, and they helped me greatly to bypass this issue. This happened two years ago.
Which solution did I use previously and why did I switch?
I solved the problem by myself.
How was the initial setup?
The implementation is not complex at all for Denodo.
What about the implementation team?
Denodo's security features are very aligned with my customer expectations. I can implement row-level security or column-level security, and I can hide columns from some departments. These security capabilities are very interesting.
What was our ROI?
I am satisfied with the performance for sure.
What's my experience with pricing, setup cost, and licensing?
I did not deal with the pricing of Denodo as my company's financial requirements are managed by another team, so I do not know how much it costs.
Which other solutions did I evaluate?
Denodo's interoperability options make the integration process very easy.
What other advice do I have?
I experienced something interesting when I integrated Denodo with SAP, and it was fantastic. Data governance is something very interesting as Denodo helped clients get what they need.
I did not use the new AI features, as I expect no additional features from them related to generative AI. I did not deal with vector databases and do not have experience with them. I would generally recommend Denodo to others. They need to promote the product in the Middle East, but I am recommending Denodo to different companies. I give this review a rating of eight out of ten.
Denodo’s Real-Time Data Virtualization Makes Integration Fast and Flexible
Improved test data validation and latency has revealed client dependencies that still need refinement
What is our primary use case?
What is most valuable?
What needs improvement?
For how long have I used the solution?
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
How are customer service and support?
What about the implementation team?
What was our ROI?
Which other solutions did I evaluate?
What other advice do I have?
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Data cataloging has unified access and supports reusable APIs across diverse projects
What is our primary use case?
My main use cases for Denodo involve implementing APIs to connect different data sources with new software to improve the process in Ecopetrol.
What is most valuable?
Denodo's best features are that it is very user-friendly and easy to use. It is flexible, and the data catalog is very useful.
The data cataloging has helped me in data discovery because this feature is very useful. All the people of the company can find different data for different projects. We created a data catalog for the company and to publish the API, and the different projects can use the APIs and reuse them.
What needs improvement?
To make it easier to use or a better tool, the architecture and internal design of the folders for organizing the structure of the different data could be more structured. Denodo does not have a guide for easily structuring the data.
For how long have I used the solution?
In the last 12 months, I am not still working with Denodo. This year I have not, but last December, I was using it.
What do I think about the stability of the solution?
Denodo is stable and good. I do not have crashes normally.
What do I think about the scalability of the solution?
My thoughts on scalability are that it is good because I can use different setups or configurations.
How are customer service and support?
I do not use the technical support, so I cannot rate the customer service or technical support.
Which solution did I use previously and why did I switch?
I have not evaluated other data integration tools before because Denodo was the tool in the project and I do not see other tools.
How was the initial setup?
The initial setup of Denodo was medium complex.
What's my experience with pricing, setup cost, and licensing?
I do not know the pricing for Denodo because I only design and develop.
What other advice do I have?
The security was good for us.
I do not have anything else on my mind as far as valuable features.
I do not know if the dynamic query optimization helped us improve performance or analytical queries as I am not familiar with dynamic query optimization.
My overall rating for this solution is 9.
Outstanding Virtualization and Query Optimization Features
Has simplified multi-database querying and accelerated solution delivery with minimal setup
What is our primary use case?
I used Denodo for a few months early this year, from January to March. My main use case for Denodo during that period was visualizing data from Snowflake and other databases across multiple databases and doing various types of analytics on the data inserted in those databases. We used Denodo for getting the data across multiple databases and matching the data in between these databases to have a single entry point for our queries.
For example, we had a bunch of files arriving on Azure Data Lake Storage, and we needed to match when these files arrived to what we needed to do with those files that were stored in a Snowflake instance. So, we used Denodo to cross this data and select queries, and then apply the Azure function that we needed to do to these files that were arriving on our Azure storage.
What is most valuable?
Denodo offers a great query language, the VQL, which was very easy to understand for someone that only knows SQL. It was easy to work with, and it was easy to integrate various types of databases in general. The usability of the platform is very great. The federated queries were also a feature that I used a lot. The easy usability of Denodo helped my work and made things easier for productivity. We were able to ship code faster than if we needed to use another type of data visualization tool or even an ETL.
When we have multiple databases, the standard or common approach is just to have an ETL that matches the data, and we need to write this whole ETL. With Denodo, we can simplify this whole work to a few queries or setups in the databases and just make a few queries. This was actually easier, and it was faster to deliver a solution for a client instead of building a whole ETL pipeline or simply backfilling one database in another. Denodo simplifies your work and helps you ship code or ship solutions in a faster way. I really like the UI that Denodo has on the web app version. It was very simple and actually very beautiful to see. For a complicated program, it was very easy to understand how it works, even for someone who is just approaching the data engineering career or side of the programming language.
What needs improvement?
The desktop version of the Denodo app has a difficult UX to understand, touch, and set up. But they have fixed that on the web app version, which is nice. Overall, the platform works great with the current setup that they have. I didn't really get to know the quirks and the bad side of the platform, as I've only used it for three months. In my opinion, it's a great software, and it's not buggy at all. The interface is simple and easy to understand.
For how long have I used the solution?
I've been working in my current field for eight years right now.
What do I think about the stability of the solution?
Denodo is stable.
How are customer service and support?
The customer support for Denodo is great. They are very easy to work with, and all my questions and concerns were answered in a very short amount of time.
Which solution did I use previously and why did I switch?
I didn't previously use a different solution before Denodo. When I saw Denodo for the first time, I thought it was great, but it was not my choosing to use Denodo; it was the standard platform for the company I was working at.
How was the initial setup?
We use Microsoft Azure as the cloud provider for Denodo's private cloud deployment.
What was our ROI?
I can't share any metrics with you because I was just a developer. But my general impression is that yes, Denodo saves a lot of employees and development time. Because if you don't need to write a whole ETL to make the data virtualization, you need way fewer people to write a query instead of writing an ETL pipeline.
What's my experience with pricing, setup cost, and licensing?
I didn't really manage the setup cost, licensing, and pricing for Denodo. But in my opinion, it's very expensive. For small companies, it's not a solution that most small companies can afford. But for big companies, the pricing seems fair. It would be nice to have a cheaper version of Denodo for small businesses.
What other advice do I have?
My main advice is to read the documentation for Denodo. It's a very powerful solution, but it has a lot of quirks and a lot of things that can be done and should be done the right way to have better performance when using Denodo. The documentation is very clear and will help you 99% of the times. The review rating is 9.