Denodo Valuable Features

Dash Bibhuprasad - PeerSpot reviewer
Lead Solution Architect at a insurance company with 10,001+ employees

We initially thought that we'd be using more features of Denodo than we are currently. And, in fact, there is a large number of features, ranging from data visualization to data virtualization and connecting to different non-connectable parameters (such as connecting to many different types of files, which other products don't allow you to do as easily as Denodo does). However, after we moved to the cloud with Azure, we mainly used only the data virtualization features of Denodo, while opting for Power BI when it comes to visualization with dashboards and reporting.

So while we may not be using all the features of Denodo at this time, we have found the data virtualization features to be very useful in helping us connect our data sources together, bringing all our data into one platform.

View full review »
Alisson Machado De Menezes - PeerSpot reviewer
Senior BigData DevOps Engineer at Schaeffler

Getting queries is great. They are really good. You can basically write SQL statements, and it can convert to MDX queries or to MongoDB queries, or any kind of data source. We have many different data sources. You just use the requisite language, which translates to all the underlying data sources. That's the best thing that we have on Denodo.

In general, it's good for us to make tests so we can scout the data. We can make POCs easily. 

View full review »
Naresh Maddineni - PeerSpot reviewer
Senior Application Developer at a financial services firm with 10,001+ employees

The best thing about Denodo is that creating and deploying a web service can be done in about 10 minutes, compared to a whole day when it comes to other solutions (such as when deploying with Java and AWS).

It's also really easy to do so in general, because no longer do you need to request the specifics of how the web service is to be created, but instead all you need to do is provide the data points needed and you will have access to a web service that is ready to serve you responses.

Not only that, but you will also be able to duplicate the newly-created web service to be used in different ways with various methods. And all this takes only a few clicks on a single platform, as long you know the data points that you need.

View full review »
Buyer's Guide
Denodo
March 2024
Learn what your peers think about Denodo. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
KB
Senior Manager Data Analytics at a recreational facilities/services company with 10,001+ employees

One thing that we have noticed is that when you have a BI tool, you end up building a lot of the logic in the BI tool, but as a company, every company wants to be tool agnostic because today, you could be in the Qlik Sense, and tomorrow, you may decide to go with Tableau or something else that is there. If you have put a lot of logic within the tool, transitioning or moving away from one BI tool to another tool becomes a very intensive process. By keeping the logic in Denodo, you can move to any tool. That's what we have done at this point because we used to have Cognos in my company before. When we did the migration from Cognos to Power BI, it was quite intensive for us because a lot of the logic was sitting in SQL queries within Cognos. To move to Power BI, we had to do a lot of backward thinking. These reports were built more than 5 years ago, or even 10 years ago, and the people who built them were no longer with the company. The logic was pretty much gone. We didn't have good documentation, but now, after we have put the code in Denodo, we have visibility. Any developer, not a business analyst, can come and take a look at that code and discern how the data is moving from the warehouse to Denodo. All that Power BI or Qlik Sense is doing is just pulling the data from that view. We can do averages and other calculations in the tool, but at least our aggregation and the logic are in the Denodo layer, and then going forward, we can take it to any tool.

Last year, they moved from version 7.0 to 8.0, and version 8.0 gives a lot of flexibility.

View full review »
AbhijeetKarki - PeerSpot reviewer
Data Solutions Architect at Cognizant

The strength of Denodo is that we can connect to a lot of different sources; it easily integrates and directly connects. It's great that it can flatten a JSON file and present connectors with a view format for downstream consumers. I would say reading or connecting to various sources and presenting a tabular view is an awesome capability. It can also be done with PDFs. The product has a good technical data catalog. 

View full review »
Rajesh Nai - PeerSpot reviewer
Senior Associate at a consultancy with 10,001+ employees

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. 

Though it's not a full ETL solution, teams downstream can utilize it, prepare it, and consume it in a secure way in multiple formats.

View full review »
HetulPatel - PeerSpot reviewer
Senior data engineer at Tiger Analytics

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.

View full review »
Biswajith Gopinathan - PeerSpot reviewer
Data Analytics Specialist at GlaxoSmithKline

The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good. 

View full review »
KARTHIKEYAN THANGARASU - PeerSpot reviewer
Database Administrator at American Savings Bank

Data mining is one of the valuable features. We're able to connect all of the data sources with the installed driver, so that is a good advantage in Denodo. Being able to join the tables and view them is also valuable.

View full review »
BM
Enterprise Architect at a financial services firm with 10,001+ employees

The most valuable features are query optimization and the single language independence from the sources we're using to catch data.

View full review »
AS
Tech Lead and Architect at SEI

Caching was very valuable to us.

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.

View full review »
Atanu Chatterjee - PeerSpot reviewer
Principal Architect at a manufacturing company with 10,001+ employees

It is easy to virtualize data using the solution. If required, we can also use the solution for caching.

View full review »
LeandroSodré - PeerSpot reviewer
Data Governance Analyst at Data Meaning, Inc.

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.

View full review »
Sara Kaleem - PeerSpot reviewer
Data Science and Business Analytics at Neusol - Global IT services

The virtual layer or Symantec part of it are most valuable. Where all the data sources, which we integrate together, are available on a virtual layer and that makes it faster.

View full review »
Bhanu Pratap Singh - PeerSpot reviewer
Lead Consultant at Cognizant

The ability to transfer data is very valuable. It is one of the best when considering other ETL tools and is easy to maintain. Compared to Informatica and Oracle Data Integrator, Denovo is the most convenient.

View full review »
Parthiban Manickam - PeerSpot reviewer
Senior Associate at a tech services company with 10,001+ employees

Denodo's best features are its performance, easy data transformation, and the job scheduler. 

View full review »
TG
WebFocus BI & Datastage Lead at Accenture

The most valuable features of Denodo are the extraction option for adapters, and there are many things for the views, that are cached. Denodo is not storing the data, it looks first to tune the query, and these things are for the agents.

View full review »
AA
Senior BI Developer at a tech vendor with 51-200 employees

Denodo is very easy to learn and user-friendly. Data is easily exported and can be used in reports and other programs.

View full review »
CP
Finance Systems Programme Manager at a real estate/law firm with 501-1,000 employees

The most valuable features are data lineage and the concept of a semantic layer.

View full review »
PC
Assistant Consultant at a tech vendor with 10,001+ employees

Denodo is lightweight in terms of how it leads you to combine your discrete data systems in one spot. You are able to logically define and create your desired data set without actually getting your data shifted from the data system like any trivial ETL system does. It will not perform any data movement.

The solution provides ease for accessing data in various ways, including on-demand APIs. Uploading your data on an API will take less than an hour.

Denodo provides a good experience in terms of data visualization. The data on demand is the best feature. I also enjoy the go-to feature for data fabrication, or data mass structure, where data democratization is being sent data for all people at that time.

View full review »
KM
Data and Analytics Strategist at Climate Action Services Inc.

The most valuable feature is Data Catalogs.

What I like about them is that there's a breakout, a functional component of other large enterprise systems, which makes it much more usable.

View full review »
MS
Software Engineer at IT-Bots

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.

View full review »
MV
Head of Data Service Department at a government with 201-500 employees

It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo.

View full review »
Paolo Noguera - PeerSpot reviewer
Head de People Analytics at BlueShift

This solution provides us with the ability to sync data, and make it available for anyone to use across the business.

View full review »
AM
ETL/BI Senior Consultant at a consultancy with 51-200 employees

This solution is a really good way to get all your sources organized when there are data problems and things are scattered everywhere. You have some flat files, some databases and it's all over the place. This provides one central place for all those connected to carry out governance and build up the views and type of information that need to be extracted. It's like a whiteboard in the sense that it helps you to map things. You can then build on top of it. 

It also allows a lot of traceability and you can decide what data you want to collect from each space without moving the data itself, you're just doing the visualization. I believe it can solve a lot of problems for businesses.

View full review »
ZK
Senior BI and Data Consultant at a consultancy with 1-10 employees

The performance and the speed to market are the most valuable features of this solution.

View full review »
JB
Deputy General Manager at a comms service provider with 5,001-10,000 employees

The price is fantastic. The cost is reasonable for what is offered.

Overall, the product works quite well and has a good set of features.

Their integration capabilities with data are great. The solution can integrate different types of data quite easily.

View full review »
it_user1194042 - PeerSpot reviewer
Management Consultant at a tech services company with 51-200 employees

The data abstraction is the most valuable feature.

The data modeling is very good. It's a powerful tool. The way the UI is organized is suitable for our use.

The data building is also good.

View full review »
AU
Solution Architect at a tech services company with 1-10 employees

Denodo has a great community and they provide access to a lot of internet information, forums and meetings of varies kinds. 

View full review »
Buyer's Guide
Denodo
March 2024
Learn what your peers think about Denodo. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.