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."It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"It is a very stable tool...It is an extremely scalable tool."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"The analytics have been very good. We've found them to be quite useful."
"It is a stable and scalable solution."
"A very good integration feature that restricts access to unauthorized people."
"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."
"The solution integrates well with Power BI."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"The functionality of the solution is excellent."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"It's very, very fast"
"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."
"The solution scales well on the cloud."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"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."
"A lot of the tools that were previously there have now been taken away."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"Ease of connectivity could be improved."
"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."
"The solution lacks visibility options."
"The following could be better: licensing, architecture openness, integration with other tools."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"The SQL Assistant is very basic. This tool can be improved for usability."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"Teradata is a bit late for the cloud."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"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."
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.