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."Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"The solution integrates well with Power BI."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"Self-patching and runs machine-learning across its logs all the time"
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"Cuts time to process huge amounts of data with efficient analytical queries."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"Improved performance of ETL procedures, reporting."
"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's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"Teradata's most valuable feature is that it's easy to use."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"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 installation process is complex. Oracle can make the installation process better."
"The initial setup was pretty complex. It was not easy."
"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."
"Ease of connectivity could be improved."
"I would like to see an on-premise solution in the future."
"The solution lacks visibility options."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"Needs compatibility with more Big Data platforms."
"Teradata is a bit late for the cloud."
"The user interface needs to be improved."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"Teradata's UI could be more user-friendly."
"The SQL Assistant is very basic. This tool can be improved for usability."
"Limited interest and success in some areas make us hesitate about upgrading."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 7 reviews while Teradata is ranked 3rd in Data Warehouse with 21 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Teradata is rated 8.4. 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 "Very fast with good database control and excellent support". 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, MySQL, Oracle Exadata 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.