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 filtering is fast, and it provides a search tool that is great."
"My primary focus is creating numerous data pulls, and Alteryx Server handles the automation well."
"Predictive models, which are easy to use, and help a lot with fast design and deployment."
"The initial setup is easy."
"It has everything that one needs. Whatever you want to do with the data can be done with Alteryx."
"It is one of the most complete and great customer service that I experienced with a software company/ecosystem."
"Alteryx's connectivity is essential. We like the ability to connect the solution to multiple sources. It's easier than other data modeling and extraction solutions. It's built on a self-service concept, so it's easy for anyone to open the tool and directly import or export data from it."
"The drag-and-drop functionality, the ready-to-use analytics module, and the ability to track my data pipelines visually are the solution's most valuable features."
"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"Denodo makes it easy to export data as a service or data link to other services."
"Denodo is very stable."
"The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."
"While we may not be using all the features of Denodo at this time, we have found the data virtualization features to be very useful in helping us connect our data sources together, bringing all our data into one platform."
"Access to numerous forums and internet information."
"In general, it's good for us to make tests so we can scout the data."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"There are a few hiccups with specific data sets and languages or formats that the data comes in. That may be a minor problem, but we can work through it. We had some issues looking at XML format in added data, but it wasn't significant."
"It is a little bit pricey."
"I mostly used it for flat files, but I have many colleagues who reported that to tune a query, in case they want to directly connect to the database, there is no option to optimize the performance of the query, as we have in Informatica."
"They should work on its pricing."
"It would be nice if they can provide Alteryx with more options for In-DB connectivity. That functionality is there, but it doesn't include all software we are connecting."
"Deep learning models are not currently supported."
"There could be a bit of improvement related to performance. Sometimes it demands a lot of resources for running it, like memory and search."
"I honestly can't think of anything that needs to be improved."
"I would like to see a proper way to avoid killing the sourcing systems."
"The git configuration really should be improved."
"I would like to see a connectivity option with third-party apps, for example, JDBC, and ODBC drivers. Currently, we need to install it separately from the Denodo side and then connect it."
"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."
"The feature that you have to connect on LDAP needs improvement."
"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."
"The data catalog certainly has room for improvement. It is functional but we look forward to development. We are in constant contact with Denodo and they are fully aware of our needs."
"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."
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.