I use the tool to integrate and standardize data. It converts all kinds of data. It can convert non-relational data to relational data. It can create a standardized way to consume data.
Denodo 9 Enterprise
Denodo Technologies Inc. | 9.2.3Linux/Unix, Amazon Linux 2023 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS customer
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
User-friendly, provides useful integrations, and enables fast consumption of data
What is our primary use case?
What is most valuable?
The API generator helps generate APIs. The integration with Presto and other MPPs is valuable. It also provides integrations with Lucene and Elasticsearch. The tool has zero data replication. We can consume data fast. The product democratizes data. People talk about data democratization. Providing access to data is one thing, but the solution gives data in a format that people can consume.
What needs improvement?
Data transformation must be improved. Denodo is not the best tool for data transformation.
For how long have I used the solution?
I have been using the solution for one and a half years.
What do I think about the stability of the solution?
The product is pretty stable. I rate the stability a nine out of ten.
What do I think about the scalability of the solution?
The product is highly scalable. I rate the scalability a ten out of ten.
How are customer service and support?
The technical support is very good. I rate the support an eight and a half out of ten.
How would you rate customer service and support?
Positive
How was the initial setup?
The setup is simple and straightforward. The deployment takes about two months. We required two data architects to deploy the product. The vendor maintains the solution. The tool can be deployed on-premise, in the cloud, or in multi-cloud environments.
What was our ROI?
By using more data in decision-making, our strategy became more accurate. Eventually, we can replace a lot of processes and a lot of systems that we have.
Which other solutions did I evaluate?
Starburst and Tray.io are too technical. Denodo is very user-friendly. Denodo is a technological tool for non-technical people. It is very easy to use. Denodo is way more mature than Starburst and Tray.io.
What other advice do I have?
We connect all the data sources with Denodo, and Denodo connects with the metadata. We do not move the data. We embrace the fact that data now resides in distributed data sources. Through the metadata, we create a catalog. The catalog pretty much centralizes all our data management. Through the catalog, all the information is standardized.
We can visualize the information, manipulate the data, and integrate the catalog with data-consuming systems like Power BI, Tableau, and Apache. We do not centralize data. People think we need to get all the data outside the sources and put it in a repository to manage data properly. It is not necessary. We can integrate and create the catalog without replicating or moving any data. We can integrate with all the data-consuming systems we have and create a logical data layer.
Overall, I rate the solution a nine out of ten.
Which deployment model are you using for this solution?
Improves data integration processes and reduced the time to go live and required fewer human resources
How has it helped my organization?
In the past, transforming data from databases to other tools was a tedious and time-consuming process. Denodo eliminates that hassle, saving me time and money.
So, Denodo improves data integration processes. It reduced the time to go live and required fewer human resources to make data accessible across the company.
Moreover, it supports our reporting needs. I use Bar BI for reporting, and Denodo's ability to connect directly to native data sources without complex configurations is a great feature.
What is most valuable?
I like the integrated views. They're incredibly useful, along with the overall integration capabilities.
The logical data warehouse functionality is fantastic. It truly stands out.
The ClearOptimizer and Virtual Cache are great features. They work together seamlessly to optimize performance.
What needs improvement?
I'm waiting for them to introduce the generative AI capabilities they mentioned would be available by the end of the year. That would be a game-changer.
Moreover, I would like to see the ability to utilize vector databases.
For some internal strategies, I need to publish data into vector databases. Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement.
For how long have I used the solution?
I have been working with it for a year now.
What do I think about the scalability of the solution?
We never had performance or scalability challenges with Denodo.
How are customer service and support?
The customer service and support are fantastic.
Which solution did I use previously and why did I switch?
I used SSIS as an ETL tool and some IBM staging tools, but not extensively.
I used SSIS at my previous company and then switched to Denodo here.
The time to market is significantly faster with Denodo, both for deployment and publishing updates. Additionally, the web service capabilities are fantastic. We can deploy any web service in just minutes without complex development or security concerns.
What other advice do I have?
If you need immediate access to data (within 3-5 days), Denodo is a great solution. However, for complex data silos, I recommend trying a demo for a week or two before making a decision.
Overall, I would rate the solution an eight out of ten.
A stable tool useful for virtualization that offers good performance and scalability
What is our primary use case?
I use the solution in my company as a virtualization tool. The tool helps users to connect with many databases and resources in the data lake. With the tool, I can create views for the front end of Tableau and other BI tools. I combine data from different or various resources and combine them to create views, which is also useful for analysis purposes. On top of the views I create with the tool, I also make dashboards.
What is most valuable?
The most valuable feature of the solution for data virtualization in our company stems from the fact that we have various data sources, and we combine those data sources. My company also uses the solution to connect to box files and for ingestion purposes.
What needs improvement?
Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly. The aforementioned area in the product needs to be taken care of for improvements.
For how long have I used the solution?
I have been using Denodo for two and a half years.
What do I think about the stability of the solution?
It is a very stable solution.
What do I think about the scalability of the solution?
It is a scalable solution. I can add as many resources as I want to in Denodo.
There are around 5,000 to 10,000 people in the company that use the product.
How was the initial setup?
I am unsure if the solution is deployed on an on-premises model, but I am sure that it is not deployed on the cloud.
What about the implementation team?
The product's deployment phase was done with an in-house IT infra team.
What other advice do I have?
Denodo has streamlined data integration from multiple sources, such as various databases offered by Salesforce or PeopleSoft.
The tool helps with big data analytics or cloud integration processes since I use it to create views from various sources, and on top of it, I also make dashboards.
I work as a third-party or outsourced consultant in a company in India, and my team works in the USA, where Denodo is available in the service. In my company, there are around 70 people working with the product.
The performance and scalability of the product are nice. I only face issues with the analytical functions since they don't work properly for SQL.
I rate the product's UI an eight out of ten.
If a company has to deal with multiple data sources, then Denodo can be used for virtualization.
I rate the overall tool a ten out of ten.
Denodo Data Virtulization
A stable solution that helps virtualize data with ease
What is our primary use case?
We use the solution for data virtualization to publish the data as a product. We have different teams who have their own database. If a team needs any data, they get it from Denodo.
What is most valuable?
It is easy to virtualize data using the solution. If required, we can also use the solution for caching.
What needs improvement?
The solution is slow when there are many virtualization layers. The solution is also slow when we connect the on-premise solution with the one on the cloud through a network gateway.
For how long have I used the solution?
I have been using the solution for two and a half years.
What do I think about the stability of the solution?
The product is stable.
What do I think about the scalability of the solution?
More than 100 people in the organization are using the solution.
How was the initial setup?
As a developer, I can easily set up the solution on my local Kubernetes. Local configuration is pretty easy.
What other advice do I have?
A lot of virtualization leads to data latency. We can do caching on the intermediate layer. We can also leverage Databricks if we have any complex transformation.
I have a local Docker container. I can easily integrate my local container through Git repo and clone it in our depth server. Denodo is the only tool I know for data virtualization. I will recommend the solution to others. Overall, I rate the product a ten out of ten.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
My experience with Denodo is great
Simple to use
Many types like semi structured ,unsyructured and structured type data sources are available to connect
amazing data virtualization tool!!
Excellent tool for ETL
Good product to use but needs improvement in some areas
2) It makes data analysis so simple as you could do a lot with only using SQL.
3) Good range of pre-defined functions.
2) Formatting of VQLs in Virtual Data port needs to be looked upon. VQLs format in a single line in spite of user forming a beautifully format query.
I have been using Denodo to read data from a variety of sources like Enterprise Datawarehouse, Cloud services and third party APIs. Denodo eliminates the need for lengthy ETL processes and makes analysis very easy.
Easy solution build:
Even when a solution needs to be built using all these sources, we could leverage Denodo to be used as a source and process it in a different framework.
Time-saving:
By bringing all sources to one place, Denodo helps ion reducing development time by a huge percentage. ETL needs proper procedures to be setup and company regulations mean it would take months to move data. Using a data virtualization tool reduces that time to minuites.