Teradata: great for data storage
October 12, 2021
Teradata is used throughout the entire company. It is used to store and query a vast amount of data. We store almost all of our …
Teradata Data Warehouse Appliance 2850
Teradata Data Warehouse Appliance 2850
Overview
Recent Reviews
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Teradata Data Warehouse Appliance 2850, and make your voice heard!
Pricing
View all pricingN/A
Unavailable
What is Teradata Data Warehouse Appliance 2850?
Teradata Data Warehouse Appliance, most recent model 2850, is a fully-integrated system purpose built for data warehousing. The appliance features Teradata Database with a Teradata hardware platform with dual Intel Xeon 18-core processors, up to 12TB of memory in a single cabinet, SUSE Linux…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
2 people want pricing too
Alternatives Pricing
What is Google BigQuery?
Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
What is Amazon Redshift?
Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.
Features Scorecard
No scorecards have been submitted for this product yet.Start a Scorecard.
Product Details
What is Teradata Data Warehouse Appliance 2850?
Teradata Data Warehouse Appliance, most recent model 2850, is a fully-integrated system purpose built for data warehousing. The appliance features Teradata Database with a Teradata hardware platform with dual Intel Xeon 18-core processors, up to 12TB of memory in a single cabinet, SUSE Linux operating system, and enterprise-class storage, preinstalled into a power-efficient unit.
Teradata Data Warehouse Appliance 2850 Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
View all alternatives
Reviews and Ratings
(20)
Reviews
(1-2 of 2)- Popular Filters
Companies can't remove reviews or game the system. Here's why
October 12, 2021
Teradata: great for data storage
Teradata is used throughout the entire company. It is used to store and query a vast amount of data. We store almost all of our membership, claims, revenue, etc. in this application. Many reports utilize this application to easily compile data which can then be used in other applications to properly display and report findings
- Stores large amount of data.
- The syntax used is easy to learn.
- Makes it easy to import and export your own data.
- Sometimes it isn’t clear the reason an error will occur in the query. More detailed responses would be helpful
- It can be slow at times when pulling large data amounts
- Sometimes spool space will run out when trying to run certain queries
December 16, 2015
Perfect for large corporations
Our company uses Teradata to merge various departments across the whole organization. With data coming from many source systems, we are able to use Teradata to enhance our Business Intelligence practices and provide our executives with next-day reporting. Merged data includes sales, customer care, product inventory, and field technician performance.
- 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.
- 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.