We performed a comparison between Denodo and SAS Access based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"Access to numerous forums and internet information."
"The performance and the speed to market are the most valuable features of this solution."
"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."
"It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo."
"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"Overall, the product works quite well and has a good set of features."
"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."
"The most valuable feature is you have native access to the external databases."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"Monitoring event logs can be improved. In the older version, there was a monitoring schedule to get event reports and properly audit the reports. In the newer version, it is not there, and we have to manually configure data and audit events."
"Tasks such as conversion of a date format or conversion of a number format that can be done in a very easy way in different languages, like SQL or Oracle, are not so easy to do in Denodo. For example, if you want to convert a date from one format to another, in Oracle it's pretty easy; in Denodo, however, it requires so many lines of code. Simple things that can be done very quickly in other database languages require more lines of code in Denodo."
"Denodo has some difficulty supporting large numbers of records."
"Denodo can improve usage management-related aspects. If you deal with the mini views, it gets stuck. The performance is very slow when we go with a large number of views and high volume."
"The integration could use improvement, it's a lot of non-speed line processes that we have discovered, in the country. The configurations could use a lot more improvement."
"I would like to see a proper way to avoid killing the sourcing systems."
"We can't scale it to meet digital requirements."
"I would like to see a connectivity option with third-party apps, for example, JDBC, and ODBC drivers. Currently, we need to install it separately from the Denodo side and then connect it."
"The pricing model needs to be reconsidered and adjusted."
"The solution can provide access to the newer databases that come out sooner."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
Denodo is ranked 12th in Data Integration with 29 reviews while SAS Access is ranked 42nd in Data Integration with 3 reviews. Denodo is rated 7.8, while SAS Access is rated 9.0. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, the top reviewer of SAS Access writes "The solution is stable, scalable, and flexible". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Informatica PowerCenter, whereas SAS Access is most compared with Delphix, SSIS, Zapier and Toad Data Point.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.