We performed a comparison between Amazon Aurora and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution’s scalability is good since we don’t need to take a maintenance window during unpredictable workloads. I like the solution’s behind-the-scenes happenings. It is a great feature."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"The most valuable feature of Amazon Aurora is SQL standardization, it doesn't have its own syntax which is good. It has a lot of hands-off self-management type of activities, such as log rolling and auto-scaling."
"The most valuable feature is that the maintainability is offloaded to the service provider. I don't have to maintain a database or do any administrative tasks, which comes in handy."
"The most valuable feature is the ability to do multiple-read and single-write. These are the kinds of features that we were interested in, and Aurora takes care of that natively."
"The provision of custom read and write endpoints eliminates the need for managing a separate proxy load balancer."
"Aurora's compatibility with MySQL or PostgreSQL benefited our database management. The migration from on-premise MySQL to Aurora was similar, so we didn't need to change our source code."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"The initial setup was straightforward."
"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."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"It's very mature from a technology perspective."
"It would have been helpful if they had provided some benchmarking numbers."
"The product's distributed query process for MySQL needs improvement."
"I would like to see more AI-related features in future releases."
"There is improvement needed to have more developer focus. Additionally, it would be helpful to have a stand-alone solution outside of Amazon. Amazon has a tendency to favor developing web-based clients, which may not always provide the fastest or most responsive solution as desired."
"It is a bit costly. The features are quite good, and I wouldn't say it requires any technical improvements. But from a cost perspective, some clients wouldn't go for Aurora because of that."
"I would like to see performance insights on the database based on the queries. Currently, we use SolarWinds as the monitoring tool. I would like to leverage SolarWinds’ performance insights in AWS services. SolarWinds gives larger insights when we run performance issues."
"The pricing could improve. It should be reduced."
"The setup is not straightforward."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"Teradata can improve the way it handles big data and unstructured data."
"I would like to see more integration with many different types of data."
"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)."
"Teradata hardly supports unstructured data or semi-structured data"
"The current operational approach needs improvement."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
Amazon Aurora is ranked 11th in Relational Databases Tools with 7 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. Amazon Aurora is rated 7.8, while Teradata is rated 8.2. The top reviewer of Amazon Aurora writes "Easy-to-manage platform with a valuable auto-scaling feature ". 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". Amazon Aurora is most compared with SQL Server, Oracle Database, MariaDB, CockroachDB and SingleStore, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our Amazon Aurora vs. Teradata report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.