Try our new research platform with insights from 80,000+ expert users
Director8158 - PeerSpot reviewer
Director of Data at a leisure / travel company with 1,001-5,000 employees
Real User
It helps us with connectivity and making sure the data is secure
Pros and Cons
  • "It is quick, secure, and has less hassles because we don't have to involve our networking team, infrastructure, etc. It is very easy to deploy and make market ready."
  • "I would like more security and speed."

What is our primary use case?

We have all our workloads on AWS.

How has it helped my organization?

Having Teradata in AWS:

  • Helps us with connectivity.
  • Making sure the data is secure.
  • Reduces the hops.
  • Helps us more with real-time data.

We had few reports which were taking more than 45 minutes. Then, with Teradata, we received results within minutes, and a few under a minute. We thought that something went wrong, and we hadn't done the work properly, but we saw the exact same results on both. So, our end users were pretty happy.

What is most valuable?

It is quick, secure, and has less hassles because we don't have to involve our networking team, infrastructure, etc. It is very easy to deploy and make market ready.

What needs improvement?

Teradata wants to come out of the hardware business and to run its own cloud on other public clouds. I think that is a great way to go. However, there are challenges to doing this. There are multiple layers of security and caching. E.g., if you have a lot of compute or a caching that will offload a lot of compute activity because it's already there, it will save its cycles for something which needs to be done. This way, you are offloading your compute, so you can go with a lesser capacity than a higher capacity. That is what this appliance does.  If they are moving off of the appliance, I am curious to see if their software will withstand the change, or will Teradata still run but need a bigger box?

I would like more security and speed. These days, everyone is not just moving to cloud, but they are moving to clout. In a multi-cloud environment, you have to be cognizant of data transfer, bandwidth, and egress charges, not just from a performance and scalability point of view, but also how to keep costs low.

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.

What do I think about the stability of the solution?

We haven't had any outages in one and a half years. That is a good statement.

What do I think about the scalability of the solution?

I have not heard anyone complain about performance.

How are customer service and support?

The technical support is pretty good. The response rate is good.

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

We had a bunch of legacy warehouses, which we wanted to consolidate, as well as stay up-to-date with warehousing options. This is why we moved into Teradata.

How was the initial setup?

The integration and configuration were seamless for us.

We have multiple sources of data, so Teradata has a lot of connectors which pulls all our data from different workloads. The integration works really well.

What about the implementation team?

We had help with the integration and configuration.

What was our ROI?

When your customer is happy, dollars and cents sort of blur. Our return on investment would be customer satisfaction, which I think is priceless.

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

We had a lot of parties involved when purchasing from the AWS Marketplace. They are very flexible and aggressive in trying to close the deal. They are good at what they have to offer and listening to the customer. It's a two-way street.

In this day and age, we want to get things done quickly. So, we go to the AWS Marketplace.
Also, we have a consistent experience with Teradata usage on its cloud, so we already know the product.

For what Teradata has to offer, their price is comparable to its competitors.

Which other solutions did I evaluate?

We evaluated Redis and Teredata, doing PoCs with both. We had more support from Teradata to start with, and we were new to both. We were not in a situation to tell which one was good, because both were new to us. We just had more support from Teradata to help us see the results on what we are looking for.

What other advice do I have?

Do your homework before you make a decision. Everyone is different; every shop is different. That is what makes it fun to be in IT.

When you look for a solution, you will uncover many advantages. All those hidden things which are not clear initially when you do a cost analysis. A cost analysis is something that you have to do from the get-go, but it also has to be an ongoing process. Your workloads change, requirements change, everything changes, so it has to be a constant feedback.

We have used both the on-premise and AWS versions.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Associate Consultant at BT5 Business & Technology 5 Consulting
Consultant
It handles large amounts of information with a linear performance increase
Pros and Cons
  • "It handles large amounts of information with a linear performance increase, in relation to a HW investment."
  • "It has a solid set of tools and consulting services."
  • "It needs a teaching web site with more training on third-party tools used for BI."

What is our primary use case?

Our primary use case is for retail and customer behavior modeling. We handle a billion records from different sources to create a consolidated feed for KXEN analysis and customer behavior modeling.

How has it helped my organization?

It has allowed our organization, a retail company, to focus on timely marketing campaigns for the proper customers.

What is most valuable?

It handles large amounts of information with a linear performance increase, in relation to a HW investment. It has a solid set of tools and consulting services.

What needs improvement?

  • A more transparent integration with Aster solutions.
  • An even deeper focus in data sciences.
  • A teaching web site with more training on third-party tools used for BI (data sciences).

For how long have I used the solution?

More than five years.
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_user845499 - PeerSpot reviewer
Manager Performance Systems at Telstra
Real User
Massive parallel processing ability to do large amounts of concurrent querying
Pros and Cons
  • "It has massive parallel processing ability to do large amounts of concurrent querying."
  • "It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."

    What is our primary use case?

    We use it for enterprise data warehouse (EDW) with on-premise hardware. The company uses EDW for most MIS functions.

    How has it helped my organization?

    It has massive parallel processing ability to do large amounts of concurrent querying. It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs.

    What is most valuable?

    Speed of complex queries and the ability to schedule give business users time to analyse data rather than waiting for queries to run.

    What needs improvement?

    We are using an older version at the moment. We are looking for a more flexible cost model for the next version that we use, whether it be cloud or on-premise.

    For how long have I used the solution?

    More than five years.
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    PeerSpot user
    Technical Manager at a energy/utilities company with 51-200 employees
    Real User
    High transaction processes, as well as the reporting system, need improvement
    Pros and Cons
      • "We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
      • "There is a need to improve performance in high transaction processes, as well as the reporting system."

      What is our primary use case?

      We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata.

      How has it helped my organization?

      It didn't improve the way our organization functions.

      What is most valuable?

      None.

      What needs improvement?

      There is a need to improve performance in high transaction processes, as well as the reporting system.

      For how long have I used the solution?

      Less than one year.

      What do I think about the stability of the solution?

      No issues with stability.

      What do I think about the scalability of the solution?

      No issues with scalability.

      How are customer service and technical support?

      I would rate tech support at eight out of 10.

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

      Yes, we already had SAP IQ and were using it. We didn’t switch. We tried but it failed.

      How was the initial setup?

      Very complex.

      What other advice do I have?

      I rate Teradata two out of 10. At first, support was very good, but during and after they ended their operation in Turkey it was very bad. We had some agreements and they gave us some promises but...

      We bought it three years ago but we couldn't use it in production. We have SAP IQ data warehouse now and I don't have a major problem. I would recommend SAP IQ for data warehouse.

      If you are going to buy Teradata, you have to make a very solid contract with them.

      Disclosure: My company does not have a business relationship with this vendor other than being a customer.
      PeerSpot user
      PeerSpot user
      Analyst at a tech services company with 10,001+ employees
      Real User
      Cuts time to process huge amounts of data with efficient analytical queries
      Pros and Cons
      • "Cuts time to process huge amounts of data with efficient analytical queries."
      • "A conventional and easily defined way to build a data warehouse or a layer of data marts."
      • "Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
      • "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)."
      • "Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."

      What is our primary use case?

      As a contractor for various companies working in various industries, we usually find Teradata in financial organizations. It is often being used for relational data storage for huge data warehouses (usually built on Inmon principles) or as storage for building analytical data marts. Teradata is positioned as a high-performance solution for heavy analytical queries and, in fact, it is. Moreover, Teradata is typically supplied with the whole ecosystem of its tools (like Viewpoint), but I have not extensively used them.

      How has it helped my organization?

      • Cuts time to process huge amounts of data with analytical queries
      • A conventional and easily defined way to build a data warehouse or a layer of data marts
      • Better development time - Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools

      What is most valuable?

      Efficiency of running analytical queries. Teradata was mainly invented for that purpose and it really does it well. We were able to migrate the code from SAS analytical platforms to pure Teradata and got an order of magnitude of performance growth (taking into account that the hardware was similar).

      What needs improvement?

      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).

      Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect.

      For how long have I used the solution?

      Three to five years.

      What do I think about the stability of the solution?

      We have not experienced any stability issues.

      What do I think about the scalability of the solution?

      No. Teradata is positioned as a rather scalable system, and we have not seen any issues with it.

      How are customer service and technical support?

      I was not impressed by tech support. We made several requests regarding performance issues we had with our applications but did not get helpful answers.

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

      It is hard to say what our clients had been using before. It is safe to say that this was their first option for analytical data warehouse implementation.

      How was the initial setup?

      I cannot say for sure. We have not taken part in deployment activities. As it is an appliance, I expect it is a bit complex.

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

      Price is quite high, so if it is really possible to use other solutions (e.g. you do not have strict requirements for performance and huge data volumes), it might be better to look at alternatives from the RDBMS world.

      Which other solutions did I evaluate?

      Usual alternatives in the same segment for our clients are Oracle Exadata, SAP HANA, and Hadoop.

      What other advice do I have?

      I rate it an eight out of 10. It is definitely the best RDBMS I have ever worked with, in the sense of building a data warehouse. It is fast, and easy to use in terms of writing queries. However, you have to understand the specifics of the data storage and its technical architecture, which is not typical for an RDBMS.

      In terms of advice, I would suggest your provide training for your personnel, because it is rather important to understand the technical specifics of Teradata to create efficient solutions with it. Other RDBMS's usually requires knowledge  of generic theory, but that will not work with Teradata.

      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
      PeerSpot user
      it_user142503 - PeerSpot reviewer
      SystemAnalyst
      Vendor
      Enables auto-partitioning and indexing, and resource allocation on the fly
      Pros and Cons
      • "Auto-partitioning and indexing, and resource allocation on the fly are key features."
      • "Needs compatibility with more Big Data platforms."

      What is our primary use case?

      Business intelligence and data warehousing solutions for our client.

      What is most valuable?

      Auto-partitioning and indexing, and resource allocation on the fly.

      What needs improvement?

      Compatibility with more Big Data platforms.

      For how long have I used the solution?

      More than five years.

      What other advice do I have?

      I rate Teradata at eight out of 10. It provides high performance.

      Disclosure: My company does not have a business relationship with this vendor other than being a customer.
      PeerSpot user
      PeerSpot user
      Director at a tech services company with 11-50 employees
      Real User
      ​Building a data warehouse with it has helped a lot of our downstream applications to more easily access information
      Pros and Cons
      • "It has reduced a lot of reworking on maintaining indexes, partitions, etc."
      • "​Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
      • "​Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
      • "It would help to make scaling easier with a reduced cost. ​"

      What is our primary use case?

      Building a single truth database (Enterprise Data Warehouse) where all the enterprise data is integrated at one place.

      How has it helped my organization?

      • Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information.
      • It has reduced a lot of reworking on maintaining indexes, partitions, etc. Due to its architecture, the focus has been shifted from not maintaining the database to how we can utilize the data/features.

      What is most valuable?

      Parallel processing features have helped to easily dump any size of data and retrieve data with great performance.

      Features like TPump were helpful for real-time data loads compatible with almost all other APIs/tools in our enterprise.

      Inbuilt architecture reduces admins' efforts.

      What needs improvement?

      • Cost
      • Scalability

      It would help to make scaling easier with a reduced cost.

      For how long have I used the solution?

      More than five years.
      Disclosure: My company does not have a business relationship with this vendor other than being a customer.
      PeerSpot user
      PeerSpot user
      Business Development / Senior Business Analyst at Startup team at a tech services company with 501-1,000 employees
      Real User
      It has increased the speed of reporting
      Pros and Cons
      • "It has increased the speed of reporting."
      • "​Their level of technical support is adequate. It could be better.​"
      • "​The initial setup was complex as we had to rewrite a lot of the code.​"

      What is our primary use case?

      Data mart implementation for the insurance industry.

      How has it helped my organization?

      • Increased the speed of reporting
      • More accurate data scientist answers

      What is most valuable?

      • Shared-nothing architecture
      • Recoverability

      What needs improvement?

      • Cloud implementation
      • User-friendly products

      For how long have I used the solution?

      Three to five years.

      What do I think about the stability of the solution?

      I have not encountered any issues with stability for Teradata solutions.

      What do I think about the scalability of the solution?

      I have not encountered any issues with scalability for Teradata solutions.

      How are customer service and technical support?

      Their level of technical support is adequate. It could be better.

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

      We previously used Oracle, though not Exadata. We switched for better reporting performance.

      How was the initial setup?

      The initial setup was complex as we had to rewrite a lot of the code.

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

      I would advise others to look into migration and setup as a fixed price and incorporate a SaaS option for other Teradata services.

      Which other solutions did I evaluate?

      We evaluated this product versus Oracle Exadata.

      What other advice do I have?

      When looking into implementing this product, pricing is the main issue followed by technical expertise.

      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.