6 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.6 out of 100
14 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8 out of 100

Likelihood to Recommend

Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse is well suited for on-prem to cloud situations. That is more controllable as we have control over the ETL tools and database. It is still a challenge to adopt ADW on a full scale for cloud-to-cloud implementations primarily because the tool is still evolving and the challenges pose a risk to critical implementations without resolving the challenges.
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance

It is highly applicable for large, corporate companies with data coming from multiple sources. Teradata can be used as an ODS (Operational Data Store) to merge the source data, then it can also be used to create development/UAT databases, and production databases under the same server. It is capable of processing billions of records per day. It is less appropriate for companies with a single source of data.
Anonymous | TrustRadius Reviewer

Pros

Oracle Autonomous Data Warehouse

  • It enables us to execute large queries quicker
  • It is easier to set up
  • It is easier to manage
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance

  • Can query multiple databases within one server and view all results in one window. Helps speed up analysis.
  • Teradata uses AMPs (Access Module Processors) to increase speed of data processing/queries. You must use 'COLLECT STATISTICS' properly to efficiently use the AMPs.
  • Most standard SQL practices work on Teradata. Also, Teradata formats the query in a nice colored structure.
  • Can search for tablenames or specific columnnames across the entire server. Helps when changing a specific column or table structure.
Anonymous | TrustRadius Reviewer

Cons

Oracle Autonomous Data Warehouse

  • Use case for hybrid environment
  • Price factor
  • Clustering
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance

  • Errors on compiling a procedure are sometimes hard to decipher. Teradata provides a line number of the error but this number does not always match the line number of the procedure in the query window.
  • Teradata won't run a query if I copy and paste from my internal company chat. Something with the formatting from the chat creates a syntax error, so I have to take time to rewrite the query.
  • I haven't been able to insert multiple new rows into a table with 1 insert. Other SQL programs allow this with a comma, but Teradata makes you create separate inserts for each row.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Oracle Autonomous Data Warehouse

Since our core was Oracle ERP Cloud, we were looking for a cloud data warehouse solution from Oracle. Autonomous Data Warehouse perfectly fit that need and has already provided us with the results. Our CSM and the readily available support helps us to resolve issues and find solutions at no extra cost. The tool comes with APEX and Machine Learning developer tools that add more value to what we are planning to invest in future.
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance

No answers on this topic

Return on Investment

Oracle Autonomous Data Warehouse

  • Price factor is not good
  • Report generation is great
  • Performance is outstanding
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance

  • Enabled next-day reporting.
  • Better customer service as field technicians can see instant performance.
  • Needed to hire more employees for overnight support.
Anonymous | TrustRadius Reviewer

Screenshots

Teradata Data Warehouse Appliance

Pricing Details

Oracle Autonomous Data Warehouse

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Teradata Data Warehouse Appliance

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison