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.

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

    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 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: I am a real user, and this review is based on my own experience and opinions.
    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: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Teradata
    March 2024
    Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
    768,924 professionals have used our research since 2012.
    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: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user1210803 - PeerSpot reviewer
    Senior Consultant at a tech services company with 51-200 employees
    Consultant
    It is stable but it should be more cloud-friendly and scalability is poor
    Pros and Cons
    • "It is a stable program."
    • "An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."

    What is our primary use case?

    We are only consultants, so we don't use the program ourselves. 

    What is most valuable?

    Our customers are very impressed by Teradata's speed, because it's massively parallel processed. So you can get a great volume of data through quickly.

    What needs improvement?

    What really needs to improve, is their general cloud services. That is their biggest downfall at the moment. 

    What do I think about the stability of the solution?

    Teradata is a really stable program.

    What do I think about the scalability of the solution?

    The scalability of Teradata is extremely poor, unfortunately.

    How are customer service and technical support?

    Because we are only consultants, we never use the technical support. Only our clients do.

    What other advice do I have?

    On a scale from one to ten, I will rate Teradata a seven. An additional feature I would like to see included in the next release is that it needs to be more cloud-friendly. That's the one thing they're going to lose customers over, so that needs to improve. I know they're working on it, but they need to do it quicker. 

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user1076391 - PeerSpot reviewer
    Auditor Federal de Finanças e Controle at CGU
    Real User
    Scalable solution that takes advantage of massive parallel processing
    Pros and Cons
    • "The feature that we find most valuable is its ability to perform Massive Parallel Processing."
    • "I would like to see an improved Knowledge Base on the web."

    What is our primary use case?

    Our primary use case for this solution is the Transparency Portal of the Brazilian Government. Teradata provides the database infrastructure for this analytical site that is able to create an online BI experience that provides details on how the Brazilian government spends public money.

    How has it helped my organization?

    Teradata has allowed us to provide an online BI solution that no other player was able to do.

    What is most valuable?

    The feature that we find most valuable is its ability to perform Massive Parallel Processing.

    What needs improvement?

    I would like to see an improved Knowledge Base on the web.

    For how long have I used the solution?

    Three to five years.

    What do I think about the scalability of the solution?

    There are two million queries per day and an average of eight hundred concurrent users during working hours. 

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    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: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Download our free Teradata Report and get advice and tips from experienced pros sharing their opinions.
    Updated: March 2024
    Buyer's Guide
    Download our free Teradata Report and get advice and tips from experienced pros sharing their opinions.