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."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"It is a very stable tool...It is an extremely scalable tool."
"The product is easy to use."
"The performance and scalability are awesome."
"A very good integration feature that restricts access to unauthorized people."
"The solution scales well on the cloud."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"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 features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"The flexibility in design is very good."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"It's very mature from a technology perspective."
"The initial setup was straightforward."
"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."
"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."
"The solution lacks visibility options."
"They should make the solution more user-friendly."
"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."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"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."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Teradata hardly supports unstructured data or semi-structured data"
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"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."
"The current operational approach needs improvement."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"Teradata's UI could be more user-friendly."
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.