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.
Technical Manager at a energy/utilities company with 51-200 employees
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?
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.
SystemAnalyst
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.
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
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.
Senior Consultant at a tech services company with 51-200 employees
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.
Auditor Federal de Finanças e Controle at CGU
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.
Director at a tech services company with 11-50 employees
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.
Buyer's Guide
Download our free Teradata Report and get advice and tips from experienced pros
sharing their opinions.
Updated: March 2024
Popular Comparisons
Azure Data Factory
SQL Server
Snowflake
Oracle Database
MySQL
MariaDB
Microsoft Azure Synapse Analytics
SAP HANA
Oracle Exadata
Amazon Redshift
IBM Db2 Database
Vertica
Amazon Aurora
BigQuery
Apache Hadoop
Buyer's Guide
Download our free Teradata Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which data catalog can provide support for BI data sources such as SAP BO and Tableau?
- Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
- Comparing Teradata and Oracle Database, which product do you think is better and why?
- Which companies use Teradata and who is it most suitable for?
- Is Teradata a difficult solution to work with?
- What are the main differences between Oracle Exadata and Teradata?
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?
- Is a data warehouse the best option to consolidate data into one location?