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."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 performance and scalability are awesome."
"The analytics have been very good. We've found them to be quite useful."
"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."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The product is easy to use."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"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."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"It has a solid set of tools and consulting services."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"Designing the database is easy."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"They should make the solution more user-friendly."
"The installation process is complex. Oracle can make the installation process better."
"I would like to see an on-premise solution in the future."
"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."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"The solution lacks visibility options."
"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."
"The initial setup was pretty complex. It was not easy."
"Teradata's UI could be more user-friendly."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"There is some improvement required on OLTP level and some analytical function is missing."
"I would like to see more integration with many different types of data."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"GUI of administrative tools is really outdated."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
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 Snowflake, Oracle Exadata, 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.