Oracle Database Appliance vs Teradata comparison

Oracle Database Appliance

Read 76 Teradata reviews

5,280 Views
4,015 Comparison Views

87% willing to recommend

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Oct 6, 2024

Teradata and Oracle Database Appliance are strong competitors in providing database solutions. Oracle Database Appliance appears to have an edge due to its integrated features and higher perceived long-term value.

Features: Teradata is known for its powerful analytics capabilities, competitive pricing, and strong customer support. Oracle Database Appliance stands out for its integrated solutions, scalability, and seamless system integration.

Room for Improvement: Teradata users mention the need to address system complexity, steep learning curve, and improved user interface. Oracle Database Appliance users suggest enhancements in documentation, more frequent software updates, and a better licensing model.

Ease of Deployment and Customer Service: Teradata offers customizable deployment models, though users find complexity challenging. Oracle Database Appliance is recognized for its straightforward deployment process and reliable customer service.

Pricing and ROI: Teradata is appreciated for its favorable setup costs and perceived reasonable ROI. Oracle Database Appliance, while more expensive, is valued for its comprehensive functionality and lower maintenance overhead, suggesting better long-term value.

To learn more, read our detailed Oracle Database Appliance vs. Teradata Report (Updated: November 2024).

Oracle Database Appliance vs. Teradata

November 2024

Download the complete report

Helped 815,854 peers since 2012

Categories and Ranking

Oracle Database Appliance

Ranking in Data Warehouse

8th

Average Rating

8.0

Number of Reviews

Ranking in other categories

No ranking in other categories

Teradata

Ranking in Data Warehouse

3rd

Average Rating

8.2

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Customer Experience Management (3rd), Backup and Recovery (20th), Data Integration (17th), Relational Databases Tools (7th), BI (Business Intelligence) Tools (10th), Marketing Management (6th), Cloud Data Warehouse (6th)

Mindshare comparison

As of November 2024, in the Data Warehouse category, the mindshare of Oracle Database Appliance is 5.4%, down from 6.5% compared to the previous year. The mindshare of Teradata is 17.1%, up from 14.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Warehouse

Featured Reviews

AdnanNaseem

Senior Database Administrator at Techlogix

Apr 4, 2024

Offers built-in utilities and tools that simplify management

We use it for a medium-sized company and for databases. The database is installed on it because it's best for the database. Efficiency and performance are good for the database as compared to other servers. I work on different general sites, website applications, servers, Linux, etc. Oracle…

Read full review

SurjitChoudhury

Data engineer at Cocos pt

Feb 20, 2024

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.

Read full review

Quotes from Members

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

Pros

"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."

"Easy management (it saves a lot of installation and patching time)."

"The product is very light."

"We use the solution for our Java applications."

"If the database goes down on one of the servers, the load is automatically shifted to another server. You can troubleshoot the one that is down without affecting uptime."

"The solution is simple to use and easy to maintain."

"We value the appliance architecture with its “everything-in-a-box” highly standardized setup."

"The product’s valuable feature is its capability to pre-configure and pre-install the settings."

More Oracle Database Appliance pros

"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."

"Teradata's pretty fast."

"Teradata's most valuable feature is that it's easy to use."

"Designing the database is easy."

"The data mover is valuable over the last two years as it allows us to achieve data replication to our disaster recovery systems."

"It is a stable solution. Stability-wise, I rate the solution a nine out of ten."

"Teradata's best feature is its speed with historical data."

"The data processing, clustering, and distributed computing are impressive."

More Teradata pros

Cons

"The product is quite complex to set up, initially. It would be ideal if it was simpler."

"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."

"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."

"Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive."

"I would like it if the scalability could be increased without having to change versions."

"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."

"The product's technical support services need improvement."

"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."

More Oracle Database Appliance cons

"It could be a bit more user-friendly."

"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."

"Azure Synapse SQL has evolved from a solely dedicated support tool to a data lake. It can store data from multiple systems, not just traditional database management systems. On the other hand, Teradata has limitations in loading flat files or unstructured data directly into its warehouse. In Azure Synapse SQL, we can implement machine learning using Python scripts. Additionally, Azure Synapse SQL offers advanced analytical capabilities compared to Teradata. Teradata is also expensive."

"When backups are performed, it locks the database, preventing user access, which is a concern."

"There are some ways that the handling of unstructured data could be improved."

"Teradata hardly supports unstructured data or semi-structured data"

"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."

"The current operational approach needs improvement."

More Teradata cons

Pricing and Cost Advice

"I would rate the pricing a four on a scale of one (high price) to ten (low cost)."

"The price of the solution should be less expensive. However, they will increase the price more."

"The solution may be expensive, but when we consider the problems it solves, the stability it provides, and the fact that we don't have to buy separate parts and assemble them into a system, it becomes more affordable."

"I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL."

"Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."

"The price should be lower."

"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."

"The product is costly."

More Oracle Database Appliance pricing and cost advice

"Teradata used to be expensive, but they have been lowering their prices."

"Teradata is expensive but gives value for money, especially if you don't want to move your data to the cloud."

"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 tool costs about 30,000 euros a month, while Azure Synapse SQL only costs 10,000."

"Teradata is not cheap, but you get what you pay for."

"In this day and age, we want to get things done quickly. So, we go to the AWS Marketplace."

"The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."

"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."

More Teradata pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.

See recommendations

815,854 professionals have used our research since 2012.

Comparison Review

it_user232068

Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees

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…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

29%

Computer Software Company

11%

Government

Manufacturing Company

Financial Services Firm

26%

Computer Software Company

10%

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Oracle Database Appliance?

Oracle Database Appliance provides high stability.

What is your experience regarding pricing and costs for Oracle Database Appliance?

Oracle solutions are a bit overpriced, especially for small or medium businesses. I would prefer a slightly lower price point.

What needs improvement with Oracle Database Appliance?

All improvements for ODA are already applied or enhanced in Exadata. ODA is mainly for small businesses or limited businesses and is used predominantly for database warehouses and not for OLTP data...

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,...

Oracle Exadata vs Oracle Database Appliance

Comparisons

Compared 69% of the time

VMware Tanzu Data Solutions vs Oracle Database Appliance

Compared 14% of the time

Dremio vs Oracle Database Appliance

Compared 7% of the time

Actian Ingres vs Oracle Database Appliance

Compared 4% of the time

Amazon Redshift vs Oracle Database Appliance

Compared 3% of the time

More Oracle Database Appliance Competitors

SQL Server vs Teradata

Compared 14% of the time

Oracle Exadata vs Teradata

Compared 13% of the time

Snowflake vs Teradata

Compared 9% of the time

MySQL vs Teradata

Compared 8% of the time

Vertica vs Teradata

Compared 5% of the time

More Teradata Competitors

Product Reports

Oracle Database Appliance

November 2024

Download Oracle Database Appliance product report

Download Teradata product report

October 2024

Also Known As

X5-2

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

Learn More

Oracle

Overview

Oracle Database Appliance is the easiest and most affordable way for small or medium-size organizations to run Oracle databases and applications and is an ideal platform for remote and edge computing environments. Customers reduce Oracle Database deployment times and management workloads using a prebuilt integrated system with management automation. As demonstrated in IDC’s business value study (PDF), Oracle Database Appliance lets customers grow revenue and control costs, delivering up to a 498% return on investment (ROI) over five years.

Teradata is a scalable data analytics platform designed to meet enterprise demands for large-scale data management and processing, focusing on performance, scalability, and security for complex query executions.

As a leading data warehousing solution, Teradata integrates advanced analytics enabling organizations to derive insights from massive datasets. It supports high-volume data workloads with its architecture optimized for analytical queries. Users benefit from its robust scalability, allowing seamless expansion as data grows. Teradata's SQL engine is compatible with a wide range of data types, ensuring flexibility in data analysis. With advanced security measures, it protects sensitive data across various environments, providing peace of mind to users handling critical information.

What are the most important features of Teradata?

Linear Scalability: Easily expands data processing capabilities to handle increasing data loads without performance degradation.
Advanced Analytics: Supports complex analytical operations integrating machine learning and AI for predictive insights.
SQL Compatibility: Offers a comprehensive SQL interface that supports complex queries across diverse data types.
Data Security: Implements rigorous security protocols to protect data integrity and confidentiality.

What benefits and ROI should users look for?

Improved Decision-Making: Derive actionable insights quickly for strategic business decisions.
Cost Efficiency: Optimized resource usage reduces operational costs associated with data processing.
Increased Productivity: Streamlined data operations save time, allowing teams to focus on analysis.
Enhanced Scalability: Seamless growth without significant additional investment as data volumes increase.

Teradata is widely used in industries like finance, telecommunications, and healthcare, where data-driven decisions are critical. Companies leverage its robust analytics capabilities to enhance customer experiences, streamline operations, and ensure compliance with regulatory requirements. In these sectors, quick access to data insights can significantly impact competitive advantage.

Sample Customers

LifeLock, Incarlopsa, Al Yusur Industrial Contracting

Netflix