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

SAP Analytics Cloud vs Teradata comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

Review summaries and opinions

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

Categories and Ranking

SAP Analytics Cloud
Ranking in BI (Business Intelligence) Tools
4th
Average Rating
8.0
Reviews Sentiment
7.4
Number of Reviews
69
Ranking in other categories
Predictive Analytics (2nd)
Teradata
Ranking in BI (Business Intelligence) Tools
10th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
76
Ranking in other categories
Customer Experience Management (6th), Backup and Recovery (20th), Data Integration (17th), Relational Databases Tools (7th), Data Warehouse (3rd), Marketing Management (6th), Cloud Data Warehouse (6th)
 

Mindshare comparison

As of April 2025, in the BI (Business Intelligence) Tools category, the mindshare of SAP Analytics Cloud is 4.4%, down from 5.8% compared to the previous year. The mindshare of Teradata is 0.8%, up from 0.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

RamasamyTelungupalayam - PeerSpot reviewer
Seamless integration, collaborative features, and enhances data exploration
There are several areas for improvement in SAP Analytics Cloud. Firstly, features available in SAP Lumira are missing in SAP Analytics Cloud. Secondly, the predictive analytics functions, although promising, are currently only suitable for Proof of Concepts (POCs) and not for industrial-scale use. Lastly, the pricing model for the planning functionality is quite high and presents an entry barrier.
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

"The tool's most valuable features are the BI and planning functionalities. I value being able to integrate smart planning with BI for analysis. The solution is user-friendly."
"The ability to collaborate and plan together is great."
"All of the modules that we used to have separately in our on-premises solution are now integrated into one platform."
"Data integration is very good."
"The reporting, dashboards, KPIs, and visualization are the most valuable."
"If 85-90% of your data comes from SAP, then it's the best solution."
"The product is flexible and has features like AI, link analysis, and insights. It has many features. I can search, and it creates automatic charts without selecting anything. For example, I can ask, "What is the gross margin?" the tool builds a chart based on my question."
"We mainly use Analytics Cloud because it integrates with other SAP solutions. Our ERP is an SAP product, and our back-end is SAP Business Warehouse, so integration is an essential factor."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"I like writing preformance queries for preprocessing on AWS Cloud."
"The product's scalability is great. Scalability-wise, I rate the solution a ten out of ten."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
 

Cons

"I am not happy with the predictive analytics features and smart features offered by the product, making them areas where improvements are required."
"The price, integration, and modeling capabilities could be better. I have to use an integration engine to integrate our products and databases. SAP Analytics Cloud is made specifically for KPIs and business intelligence. The modeling capabilities are kind of poor. You always have to model the data and then present it visually in SAP Analytics Cloud. In the next release, I would like to have a lite version for planning to create scenarios quickly. For me personally, planning is the most complicated feature of SAP Analytics Cloud."
"Could be more user-friendly; somewhat complicated to use."
"The general management of this solution could be improved. The graphics or icons could also be improved to allow them to integrate with other environments on the web."
"Improvements are coming quarterly whereas previously it was on a monthly basis."
"If the application has many pages or a page with more charts, it tends to load slowly."
"What could be improved in SAP Analytics Cloud is integration, particularly in terms of extracting data from the source system. Currently, its data extraction mechanism doesn't have good integration and needs improvement."
"It's lacking a bit in maturity and we find we can't run our business off it until it's improved."
"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 reporting side wasn't very good in the past, but with the latest versions, it's getting better. Still, the friendliness of the PDC reporting and functionality needs to be improved."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"The tool's flexibility and capacity for expansion are areas of concern where improvements are required."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"It is hard for some of our users to set up rules for cleansing and transforming data, so this is something that could be improved."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"I would like to see an improved Knowledge Base on the web."
 

Pricing and Cost Advice

"I don't have the exact price for SAP Analytics Cloud, but it could be improved and made cheaper, especially when compared to Power BI."
"The pricing of this product is reasonable."
"SAP Analytics Cloud is a bit higher [in price]. Because, if Microsoft can afford a better product and lower cost, SAP can afford at least the same, or even lower."
"The pricing is based on an annual license and is rated a four out of ten."
"Its price is slightly on the higher side."
"SAP Analytics Cloud can be quite expensive."
"The premium option is very expensive at five thousand dollars. I use the nine hundred and ninety-nine dollar option."
"The platform is about 50% more expensive than Power BI."
"I rate the product price a nine on a scale of one to ten, where one is cheap and ten is expensive."
"Teradata is not cheap, but you get what you pay for."
"The price of Teradata could be less expensive."
"The initial cost may seem high, but the TCO is low."
"The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing."
"We had a lot of parties involved when purchasing from the AWS Marketplace. They are very flexible and aggressive in trying to close the deal. They are good at what they have to offer and listening to the customer. It's a two-way street."
"In the past, it turned out that other solutions, in order to provide the full range of abilities that the Teradata platform provides plus the migration costs, would end up costing more than Teradata does."
"Make sure you have the in-house skills to design and support the solution, as relying on external sources is extremely costly and tends to lock you into specific platforms, tools, and paradigms."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
847,625 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
Educational Organization
18%
Manufacturing Company
16%
Computer Software Company
9%
Financial Services Firm
7%
Financial Services Firm
26%
Computer Software Company
11%
Manufacturing Company
7%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Which would you choose - Tableau or SAP Analytics Cloud?
Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use. This relatively short amount of time can make all the difference for companies ...
What do you like most about SAP Analytics Cloud?
In the data warehouse, you're free to make changes. You can make everything text, meaning it's always a string. Even numbers appear as text, giving you the flexibility to work with all columns.
What is your experience regarding pricing and costs for SAP Analytics Cloud?
The pricing model for SAP Analytics Cloud is quite competitive, but the cost for the planning functionality is high and can be a barrier to entry. The overall cost can be managed with better billin...
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 declare Teradata better than Oracle is the pricing. Both solutions are quite simi...
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 it would be compatible with our field. According to the product's site, the comp...
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 you just ask. There are some features that may cause difficulties - for example,...
 

Also Known As

SAP BusinessObjects Cloud
IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture
 

Overview

 

Sample Customers

Live Oak Bank
Netflix
Find out what your peers are saying about SAP Analytics Cloud vs. Teradata and other solutions. Updated: April 2025.
847,625 professionals have used our research since 2012.