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 has everything that one needs. Whatever you want to do with the data can be done with Alteryx."
"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 philosophy of the citizen data scientist is the key piece, which means the no-code analytics capability. This is the feature that attracted us the most."
"Alteryx speeds up the time to obtain business answers/insights on data."
"It saves time on a lot projects. ​"
"I think the most valuable feature for Alteryx in a health facility is that it permits cleaning, organizing, and merging of databases such as Excel and Access."
"All of the data science features in terms of unioning and joining data together are valuable."
"My primary focus is creating numerous data pulls, and Alteryx Server handles the automation well."
"With Anaconda Navigator, we have been able to use multiple IDEs such as JupyterLab, Jupyter Notebook, Spyder, Visual Studio Code, and RStudio in one place. The platform-agnostic package manager, "Conda", makes life easy when it comes to managing and installing packages."
"The solution is stable."
"The notebook feature is an improvement over RStudio."
"The product is responsive, sleek and has a beautiful interface that is pleasant to use. It helps users to easily share code."
"It helped us find find the optimal area for where our warehouse should be located."
"It has a lot of functionality available, supports many libraries, and the developers are continually improving it."
"Anaconda is an open-source platform that can integrate numerous other kits and models in one place."
"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."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"It is very stable. It's 100% uptime. Speed and resilience are one of the greatest features of this product. In almost twenty years we've never had downtime, except for outages for patches and upgrades. We've never had a system failure in twenty years."
"The ease of deployment is useful so clients are up and running quickly in comparison to other products."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
 

Cons

"The tool could include more native connectors, such as for global ERPs, instead of requiring additional fees for these connections."
"It would be great to create the final users' visualization within Alteryx."
"There are a few imputation techniques which they really need to include."
"The only weakness I would say is on the visualization side of having that dynamic incapability."
"I honestly can't think of anything that needs to be improved."
"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."
"The server is too expensive for what you get and it really a designer desktop on a server."
"It should have Linux support. It currently supports only Windows. It does not support any other platform. Its price should also be lower. Their US partner management program is actually unresponsive. One of the reasons why we don't have a formalized partnership plan with them is because their partner management team is atrociously unresponsive. This is something that they need to change."
"It also takes up a lot of space."
"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."
"When you install Anaconda for the first time, it's really difficult to update it."
"A lot of people and companies are investing in creating automated data cleaning and processing environments. Anaconda is a bit behind in that area."
"The process could be streamlined as the number of actions needed to deploy is quite large compared to other tools."
"I think better documentation or a step-by-step guide for installation would help, especially for on-premise users."
"One thing that hurts the product is that the company is not doing more to advertise it as a solution and make it more well known."
"Anaconda consumes a significant amount of processing memory when working on it."
"The following could be better: licensing, architecture openness, integration with other tools."
"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."
"The SQL Assistant is very basic. This tool can be improved for usability."
"Teradata's UI could be more user-friendly."
"From my perspective, it would be good if they gave better ITIN/R plugins to use the data for AI modeling, or data science modeling. We can do it now; however, it could be more elegant in terms of interfacing."
"It needs a teaching web site with more training on third-party tools used for BI."
"The increasing volumes of data demand more and more performance."
"There is some improvement required on OLTP level and some analytical function is missing."
 

Pricing and Cost Advice

"While it offers extensive features, including predictive analytics, for those who mainly use it for data preparation and blending, the cost can be prohibitive."
"The designer has a list price of $5,995 USD."
"There is a license required for this solution."
"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 price for Alteryx Designer is reasonable but the price for Alteryx Server for universal collaborations is too expensive."
"The seat is too expensive."
"ROI is huge. There are some secondary benefits, like analysts getting their post 5 PM time back or the ability to shorten all closing processes to a half or less."
"The cost of Alteryx is approximately $2,900 annually."
"The product is open-source and free to use."
"Anaconda is free to use, but in terms of hardware costs, you might need heavy GPUs to run CUDA and other demanding tasks."
"The licensing costs for Anaconda are reasonable."
"My company uses the free version of the tool. There is also a paid version of the tool available."
"The tool is open-source."
"​When looking into implementing this product, pricing is the main issue followed by technical expertise​."
"The price of the solution could be reduced, it is expensive."
"Teradata's licensing is on the expensive side."
"The cost of running Teradata is quite high, but you get a good return on investment."
"​I would advise others to look into migration and setup as a fixed price and incorporate a SaaS option for other Teradata services​."
"Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."
"The solution requires a license."
"Teradata is a very expensive solution."
report
Use our free recommendation engine to learn which Predictive Analytics solutions are best for your needs.
849,686 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
10%
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,686 professionals have used our research since 2012.