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 provision of custom read and write endpoints eliminates the need for managing a separate proxy load balancer."
"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 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."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"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 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."
"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."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"The performance is great, we are able to query our data in one operation."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"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's a pre-configured appliance that requires very little in terms of setting-up."
"The flexibility in design is very good."
"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 would have been helpful if they had provided some benchmarking numbers."
"The product's distributed query process for MySQL needs improvement."
"The pricing could improve. It should be reduced."
"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."
"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."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"I would like to see more integration with many different types of data."
"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."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"The increasing volumes of data demand more and more performance."
"The current operational approach needs improvement."
"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."
"There is some improvement required on OLTP level and some analytical function is missing."
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.