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

Likelihood to Recommend

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

Teradata Enterprise Data Warehousing

Teradata is the premier analytic platform. If you need to enable real-time access to multiple terabytes/petabytes of your organization's data to help you make real-time decisions in a way that translates into real dollars in sales and strengthened customer relationships then there is no better choice. Teradata is NOT an OLTP appropriate database and it may not be the best place to process all your data but as far as enabling your Analytic enterprise Teradata is always going to provide the best ROI for medium and large enterprises and now with new cloud integration even small enterprises can have the advantages of Teradata that used to be only available to the larger enterprises.
Anonymous | TrustRadius Reviewer

Pros

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

Teradata Enterprise Data Warehousing

  • Very capable enterprise data warehouse platform leveraging the MPP architecture. One of the leaders in the market in MPP space today
  • High performance data ingestion and query engine
  • Utilities like QueryGrid allows for data federation, BTEC and FastLoad etc allow for high performance data ingestion and processing
  • Ideally being used for ELT type data integration, with push down optimisation where complex logic is processed using the power of Teradata appliance than the ETL server
Anonymous | TrustRadius Reviewer

Cons

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

Teradata Enterprise Data Warehousing

  • Expensive (why go with it when you have similar setup thru big data technologies like Hadoop?)
  • No concept of Unstructured Data; everything is inline to what Oracle provides.
Bharadwaj (Brad) Chivukula | TrustRadius Reviewer

Alternatives Considered

Teradata Data Warehouse Appliance

No answers on this topic

Teradata Enterprise Data Warehousing

Teradata is the leader in Data Warehousing bar none based on independent experts like Gartner and our experience aligns with this.
Anonymous | TrustRadius Reviewer

Return on Investment

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

Teradata Enterprise Data Warehousing

  • Excellent performance on reports
  • We were able to report on all the different large amounts of data across departments with the help of Teradata Enterprise Data Warehousing
Hemant Prabhakar Patil | TrustRadius Reviewer

Pricing Details

Teradata Data Warehouse Appliance

General

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

Teradata Enterprise Data Warehousing

General

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

Add comparison