Likelihood to Recommend Data Virtuality Platform's best and most unique feature is that it is SQL-based, giving us flexibility when working with our data that other marketing integration pipeline tools couldn't provide. Our main benefits are the short time it takes to connect to our data sources and the flexibility of the virtual SQL layer to meet our end users' data needs. It paves the way for us to tap into various data repositories, extract the data contained within, and examine it. It allows us to access information, generate actionable reports, and make data-driven decisions. However, inadequate data governance rules and a complex configuration process make data connectors challenging.
Read full review 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 Pros ETL/ELT model building is flexible. The pipes' setup and use are intuitive. It lets us access various data sources, extract, and analyze data. Read full review 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 Cons Configuring data connectors can be tricky. Price could be more flexible and adapt to the use case. The ETL builder's user interface could be prettier. Read full review 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 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 Alternatives Considered Data Virtuality Platform has powerful transformation and scheduling capabilities combined with the best support team. A virtual data layer that supports SQL procedures is a game changer. Data Virtuality has made data management more efficient. It lets us access various data sources, extract, and analyze data. The short time it takes to connect to our data sources and the flexibility of the virtual SQL layer allows us to meet our end users' data needs.
Read full review Denodo is simple and easy to use. Highly recommended unless you have huge volumes of data
Read full review Return on Investment It has the capability of integrating data from a variety of different sources. It improved development and user interface to offer a robust MDM repository and strategy. It offers a comprehensive solution for processing and retrieving data, which is one of the ways it assists. Read full review 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 ScreenShots