We performed a comparison between Oracle Autonomous Data Warehouse and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The analytics have been very good. We've found them to be quite useful."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"A very good integration feature that restricts access to unauthorized people."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"It is a solid database a lot of different tools to move data."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"Teradata's best feature is its speed with historical data."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"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."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"Ease of connectivity could be improved."
"A lot of the tools that were previously there have now been taken away."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"The setup is not straightforward."
"Teradata hardly supports unstructured data or semi-structured data"
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"The user interface needs to be improved."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Teradata is rated 8.2. The top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". 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 Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Azure Data Factory, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our Oracle Autonomous Data Warehouse vs. Teradata report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.