We performed a comparison between Alteryx and Denodo based on real PeerSpot user reviews.
Find out what your peers are saying about Alteryx, RapidMiner, SAP and others in Predictive Analytics."It has everything that one needs. Whatever you want to do with the data can be done with Alteryx."
"It saves time on a lot projects. "
"The solution offers excellent predicting power. The accuracy and confidence have been great."
"It is one of the most complete and great customer service that I experienced with a software company/ecosystem."
"Alteryx helps me do a lot of automation. The best thing about Alteryx is that you don't have to repeat the workflow over and over again. Unlike Excel, where you need to write formulas for each new file, Alteryx follows a consistent process. You can schedule and automate the workflow, even if the files change."
"The most valuable feature of Alteryx is user-friendliness."
"It allows for manipulation and automation, which has greatly reduced the amount of time required per project."
"The most valuable feature of Alteryx is its stand-alone version that we do not have to download dependencies for loads. Additionally, the scan is useful for beginners."
"The most valuable feature is Data Catalogs."
"The performance and the speed to market are the most valuable features of this solution."
"It allows a lot of traceability and you can decide what data you want to collect"
"The data abstraction is the most valuable feature."
"Access to numerous forums and internet information."
"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."
"The ability to transfer data is very valuable."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"The price of the solution could improve by being lower."
"The solution could improve in the visualization."
"We can't browse multiple files. When we deploy a solution on a gallery, let's say I have ten different files, and I have to upload them all at once. This is something that's difficult in the gallery. So case by case, I see some downsides, but often we do something alternative."
"There's a big jump in terms of pricing between license tiers. I'm not sure I understand why the price jumps are so high."
"The GUI interface functions but it could stand to be updated to a more modern look and feel."
"Sometimes, there are performance constraints. Especially when a large file has to be ingested, the system slows down a bit. Its performance is the only thing that can be improved."
"There are a few imputation techniques which they really need to include."
"There have been some issues with licensing, particularly with the increased prices. This has led some companies, including ours, to consider reducing the number of licenses or potentially discontinuing their use of Alteryx."
"It would be beneficial to make sure that the team that will be using Denodo has some kind of training on how to use the product at least a month beforehand, and there could even be some kind of feedback or Q&A sessions to go along with the training. If Denodo were able to provide this kind of training, it would be very helpful to users in insurance and banking companies because the staff are typically older and not always technically-minded."
"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."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"Performance management could be improved."
"The git configuration really should be improved."
"Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement."
"The support is not the best and should be improved."
"It would be good if the solution provided a much-needed cellular platform."
Alteryx is ranked 1st in Predictive Analytics with 74 reviews while Denodo is ranked 1st in Data Virtualization with 29 reviews. Alteryx is rated 8.4, while Denodo is rated 7.8. The top reviewer of Alteryx writes "Feature-rich ETL that condenses a number of functions into one tool". On the other hand, the top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". Alteryx is most compared with KNIME, Databricks, Dataiku, RapidMiner and Microsoft Power BI, whereas Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Informatica PowerCenter.
We monitor all Predictive Analytics 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.
Greetings, Stefan.
Alteryx is basically an ETL tool that evolved to deliver some Data Viz and ML features too. This means that its main purpose is to extract data from different sources, combine and transform them and finally load them in a different database.
Denodo is a data virtualization tool, which means it does all the transformations without extracting from one place and loading to another one. It´s a cloud-based solution and it charges by the traffic. If your company has specific General Data Protection Regulation that prohibits for instance that you extract the data located in a data center in Europe and loading them in a cluster located in the USA, you will probably need a virtualization tool like Denodo instead of an ETL like Alteryx. Virtualization tools are usually more expensive in a long run
Azure Data Factory is a platform meant to leverage the use of Azure. Microsoft´s objective is to sell its cloud solution as a whole. It contains a Data Studio (to manage and control your data), SPARK (which is a Hadoop in memory) and a data lake storage.
As you see, those are 3 different products that do not make much sense to be used together.
I'd say that there is a misconception in some of the answers (but don't worry, it's a common one).
Alteryx is not an ETL tool, it's an analytics platform with very powerful ETL capabilities (accessing mostly all data sources available and processing them at high speeds among others).
But additionally, Alteryx gives you the ability to carry on with the complete analytics cycle, processing, cleaning, blending those diverse data sources, modeling descriptive, predictive, prescriptive analytics (plus some ML & AI), outputting to another humongous variety of data sources, reporting or visualization tools.
All of the previous can be achieved with no coding at all, but in case you want to code, Alteryx also offers Python, R & Scala native integration. In other words, it can solve business users' use cases and advanced/technical use cases at the same time.
Finally, it's a fixed license, with no additional costs per usage (at least so far, until they release the Cloud Version).
I hope I was able to clarify the role of Alteryx in the analytics landscape.