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 KNIME Analytics Platform is excellent for people who are finding Excel frustrating, this can be due to errors creeping in due to manual changes or simply that there are too many calculations which causes the system to slow down and crash. This is especially true for regular reporting where a KNIME Analytics Platform workflow can pull in the most recent data, process it and provide the necessary output in one click. I find KNIME Analytics Platform especially useful when talking with audiences who are intimidated by code. KNIME Analytics Platform allows us to discuss exactly how data is processed and an analysis takes place at an abstracted level where non-technical users are happy to think and communicate which is often essential when they are subject matter experts whom you need for guidance. For experienced programmers KNIME Analytics Platform is a double-edged sword. Often programmers wish to write their own code because they are more efficient working that way and are constrained by having to think and implement work in nodes. However, those constraints forcing development in a "KNIME way" are useful when working in teams and for maintenance compared to some programmers' idiosyncratic styles.
Rob Blanford Artificial Intelligence & Machine Learning Manager
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 Summarize instrument level financial data with relevant statistics Map transactions from core extracts to groups of like transactions using rule engines Machine learning using random forests and other techniques to analyze data and identify correlations for use in predictive models Fill out sampling data from averages. 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 It does not have proper visualization. Some other BI tools (QlikView) have much easier functions for data interaction. Some other BI tools (Tableau) can be set up much faster. It is not an easy tool to use for non-tech savvy staff. Read full review Likelihood to Renew We are happy with Knime product and their support. Knime AP is versatile product and even can execute Python scripts if needed. It also supports R execution as well; however, it is not being used at our end
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 KNIME Analytics Platform offers a great tradeoff between intuitiveness and simplicity of the user interface and almost limitless flexibility. There are tools that are even easier to adopt by someone new to analytics, but none that would provide the scalability of KNIME when the user skills and application complexity grows
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 KNIME's HQ is in Europe, which makes it hard for US companies to get customer service in time and on time. Their customer service also takes on average 1 to 2 weeks to follow up with your request. KNIME's documentation is also helpful but it does not provide you all the answers you need some of the time.
Ivan Cui Data Scientist - Biotech Data Science Digtialization (BDSD)
Read full review Implementation Rating KNIME Analytics Platform is easy to install on any Windows, Mac or Linux machine. The KNIME Server product that is currently being replaced by the KNIME Business Hub comes as multiple layers of software and it took us some time to set up the system right for stability. This was made harder by KNIME staff's deeper expertise in setting up the Server in Linux rather than Windows environment. The KNIME Business Hub promises to have a simpler architecture, although currently there is no visibility of a Windows version of the product.
Read full review Alternatives Considered Denodo is simple and easy to use. Highly recommended unless you have huge volumes of data
Read full review Having used both the
Alteryx and [KNIME Analytics] I can definitely feel the ease of using the software of
Alteryx . The [KNIME Analytics] on the other hand isn't that great but is 90% of what
Alteryx can do along with how much ease it can do. Having said that, the 90% functionality and UI at no cost would be enough for me to quit using
Alteryx and move towards [KNIME Analytics].
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 It is suited for data mining or machine learning work but If we're looking for advanced stat methods such as mixed effects linear/logistics models, that needs to be run through an R node. Thinking of our peers with an advanced visualization techniques requirement, it is a lagging product. Read full review ScreenShots KNIME Analytics Platform Screenshots