Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Operations Manager at a tech services company with 10,001+ employees
Real User
​We enjoy the FastLoad, TPump, and MultiLoad features
Pros and Cons
  • "​We really enjoy the FastLoad, TPump, and MultiLoad features.​"
  • "Things have started moving faster in my company, such as data retrieval happens more quickly.​"
  • "​I think the UI is not there yet. It could be improved by being more user-friendly.​"

What is our primary use case?

Its primary use is a superfast database.

How has it helped my organization?

Things have started moving faster in my company, such as data retrieval happens more quickly.

What is most valuable?

We really enjoy the FastLoad, TPump, and MultiLoad features.

What needs improvement?

I think the UI is not there yet. It could be improved by being more user-friendly.

Buyer's Guide
Teradata
May 2025
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.

For how long have I used the solution?

One to three years.

Which other solutions did I evaluate?

It is faster than Oracle, and that is what we need.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Manager BI Development at a comms service provider with 1,001-5,000 employees
Real User
Performance when processing terabytes of data, and the scalability are key for us
Pros and Cons
  • "The key advantages are Performance when processing Terabytes of data and scalability."
  • "The following could be better: licensing, architecture openness, integration with other tools."

How has it helped my organization?

We have improved our daily/monthly reporting, campaign management, and behavior analysis.

What is most valuable?

Performance when processing terabytes of data.

What needs improvement?

  • Licensing
  • Architecture openness
  • Integration with other tools

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

No stability issues.

What do I think about the scalability of the solution?

Teradata's key strength is it's scalability.

How are customer service and technical support?

Excellent. The support covers all aspects of hardware/software usage.

Which solution did I use previously and why did I switch?

Oracle's performance in processing large amounts of data is very poor and we had to choose new technology.

How was the initial setup?

Complex. The process requires multiple meetings and all teams working together.

What's my experience with pricing, setup cost, and licensing?

Teradata is expensive but gives value for money, especially if you don't want to move your data to the cloud.

Which other solutions did I evaluate?

IBM, Oracle.

What other advice do I have?

If you have purchased the hardware/software, focus on architecture and the design of data layers.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Teradata
May 2025
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
it_user6057 - PeerSpot reviewer
Senior Java Developer at EPAM Systems at a tech vendor with 10,001+ employees
Vendor
Improved the performance of our ETL procedures and reporting
Pros and Cons
  • "Improved performance of ETL procedures, reporting."
  • "We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
  • "GUI of administrative tools is really outdated."

What is our primary use case?

How has it helped my organization?

Improved performance of ETL procedures, reporting. Decreased efforts, time, and number of staff supporting DWH.

What is most valuable?

  • Scalability
  • Functionality
  • Performance

What needs improvement?

GUI of administrative tools is really outdated.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

Nothing major, as far as I can recall.

What do I think about the scalability of the solution?

No issues, scalability is a key feature of Teradata.

How are customer service and technical support?

Support is on par with other vendors.

Which solution did I use previously and why did I switch?

We used Oracle. Scalability and performance were the reasons we decided to try Teradata.

How was the initial setup?

It was easy, the whole job was done by Teradata.

What's my experience with pricing, setup cost, and licensing?

It is still a very expensive solution. While I very much like the pure technological supremacy of the software itself, I believe Teradata as a company needs to become more affordable. They are already losing the market to more flexible or cheaper competitors.

Which other solutions did I evaluate?

We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server.

What other advice do I have?

Go with the Enterprise series and don't waste time and money on 25xx. Sooner or later you will migrate anyway, so don't even start with departmental solutions.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Solution Lead at a tech company with 10,001+ employees
Real User
This solution has proven technology with significant advantages in some key areas, and greater depth and experience in providing industry knowledge and solutions.
Pros and Cons
  • "Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
  • "There is some improvement required on OLTP level and some analytical function is missing."

What is most valuable?

  1. "Parallel Everything” design and smart Teradata Optimizer enables fast query execution across platforms.
  2. Fully parallel MPP “shared nothing” architecture scales linearly across data, users, and applications, providing consistent and predictable performance and growth.
  3. In-database data mining, virtual OLAP/cubes, geospatial and temporal analytics, custom and embedded services in an extensible open parallel framework, drive efficient and differentiated business insight.
  4. Workload management options by user, application, time of day, and CPU exceptions.
  5. Teradata Columnar/Teradata Temporal.
  6. Compress on cold and intelligent multi-temperature data management.
  7. Enhanced security.
  8. Customer driven innovation in application migration and temporal.
  9. Intelligent Scan Elimination.

How has it helped my organization?

Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services.

Teradata has proven technology with significant advantages in some key areas, and greater depth and experience in providing industry knowledge and solutions.

What needs improvement?

There is some improvement required on OLTP level and some analytical function is missing.

For how long have I used the solution?

I've used it for almost five years.

What was my experience with deployment of the solution?

Did not encounter any issues during deployment.

What do I think about the stability of the solution?

No stability issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

They deliver the products to customers faster and with greater accuracy, i.e. within the agreed-upon due date .

Technical Support:

Teradata already had a excellent customer satisfaction and the rating would be eight out of 10.

Which solution did I use previously and why did I switch?

No other solution used.

How was the initial setup?

Teradata setup is straightforward and simple.

What about the implementation team?

The implementation done mainly with the in-house teams and also some support of vendor team.

What was our ROI?

100%.

What's my experience with pricing, setup cost, and licensing?

Teradata is easy-to-use for data warehouse and BI application. It's extremely fast and also advanced analytics work can be done in a very flexible manner.

Which other solutions did I evaluate?

We also looked at Oracle Exadata.

What other advice do I have?

Teradata provides the analytical performance we need through its “parallel everything” design and industry leading optimizer to intelligently process all types of analytical and business intelligence queries.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user718455 - PeerSpot reviewer
Business Analyst / Data Engineer
Vendor
A Very Stable Product With A 99.9% Up Time
Pros and Cons
  • "It is a solid database a lot of different tools to move data."

    What is most valuable?

    It is a solid database a lot of different tools to move data.

    How has it helped my organization?

    Basically, Teradata has allowed the multiple businesses that I have consulted for to build and store their Data Warehouse related data efficiently. It also serves up the data quickly, if tuned and organized properly.

    What needs improvement?

    Cost, but Teradata is currently making improvements in this area.

    For how long have I used the solution?

    Nine years.

    What do I think about the stability of the solution?

    Most of the organizations that I have consulted with have a 99.9% up time. The product is very stable.

    What do I think about the scalability of the solution?

    Teradata is great as far as scalability once you have the product. You can move space on the fly. However, adding additional space once your disks are full in the past was expensive. I believe that they are addressing this issue by allowing you to buy only the hardware (disk space, node, amps) you need and not having to perform a total upgrade.

    How are customer service and technical support?

    This depends on your service agreement. If you have tier 1 support, you are guaranteed to have full support at any moment.

    Which solution did I use previously and why did I switch?

    I was not in a position as a consultant to make solution decisions.

    How was the initial setup?

    I have never setup a Teradata box personally.

    What's my experience with pricing, setup cost, and licensing?

    I am not in a position to share licensing costs.

    Which other solutions did I evaluate?

    I was not in a position as a consultant to make software solution decisions.

    What other advice do I have?

    Get educated about the product.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    it_user723012 - PeerSpot reviewer
    it_user723012Department Head - BI Strategy and Data Governance -Strategy Direction at a comms service provider with 1,001-5,000 employees
    Real User

    Probably it's the case of Teradata in other regions here in the middle east they are very weak in services and try to over sale by imposing hardware swap instead supporting by adding disk or nodes. And the plan is now to swap to software based solution from another vendor based on commodity servers.

    it_user692277 - PeerSpot reviewer
    Teradata Consultant at a tech services company with 10,001+ employees
    Consultant
    QueryGrid has multiple new features i.e data migration, extraction, tool loading, other utilities.​

    What is most valuable?

    Stats, QueryGrid Autostats with collecting stats automatically with the threshold values assigned, QueryGrid has multiple new features i.e data migration, extraction, tool loading, other utilities.

    How has it helped my organization?

    Business, Analytics, Hybrid.

    What needs improvement?

    It should be compatible and free on CLOUD/ AWS. Currently many DB's on AWS are free , Teradata is also on Amazon Web Services, but its charged and no documentation available to practice those LABS .

    For how long have I used the solution?

    5 years.

    What was my experience with deployment of the solution?

    No issues.

    What do I think about the stability of the solution?

    No issues.

    What do I think about the scalability of the solution?

    No issues.

    How are customer service and technical support?

    8/10

    Which solution did I use previously and why did I switch?

    Larger data warehouse / reporting and compatibility to analytics.

    How was the initial setup?

    It was straightforward.

    What other advice do I have?

    It architects the databases well. Right from data modelling, the correction appliance to be chosen, the queries hitting the system, strategic, tactical etc, and that business knowledge should be easy to understand to end developers.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    PeerSpot user
    Professional Services Senior Consultant at a tech services company
    Consultant
    For large EDWH solutions, Teradata is the best.
    Pros and Cons
    • "I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
    • "The cloud is the new challenge and the new opportunity."

    What is most valuable?

    I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable.

    How has it helped my organization?

    Vodafone Spain tried to migrate a very populated data mart platform from Sybase IQ to Oracle. Unfortunately, they failed at this job. But more than 20 Sybase IQ database engines (with their respective licence, support costs, etc.) were successfully integrated into one single Teradata ecosystem.

    What needs improvement?

    The cloud is the new challenge and the new opportunity.

    For how long have I used the solution?

    I have designed Teradata EDWH solutions for more than 16 years.

    What do I think about the stability of the solution?

    I did not encounter any issues at all.

    What do I think about the scalability of the solution?

    I did not encounter any issues at all.

    How are customer service and technical support?

    I would rate the level of technical support 10/10.

    Which solution did I use previously and why did I switch?

    I have previous experience with Oracle/Informix/Sybase. For large EDWH solutions, Teradata is the best. Oracle solutions are multipurpose oriented and Td is EDWH oriented from the beginning.

    What's my experience with pricing, setup cost, and licensing?

    The initial cost may seem high, but the TCO is low.

    Which other solutions did I evaluate?

    I mainly evaluated Oracle.

    What other advice do I have?

    I recommend starting with a clean and normalized business model that is capable of addressing business questions. Teratada (and its consultants) will do the rest.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Teradatae473 - PeerSpot reviewer
    Teradata DBA|Data Engineer Specialist|Hadoop Admin at a tech services company with 10,001+ employees
    Real User
    The product is more helpful in historical analysis and customer behavior trends.

    What is most valuable?

    Good data warehousing solution. Workload Management (TASM) and Viewpoint.

    How has it helped my organization?

    As it is a data warehousing solution, many reporting sessions and users can run simultaneously without much performance degradation. The product is more helpful in historical analysis and customer behavior trends for the organisation.

    What needs improvement?

    Query Log maintenance should be free in all versions and should be made easy.

    For how long have I used the solution?

    Seven years.

    What do I think about the stability of the solution?

    Regarding stability, Teradata comes bundled with hardware and software. There are fewer bugs in the software and most of the hardware failure mechanisms are addressed at the hardware level, so users experience less downtime.

    How is customer service and technical support?

    Average.

    How was the initial setup?

    Complex. My experience was the Teradata Solution Architects were less friendly and hid information and charged for simple things.

    What's my experience with pricing, setup cost, and licensing?

    Pricing is bit on higher side. They have come up with a licencing model recently.

    What other advice do I have?

    It is a good solution.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Buyer's Guide
    Download our free Teradata Report and get advice and tips from experienced pros sharing their opinions.
    Updated: May 2025
    Buyer's Guide
    Download our free Teradata Report and get advice and tips from experienced pros sharing their opinions.