We performed a comparison between Oracle Exadata and Teradata based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Teradata has a slight edge in this comparison since it received slightly higher marks in the Ease of Deployment category.
"The tool performs well with a large database."
"The most valuable feature of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in time in the enterprise manager."
"The most valuable feature is the time to solution."
"Oracle Exadata is stable."
"Exadata's best features are its performance during redo logging and the elasticity of the database handling."
"Parallelism is the most valuable feature."
"The data replication is very good."
"Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"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."
"Teradata's best feature is its speed with historical data."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"Oracle Exadata could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
"I would like to see more database features and maybe more archiving features, because we need to do data archiving."
"Since the product is an appliance, it is very costly."
"We have a little trepidation with the system as it does have a learning curve. Also changing to a binary logging format for us feels like retrograde motion, but sadly almost all Linux variants have moved in this direction."
"The solution lacks a visualized console."
"The handling of temp space has room for improvement."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"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."
"There is some improvement required on OLTP level and some analytical function is missing."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"The following could be better: licensing, architecture openness, integration with other tools."
Oracle Exadata is ranked 2nd in Data Warehouse with 125 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Oracle Exadata is rated 8.4, while Teradata is rated 8.2. The top reviewer of Oracle Exadata writes "Offers a variety of valuable features". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". Oracle Exadata is most compared with Oracle Database Appliance, Oracle Autonomous Data Warehouse, Snowflake, Amazon Redshift and VMware Tanzu Data Services, whereas Teradata is most compared with SQL Server, Snowflake, MySQL, BigQuery and Amazon Redshift. See our Oracle Exadata vs. Teradata report.
See our list of best Data Warehouse vendors.
We monitor all Data Warehouse 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.