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."The GUI is simple and it integrates with Python."
"Geo features have made spatial mapping large retail universes possible."
"Predictive models, which are easy to use, and help a lot with fast design and deployment."
"It is a stable and scalable solution."
"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 ease-of-use allows non-technical business users to directly create their own solutions without the use of additional development resources."
"The most valuable feature of Alteryx is user-friendliness."
"The product is very stable and super fast, five-star. It's significantly more stable than it's nearest competitor."
"Data mining is one of the valuable features. We're able to connect all of the data sources with the installed driver, so that is a good advantage in Denodo. Being able to join the tables and view them is also valuable."
"It is a very stable solution."
"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 connect to a lot of different sources."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"Denodo's best features are its performance, easy data transformation, and the job scheduler."
"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."
"The performance and the speed to market are the most valuable features of this solution."
"Configuration is very low."
"The GUI interface functions but it could stand to be updated to a more modern look and feel."
"The solution just lacks in terms of data visualization. That is why we use Tableau and Qlik in our organization. They help to pick up the slack. If data visualization was added, Alteryx would be a very good tool, and much more complete."
"The learning curve is long, and there is lack of e-learning; the tool is not user-friendly to a non-technical user."
"A colleague of mind mentioned that the solution should have more options for the visualization of data."
"A feature which allows the user to be able to click on an output (in a file browser) and see the creation of the module would be fantastic."
"I think better visualization would be helpful to this solution."
"The technical support could have a little bit of improvement."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"Denodo has some difficulty supporting large numbers of records."
"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."
"There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI."
"The solution should have its own acceleration technology."
"The support is not the best and should be improved."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"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 Data Science Studio, 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.