Try our new research platform with insights from 80,000+ expert users

Alteryx vs Anaconda vs Teradata comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Mindshare comparison

Predictive Analytics
Data Science Platforms
Data Warehouse
 

Featured Reviews

Theresa McLaughlin - PeerSpot reviewer
Quick development enables seamless data processing despite occasional support issues
There were times when the product would fail during development without an apparent reason. The support structure changed; initially, we received great support, however, it later became less reliable due to licensing issues and a tiered support system. Licensing negotiations were problematic, affecting our product usage. For instance, our licenses were temporarily lost during negotiations when an agreement couldn't be reached.
Rohan Sharma - PeerSpot reviewer
Provides all the frameworks and makes it easy to create environments for multiple projects
The best thing is that it provides all the frameworks and makes it easy to create environments for multiple projects using Anaconda. It is easy for a beginner to learn to use Anaconda. Comparatively, it is easier than using virtual environments or other environments because of the Conda environment. However, there are many things in Anaconda that people need to be aware of, so it can be challenging.
SurjitChoudhury - PeerSpot reviewer
Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities
We created and constructed the warehouse. We used multiple loading processes like MultiLoad, FastLoad, and Teradata Pump. But those are loading processes, and Teradata is a powerful tool because if we consider older technologies, its architecture with nodes, virtual processes, and nodes is a unique concept. Later, other technologies like Informatica also adopted the concept of nodes from Informatica PowerCenter version 7.x. Previously, it was a client-server architecture, but later, it changed to the nodes concept. Like, we can have the database available 24/7, 365 days. If one node fails, other nodes can take care of it. Informatica adopted all those concepts when it changed its architecture. Even Oracle databases have since adapted their architecture to them. However, this particular Teradata company initially started with its own different type of architecture, which major companies later adopted. It has grown now, but initially, whatever query we sent it would be mapped into a particular component. After that, it goes to the virtual processor and down to the disk, where the actual physical data is loaded. So, in between, there's a map, which acts like a data dictionary. It also holds information about each piece of data, where it's loaded, and on which particular virtual processor or node the data resides. Because Teradata comes with a four-node architecture, or however many nodes we choose, the cost is determined by that initially. So, what type of data does each and every node hold? It's a shared-no architecture. So, whatever task is given to a virtual processor it will be processed. If there's a failure, then it will be taken care of by another virtual processor. Moreover, this solution has impacted the query time and data performance. In Teradata, there's a lot of joining, partitioning, and indexing of records. There are primary and secondary indexes, hash indexing, and other indexing processes. To improve query performance, we first analyze the query and tune it. If a join needs a secondary index, which plays a major role in filtering records, we might reconstruct that particular table with the secondary index. This tuning involves partitioning and indexing. We use these tools and technologies to fine-tune performance. When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration. But, these technologies are quite old now. With newer big data technologies, we've worked with a four-layer architecture, pulling data from Hadoop Lake to Teradata. We configure Teradata with the appropriate hostname and credentials, and use BTEQ queries to load data. Previously, we converted the data warehouse to a CLD model as per Teradata's standardized procedures, moving from an ETL to an EMT process. This allowed us to perform gap analysis on missing entities based on the model and retrieve them from the source system again. We found Teradata integration straightforward and compatible with other tools.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It helps clean messy data and provides spatial analysis."
"It has everything that one needs. Whatever you want to do with the data can be done with Alteryx."
"The drag and drop and layout is simple to understand, with intuitive names of features."
"The scheduling feature for the automation is excellent."
"The analytics are easy​."
"You get more support with Alteryx, and it's good for non-sophisticated users who can benefit from the support included in the price."
"The solution has excellent drag and drop functionality. There's no need for coding."
"The feature that I have found most valuable for Alteryx is its geo-referencing feature, it is very good. I use it a lot, especially for supply chain."
"The most valuable feature is the set of libraries that are used to support the functionality that we require."
"The most valuable feature is the Jupyter notebook that allows us to write the Python code, compile it on the fly, and then look at the results."
"The best part of Anaconda is the media distribution that comes as part of it. It gets us started very quickly."
"It provides a unified platform where you can install Jupyter, Python Spider, and other related tools without needing separate installations."
"It helped us find find the optimal area for where our warehouse should be located."
"The tool's most valuable feature is its cloud-based nature, allowing accessibility from anywhere. Additionally, using Jupyter Notebook makes it easy to handle bugs and errors."
"The product is responsive, sleek and has a beautiful interface that is pleasant to use. It helps users to easily share code."
"It has a lot of functionality available, supports many libraries, and the developers are continually improving it."
"Teradata's pretty fast."
"​We really enjoy the FastLoad, TPump, and MultiLoad features.​"
"It's very, very fast"
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"​Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"It is a highly robust software solution."
 

Cons

"The learning curve is long, and there is lack of e-learning; the tool is not user-friendly to a non-technical user."
"The formula we currently use in Alteryx can be automated."
"It would be great if Alteryx could take third party tools and incorporate them."
"The screen when you are looking into your workflows and your ETL processes needs to be improved. You cannot manage it very well."
"The product's pricing needs improvement."
"Lacks an open source edition which would be helpful."
"It would be beneficial if Alteryx could lower its price or introduce a loyalty program for individual consultants and freelancers like me."
"Its most valuable feature lies in its functionality."
"Having a small guide or video on the tool would help learn how to use it and what the features are."
"It crashes once in a while. In case of a reboot or something unexpected, the unseen code part will get diminished, and it relatively takes longer than other applications when a reboot is happening. They can improve in these areas. They can also bring some database software. They have software for analytics and virtualization. However, they don't have any software for the database."
"The interface could be improved. Other solutions, like Visual Studio, have much better UI."
"It also takes up a lot of space."
"Anaconda should be optimized for RAM consumption."
"When you install Anaconda for the first time, it's really difficult to update it."
"The solution would benefit from offering more automation."
"Anaconda could benefit from improvement in its user interface to make it more attractive and user-friendly. Currently, it's boring."
"The increasing volumes of data demand more and more performance."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"They should add more connectors to different platforms."
"I would like more security and speed."
"Teradata can improve the way it handles big data and unstructured data."
"The primary challenge with Teradata lies in its cost structure, encompassing subscription fees, software licenses, and hardware expenses."
"Teradata hardly supports unstructured data or semi-structured data"
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
 

Pricing and Cost Advice

"The cost of Alteryx is approximately $2,900 annually."
"In order to have designers, and, if you want to collaborate, you have to buy a server. If the designer is $5,000, and if you want a server, you have to pay $80,000."
"The seat is too expensive."
"It's very expensive. I'd rate it a four out of ten in terms of the price. It's great for big companies but not for small companies."
"The price could be better."
"We have a yearly cost that we pay for the licensing. We do not pay any costs in addition to the licensing fees."
"I rate the tool's pricing a two out of ten."
"We use the free version of the solution. There are enterprise licenses available. It cost approximately $5,000 annually. It is an expensive solution and there are additional features that cost more money."
"The licensing costs for Anaconda are reasonable."
"The tool is open-source."
"My company uses the free version of the tool. There is also a paid version of the tool available."
"Anaconda is free to use, but in terms of hardware costs, you might need heavy GPUs to run CUDA and other demanding tasks."
"The product is open-source and free to use."
"The price of Teradata could be less expensive."
"Teradata pricing is fine, and it's competitive with all the legacy models. On a scale of one to five, with one being the worst and five being the best, I'm giving Teradata a three, because it can be a little expensive, when compared to other solutions."
"The price of the solution could be reduced, it is expensive."
"Teradata is not cheap, but you get what you pay for."
"It's a very expensive product."
"Price is quite high, so if it is really possible to use other solutions (e.g. you do not have strict requirements for performance and huge data volumes), it might be better to look at alternatives from the RDBMS world."
"I am using the free version of Teradata."
"Teradata is currently making improvements in this area."
report
Use our free recommendation engine to learn which Predictive Analytics solutions are best for your needs.
849,963 professionals have used our research since 2012.
 

Comparison Review

it_user232068 - PeerSpot reviewer
Aug 5, 2015
Netezza vs. Teradata
Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Computer Software Company
10%
Manufacturing Company
9%
Healthcare Company
6%
Financial Services Firm
20%
Computer Software Company
9%
Government
8%
Manufacturing Company
8%
Financial Services Firm
26%
Computer Software Company
11%
Healthcare Company
7%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
One of the differences is that with Alteryx you can use it as an ETL and analytics tool. Please connect with me direc...
What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
Alteryx is an extremely easy and flexible data tool, flexible in terms of drag and drop toolset and also has python, ...
What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
I am not familiar with IBM SPSS Modeler, therefore, I cannot compare these two products. Regarding Alteryx I can say...
What do you like most about Anaconda?
The tool's most valuable feature is its cloud-based nature, allowing accessibility from anywhere. Additionally, using...
What is your experience regarding pricing and costs for Anaconda?
Anaconda is an open-source tool, so I do not pay anything for it. It is compatible with every tool, regardless of whe...
What needs improvement with Anaconda?
There is room for improvement, especially regarding deployment. The process could be streamlined as the number of act...
Comparing Teradata and Oracle Database, which product do you think is better and why?
I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may d...
Which companies use Teradata and who is it most suitable for?
Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if ...
Is Teradata a difficult solution to work with?
Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if ...
 

Comparisons

 

Also Known As

No data available
No data available
IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture
 

Overview

 

Sample Customers

AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy Queen
LinkedIn, NASA, Boeing, JP Morgan, Recursion Pharmaceuticals, DARPA, Microsoft, Amazon, HP, Cisco, Thomson Reuters, IBM, Bridgestone
Netflix
Find out what your peers are saying about Alteryx, SAP, Anaplan and others in Predictive Analytics. Updated: April 2025.
849,963 professionals have used our research since 2012.