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.
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The solution integrates well with Power BI."
"The performance and scalability are awesome."
"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."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"I've never had any issues with scalability."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"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."
"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."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"The initial setup was pretty complex. It was not easy."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Teradata's UI could be more user-friendly."
"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."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
Autonomous Data Warehouse is market-leading Oracle Database software running on proven Oracle Exadata infrastructure that is optimized to deliver unbeatable performance for data warehouse workloads. Built-in adaptive machine learning eliminates manual labor for administrative management. With Oracle, business and enterprise users can now build their own data warehouse, data mart, or sandbox in a few minutes.
Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.
Oracle Autonomous Data Warehouse is ranked 9th in Cloud Data Warehouse with 4 reviews while Teradata is ranked 3rd in Data Warehouse with 16 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Teradata is rated 8.2. The top reviewer of Oracle Autonomous Data Warehouse writes "Integrates well with other cloud services, provides great ROI and guarantees 99.995% up-time". On the other hand, the top reviewer of Teradata writes "Very fast with good database control and excellent support". Oracle Autonomous Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake, Amazon Redshift and IBM Db2 Warehouse, whereas Teradata is most compared with Snowflake, Oracle Exadata, SQL Server, Vertica and Microsoft Azure Synapse Analytics. See our Oracle Autonomous Data Warehouse vs. Teradata report.
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.