I am switching from Denodo to other solutions. Currently, I work as a Data Engineer Team Lead at an Etex company, 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.

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.

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.

I have been working with Denodo for the last three years.

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.

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.

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.

I solved the problem by myself.

The implementation is not complex at all for Denodo.

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.

I am satisfied with the performance for sure.

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.

Denodo's interoperability options make the integration process very easy.

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 am not sure how customers are dealing with Denodo from the AWS Marketplace or directly. I give this review a rating of eight out of ten.

My main use cases for Denodo involve implementing APIs to connect different data sources with new software to improve the process in Ecopetrol.

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.

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.

In the last 12 months, I am not still working with Denodo. This year I have not, but last December, I was using it.

Denodo is stable and good. I do not have crashes normally.

My thoughts on scalability are that it is good because I can use different setups or configurations.

I do not use the technical support, so I cannot rate the customer service or technical support.

I have not evaluated other data integration tools before because Denodo was the tool in the project and I do not see other tools.

The initial setup of Denodo was medium complex.

I do not know the pricing for Denodo because I only design and develop.

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.

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.

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.

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.

I've been working in my current field for eight years right now.

Denodo is stable.

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.

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.

We use Microsoft Azure as the cloud provider for Denodo's private cloud deployment.

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.

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.

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.

I use Denodo to create a virtualized data environment rather than a physical one. This is helpful when enterprise data is spread across different data sources, such as cloud data warehouses and data lakes, and is used for developing AI and ML strategies. It creates a unified virtualized environment so the algorithms do not need to connect to multiple data sources individually.

Denodo creates a virtualized environment that provides one unified destination for all data sources so that AI and ML algorithms can connect to that virtualized destination without needing to establish connections with multiple data sources.

The most valuable feature in Denodo is data virtualization. This feature focuses on creating a virtualized data environment that allows for simpler connections between data sources and systems. It significantly eases the process of developing AI and ML strategies by centralizing access to various data sources and allowing algorithms to efficiently connect to and utilize data.

Denodo's complexity level is high since it connects multiple sources, sometimes creating glitches in the production environment. The stability of the features can be improved. The system has dependencies on other environments, like JVM, which can affect its performance.

I have been using Denodo for about two to three years.

Denodo shows stability concerns due to its dependency on external environments, such as JVM. If JVM does not function properly, it may cause Denodo to fail to connect to different sources.

I would rate Denodo's scalability as six to seven. Its complexity in configuring and the requirement to install different connectors for different sources affects its scalability.

Denodo's technical support is rated as seven. Although they are proactive in conducting webinars and connecting with customers, they are perceived as less proactive compared to some other vendors.

Configuring Denodo involves setting up a Java environment and installing different connectors for various data sources. This can take one or two weeks depending on the number of sources.

Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises. On a scale of one to ten, where ten is most expensive, it is rated around three to four in terms of cost.

For new users evaluating Denodo, it is crucial to determine whether you truly need a virtualized environment. If you do not have numerous data sources, Denodo might not be necessary. However, if you do, Denodo makes sense.

I rate the overall solution as eight out of ten.

I am a consultant and a freelance data engineer with experience in Denodo. I work as a data warehouse and BI consultant, owner, and managing partner. I assist my clients, primarily in the public sector, including government organizations, with IT solutions using Denodo as part of their infrastructure.

The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.

Denodo acts like a database query engine without a specific database storage technology. It is a very intelligent query engine, providing an abstractness to information at a meta and meta two-level.

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

Denodo is like a Swiss army knife, but it's challenging to deploy it as a clear solution because it presents itself as a tool that can do anything. Denodo needs better communication on how the product can be deployed for specific solutions, and there are price issues, as it's considered expensive. It requires improving the story of how it can solve specific problems.

I have two years of experience working with Denodo.

The stability of Denodo is high. I would rate it nine out of ten because it is very reliable, always performing as expected.

I have not worked with large deployments of Denodo, particularly in a clustered environment. While the solution scales well on a single machine, I have doubts about its scalability when deployed as part of a Java component cluster. Therefore, I rate its scalability at seven or eight.

Denodo's customer support team is very competent and responsive. They try to simulate problems and address issues promptly, although most problems relate to network or authorization protocols, not the product itself.

For me, the initial setup was not a problem due to my extensive experience with UNIX and databases. However, customers have found multilingual support somewhat lacking, and documentation has not always kept pace with rapid product changes.

Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.

While I rate Denodo nine out of ten, I recommend considering the specific use case before adopting it. Denodo is a tool and should be part of a well-thought-out solution. Don't rely on marketing claims that say Denodo can handle everything. Solutions should be designed to solve specific business problems.

I work with business views for different areas.

Denodo is a good tool for data virtualization and cataloging. Its catalog is useful for data governance and helps document information for databases and fields.

Denodo is also effective for developing solutions quickly, facilitating user reports, and offering good data governance. It provides useful APIs and integrates with other systems.

The cache configuration is more complicated.

I have used the solution for two years.

Denodo has good support with the vendors and it is timely. They have a good methodology for learning how to use the tool, and the documentation is very thorough.

It is easy to set up.

Overall, I would rate Denodo a nine out of ten.

Denodo is used for data virtualization and not for data visualization. We are in the initial phase of using Denodo, performing a proof of concept (POC) to understand its features. It is used for connecting to various data sources and combining data without storing it.

Denodo provides flexibility in connecting to multiple data sources. It enhances data performance by using data caching. It allows for combining heterogeneous data formats and provides a mechanism for querying in natural language.

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.

As we are still in the initial phase, it's difficult to identify weaknesses. However, ensuring data caching is up to date is critical. While AI and ML integration is present, understanding its implementation better could be beneficial.

I have started using Denodo since last month.

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

Denodo provides high availability and flexibility in infrastructure and architecture management.

I have not yet needed to raise a ticket with Denodo's technical support as most questions have been answered through the community resources. I am in touch with some Denodo technical team members who explain the product features.

I used Qlik Sense for over six to seven years. 95% of my queries were answered through Qlik's community, and their support was prompt. We were Qlik customers, not partners.

The installation process is simple, whether on Windows or Linux servers. The setup is easy and provides flexibility from an infrastructure and architecture point of view.

End users of Denodo will mostly be non-technical, as they will query the system in plain English for data insights.

I'd rate the solution nine out of ten.

My customers use Denodo for data integration. Before using Denodo, they did not have a platform to control all data sources with one platform. Denodo allows connecting different data sources for analysis and reporting.

The most valuable feature of Denodo is security, especially the privilege control. Denodo can connect over 150 data sources, making data integration effective.

The GUI interface allows easy connection of all data sources like API, JSON, or any JDBC source.

Additionally, the enterprise version has a global security management feature to control privileges by role.

I am still waiting for Denodo to support vector databases. Currently, Denodo does not provide a vector database, which my customers build on their own to use AI functionalities.

I have been working with Denodo for one and a half years.

Denodo is stable. It can handle API stress tests effectively.

Denodo is scalable.

As a presales engineer, I do not have direct experience with the initial setup since my role is focused on selling the product.

Pricing is case by case, so I cannot provide specific details.

I only work for Denodo. I am not familiar with other solutions.

If customers want to make their data valuable, they must know which data they are using. By using Denodo's data category feature, they can identify and manage valuable data effectively.

I'd rate the solution eight out of ten.

The idea behind data virtualization is to create an abstract layer for easy consumption by BI tools such as MicroStrategy, Tableau, Power BI, and others. This abstraction layer aims to avoid the complexity of directly accessing data sources, thus simplifying data integration. Denodo facilitates this by mediating between different data platforms like Teradata, cloud data warehouses, Oracle databases, and others, unifying them under a common virtual layer. This enables seamless access to unified data across diverse platforms and technologies.

Furthermore, Denodo includes an optimization engine that enhances performance through techniques such as static and dynamic optimization, cost-based optimization, and caching mechanisms. These optimizations help improve query performance, reduce memory usage, and enhance overall system efficiency. This optimization capability is a key feature of Denodo and other data virtualization tools, enabling efficient data access and integration across heterogeneous environments.

Denodo provides several server connectivity options with other tools such as ODPC and UDPC. It supports API integrations, allowing integration with a wide range of databases using different technologies, including NoSQL and relational databases. For databases that do not have a universal connector, Denodo allows users to create custom JDBC connectors. Additionally, it supports integration with websites using KPI connectors on-premises, offering a variety of connector options.

They need to invest more in the optimization engine. It will be a fantastic tool for them to enhance automation and improve the GUI interface, especially for Integration, as some tools are still not fully integrated, such as Iceberg. Batch processing is very good but not yet fully integrated. Therefore, they should focus on improving the GUI interface, enhancing cloud capabilities, and integrating modern technologies like Iceberg. Additionally, they should continue refining the optimization engine itself.

I have been using Denodo for three years.

It's a very stable tool. We faced problems related to vulnerability checks from the operating system itself, which were quickly resolved. It's robust and stable; we haven't encountered any major issues with it. We did need to allocate additional memory to handle our data volume.

I rate the solution’s stability a nine out of ten.

Denodo is scalable and supports load balancers for achieving scalability through multiple load balancing techniques. In our production environment, we have thirty-two cores distributed across four machines, each with eight cores. These machines are managed using a load balancer tool to ensure scalability and efficient resource allocation.

I rate the solution’s scalability an eight out of ten.

They provide extensive documentation which covers administration, development, and support comprehensively, providing detailed explanations for every step. In contrast, other data virtualization solutions like Data Virtualization and IBM Data Virtualization often lack such detailed documentation, which is crucial for implementing solutions to various problems. Additionally, Denodo provides excellent support. They have a dedicated and knowledgeable staff who are readily available when needed.

I have experience working with telco data visualization and analytics. I've utilized Denodo for data integration and analytics in telecommunications. Additionally, I've worked with mobility and IoT technologies for revenue assurance and management. I have proficiency in the Microsoft Stack, including SSIS, as well as experience with AWS Cloud services.

The installation is not extensive. It takes about one week. The entire project deployment, including development, usually spans around six months. For instance, development itself might take approximately three to four months, with the remaining time allocated to post-production tests, use case implementations, and other activities.

They have achieved significant improvements in KPIs, such as customer churn, reducing it by approximately eight to twelve percent. This is an actual figure. They have also increased customer loyalty by the same margin.

Denodo is expensive.

I rate the product’s pricing a six out of ten, where one is cheap and ten is expensive.

The main motivation was their use of multiple technologies such as SQL servers and Oracle, spanning nearly twenty-five different databases. This multitude of data sources and information spread across various databases necessitated robust data integration and visualization capabilities. Denodo played a crucial role in enabling the bank to unify and visualize information from these disparate schemas and technologies. This achievement significantly enhanced their ability to derive comprehensive insights from the diverse datasets. Numerous insights and use cases have already been successfully implemented across various departments within the bank. These initiatives have encompassed areas like predictive analytics, customer behavior analysis, and the development of machine learning models for HR and revenue forecasting.

Denodo's products help reduce time to market for new products and promotions, ensuring they reach customers promptly. This prevents revenue loss, especially at the customer and complaint levels, among other benefits.

Denodo has three layers of security. It is integrated with Active Directory for authentication. It supports single sign-on within the organization, particularly in the banking sector, where it is a leader. This integration allows for auditing and monitoring of all staff members. This forms the first layer of security. The second layer involves fine-grained access control over specific tables, views, and even columns. Denodo provides specific controls to determine who can access which tables and columns at a granular level. The third layer consists of generic governance rules governing user groups such as development, operations, and administration teams. For instance, developers may have read-write access, administrators have full administrative privileges, and operations staff have predefined access rights. These rules govern the authorization and authentication processes within Denodo.

Denodo is not an expert in AI nor does it propose AI-specific use cases. However, its abstraction layer can inspire ideas related to AI, such as predictive analytics for customer behavior, complaints analysis, churn prediction, forecasting future revenue trends, and identifying new customer benefits for a bank's portfolio, for example.

It provide a six-month warranty post-production, followed by five years of product support. This includes updates, new batches, upgrades, and more. One admin and two development team are required for maintainance.

Overall, I rate the solution a nine out of ten.