Likelihood to Recommend Denodo allows us to create and combine new views to create a virtual repository and APIs without a single line of code. It is excellent because it can present connectors with a view format for downstream consumers by flattening a JSON file. Reading or connecting to various sources and displaying a tabular view is an excellent feature. The product's technical data catalog is well-organized.
Read full review Oracle Data Visualization is very effective if used in an enterprise context with huge volumes of data coming from different systems. It supports dashboard and reporting capabilities and is easy to scale. It also allows you to leverage machine learning capabilities to extract hidden data trends. Visualization capabilities are powerful but not so various if compared to other solutions on the market. If you want to present a dashboard to an executive audience and you want to make your dashboards beautiful you must adapt them through PowerPoint.
Read full review Pros Database Agnostic: You can easily connect to different environments and mash up data sets. The "magic" of data virtualization: No data is created, so data is reported in near-real-time to end users. It's easy to use UI for developers. You just connect to a data source, create tables, and join them to other datasets. Read full review Available without of the box connectors for Salesforce and oracle Saas Cloud. This is a huge plus for our business since we don't need another middleware solution just for this sake. We are able to connect to our on-prem SQL Server database where we have our RMA database and other applications seamlessly without writing custom APIs. OAC writes directly into ADW which is another advantage for loading Excel files into ADW after dataflow transformations. OAC allows replication of the database from fusion ERP and lets us create subject areas using the data modeler. Read full review Cons Caching - but I am sure it will be improved by now. There were times when we expected the cache to be refreshed but it was stale. Schema generation of endpoints from API response was sometimes incomplete as not all API calls returned all the fields. Will be good to have an ability to load the schema itself (XSD/JSON/Soap XML etc). Denodo exposed web services were in preliminary stage when we used; I'm sure it will be improved by now. Export/Import deployment, while it was helpful, there were unexpected issues without any errors during deployment. Issues were only identified during testing. Some views were not created properly and did not work. If it was working in the environment from where it was exported from, it should work in the environment where it is imported. Read full review Reports that output data to portable and mobile devices should be in a better and more appropriate form and improved. In the beginning, the initial settings take some time, which I think requires a smart wizard to set up and get started. Must add mores diagrams and graphs Read full review Usability Denodo is very easy to use. It has a user-friendly drag and drop interface. I'm not a fan of the java platform it resides on.
Read full review Performance Denodo is a tool to rapidly mash data sources together and create meaningful datasets. It does have its downfalls though. When you create larger, more complex datasets, you will most likely need to cache your datasets, regardless of how proper your joins are set up. Since DV takes data from multiple environments, you are taxing the corporate network, so you need to be conscious of how much data you are sending through the network and truly understand how and when to join datasets due to this.
Read full review Support Rating Oracle Analytics Support team is very proactive and I have never had a situation where I had to wait for more than a day or two to get my issues resolved. This is a very big help for us and we appreciate Oracle and its team for guaranteeing that experience.
Read full review Alternatives Considered Denodo is simple and easy to use. Highly recommended unless you have huge volumes of data
Read full review Oracle Business Intelligence Cloud Service (OBICS) does well in terms of handling data, creating joins, managing database relationships, and data integration from multiple sources. However, the visualisation features on Oracle Business Intelligence Cloud Service (OBICS) are limited when compared to other business intelligence tools like
Looker or
Tableau . Again, the choice of tool depends on your specific requirements. Both provide different features and both are good at what they offer.
Read full review Return on Investment It is a huge advantage that we can connect to many different databases to provide data rapidly and accurately. It has proven to be a valuable environment for deploying data virtualization solutions, and its user community is active in finding and fixing issues. Read full review ROI is better than average; the product pays for itself in the long run Ease of use, which is very important in today's busy environments. Can be costly based on the amount of user licensing, which is a flat cost per user. Read full review ScreenShots