Try our new research platform with insights from 80,000+ expert users
Test Engineer at cigniti
Real User
Easy to set up and reliable with good performance capabilities
Pros and Cons
  • "I've never had any issues with scalability."
  • "Apart from Control-M, it would be nice if it could integrate with other tools."

What is our primary use case?

We primarily use the solution for the EDW. 

What is most valuable?

The performance is the key item we appreciate. We're able to easily trigger jobs and we have access to integrations for running jobs. It's easy to use for the most part, which is why I really like it.

It's stable and reliable.

I've never had any issues with scalability.

The initial setup is pretty simple to set up. 

What needs improvement?

Apart from Control-M, it would be nice if it could integrate with other tools. Specifically, with respect to the integrations with the automation tools, if that can be increased, and if the tester could be able to test more automation scripts in a better way it would help. The efficiency could always be increased.

Occasionally, at the outset of the implementation process, we struggled a little bit.

For how long have I used the solution?

I've only used the solution for a few months. It hasn't been a year yet. It hasn't been that long. 

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

What do I think about the stability of the solution?

The stability has been good so far. It's reliable and the performance is good. there are no bugs or glitches and it doesn't crash or freeze. 

What do I think about the scalability of the solution?

The solution seems to be scalable. I've never run into any issues with sizing. It's good.

I cannot recall the exact number of users that are on this solution currently. 

How are customer service and support?

Technical support is quite good. We used them once or twice and, as I recall, their response was always very quick. We are quite satisfied with the level of service they offer. 

How was the initial setup?

For the most part, the initial setup is good. We found it pretty straightforward. That said, sometimes, in the beginning, we struggle. 

For us, the deployment took around two hours. It didn't take too long. 

We had about ten members on the technical team that handled deployment and maintenance. 

What about the implementation team?

We are able to handle the initial setup ourselves. As long there are not some prerequisites or system issues, then it's possible for us to handle everything.

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

I don't have any direct details about the licensing or pricing of the solution. 

What other advice do I have?

I'm not sure of which version of the solution we're using. It might be a previous version. 

I'd recommend the solution to other users and organizations. 

I would rate the solution nine out of ten. We are quite pleased with its general capabilities. 

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
Anton Van Heerden - PeerSpot reviewer
Managing Director at DNA Payroll Outsourcing
Reseller
Superior solution for optimizing data
Pros and Cons
  • "The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
  • "Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."

What is most valuable?

The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers.

What needs improvement?

An area that needs improvement is the cloud-based version of the solution because it's designed for on-prem and then transferred to the cloud version. Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly. In the next release, I would like Teradata to be cloud-agnostic in order to not limit customers' choices.

For how long have I used the solution?

I've been using this solution for fifteen to twenty years.

What do I think about the stability of the solution?

Teradata is superior, stable, and has no problems.

What do I think about the scalability of the solution?

Teradata is easily scalable. 

How was the initial setup?

The setup is complex and requires specialized people for implementation.

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

The cost of running Teradata is quite high, but you get a good return on investment.

Which other solutions did I evaluate?

I've also evaluated Snowflake, which allows you to expose your data to multiple sources for monitoring without additional work.

What other advice do I have?

For the on-prem solution, there isn't really anyone who can compete with Teradata. I would rate it as eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
PeerSpot user
Buyer's Guide
Teradata
April 2025
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
851,823 professionals have used our research since 2012.
Big data administrator at a comms service provider with 1,001-5,000 employees
Real User
Fast response times, easy to use, and scalable
Pros and Cons
  • "Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
  • "The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."

What is our primary use case?

We use Teradata in our data warehouse and we extract data. We have a data department that uses many tools for data extractions.

What is most valuable?

Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available. 

What needs improvement?

Teradata could improve by providing better training. For example, Oracle provides good overall training. It is not easy to find information on the internet.

For how long have I used the solution?

I have been using Teradata for approximately eight years.

What do I think about the stability of the solution?

The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues.

What do I think about the scalability of the solution?

Teradata is scalable. We have two large servers and if we need to add new servers it can be done. Additionally, adding hard drive space or more performance is not a problem.

We have approximately 15 users using this solution in my organization.

How are customer service and support?

The technical support is good but they could improve because sometimes they can take two weeks to resolve issues.

How was the initial setup?

The implementation took approximately one month.

What about the implementation team?

We did the implementation of Teradata using their support.

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

The price of the solution could be reduced, it is expensive.

What other advice do I have?

I would recommend this solution to others.

I rate Teradata a nine out of ten.

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
Solution Sales and Lead Information at TechAccess Asia Distribution
Real User
Good performance, flexible, easy to tune queries, and scales well
Pros and Cons
  • "The flexibility in design is very good."
  • "Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."

What is our primary use case?

My current use case is an analytical system for an oil and gas company. They have a data lake and they are getting their data from different IoTs and different SAP systems. They wanted to have some feedback about their system and check on their production.

The IoT center's data was actually our use case, then how we can use that data to prevent disaster from happening. Previously, this work was all done manually. If there is a leak in the pipes then it is a large area to search because there are hundreds of kilometers that have been run.

To tackle this problem, they use IoT sensor data. It helps them to understand how the flow is working at a specific point in time, what happens when they're drilling the oil and other types of data. To complete the analysis, we use an analytical system or a Teradata Azure system that we designed.

The ECL was designed in a manner where we were doing the transformation on Hadoop. It is more like a balanced system where you use Hadoop for what it is good for, and where you use Teradata for its purpose.

I have worked in several different environments. The largest Teradata implementation on Azure was done by me. Right now, I'm working with AWS but previously, I have implemented both on-premises and hybrid deployments.

What is most valuable?

Performance-wise, Teradata beats everything.

The flexibility in design is very good.

When you want to tune it, it is very easy to do. I have worked a lot as a DB and I know that when there is a query that is stuck for hours, and you want to tune it, the task is quite easy. You can use the indexes and architecture, and exploit the power of Teradata.

What needs improvement?

There are lots of improvements that Teradata is working on and many that have already been done. However, recently I was in a session with people who are working on the data sciences side of the business. The data science group is not using the Teradata modeling features. Rather, they are using third-party tools for the prediction and forecasting models that they are building. Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve.

In my experience with Teradata, I have seen their sales strategy and that needs to change. As an organization marketing a product, they need to be cloud-focused instead of the on-premises thinking that they currently have.

There are a few things where you are totally dependent on the customer service and support from Teradata. This is an area where they really need to improve a bit, especially when you're talking about cloud service integration. Depending on the environment you may need to contact the AWS team, or the Azure team, or the GCP team, or the Teradata team. In all of these environments, improvements need to be made.

For how long have I used the solution?

I have been working with Teradata for more than a decade, probably close to 11 years. I have been in the industry for approximately 18 years.

What do I think about the stability of the solution?

We are satisfied with the stability.

What do I think about the scalability of the solution?

It is quite easy to scale. For a cloud-based deployment, it's even simpler now.

Previously, it was easy if we just wanted to add power but there was an impediment when you had to add a node. Similarly, it was difficult when you had to shift to the newer nodes. Now, however, with the cloud, it's easy to do.

How was the initial setup?

For the on-premises deployment, a lot of people consider the initial setup to be difficult. Keep in mind, however, that Teradata is a million-dollar product, so they set it up for you.

For a cloud-based deployment, it is now pretty simple to deploy.

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

The price of Teradata is on the higher side, and I think that it where they lose out on some of their business. The price should be reduced to make it more competitive.

Which other solutions did I evaluate?

One of my clients recently tried to switch solutions but they have rolled back to Teradata. The same thing happened with another company that I know of in Pakistan, where they tried working with an IBM product.

What other advice do I have?

My advice for anybody who is implementing this product is that they really need to hire the right people. Get people who actually have worked on Teradata to guide them.

You can buy Teradata and you can get it up and running, but until you hire a few good people, you are not going to get the full benefits from it. These people are not resources that you would ask Teradata to provide you. Rather, you can hire them from the market.

The important part is that you need to have people who have good experience with Teradata because they can truly exploit its power for you.

Overall, this is a good product. It is close to the best but I cannot rate it perfectly because of the price.

I would rate this solution a nine out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Sr. Data Management Specialist at a computer software company with 1,001-5,000 employees
Real User
Highly scalable and fast with historical data
Pros and Cons
  • "Teradata's best feature is its speed with historical data."
  • "Teradata's UI could be improved."

What is our primary use case?

I mainly used Teradata as an EDW and for customizing and integrating CLDM, applying aggregation in the database, and analysis.

What is most valuable?

Teradata's best feature is its speed with historical data.

What needs improvement?

Teradata's UI could be improved.

For how long have I used the solution?

I've been using Teradata for about four years.

What do I think about the stability of the solution?

Teradata's stability is good.

What do I think about the scalability of the solution?

Teradata's scalability is one of its best features.

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

Teradata's licensing is on the expensive side.

What other advice do I have?

I would rate Teradata nine out of ten.

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
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
PeerSpot user
Head of Information management with 1,001-5,000 employees
Vendor
Top 20
Working with Teradata, Cognos and Informatica is a positive combination of good tools but implementation can be complex

I have been using Teradata and Cognos for the past 8 years and Informatica ETL tool for 1 year. I have found that the analytical CRM functionalities from Teradata using Teradata database has been the most valuable feature of this product. It has helped the way my organization functions in that we build a data warehouse to have a single version of the truth with all the needed aggregations, and all the analytical reports are now using this database which leads to consistent data. Additionally, all the analytical reports are now generated using Cognos BI tool which is very powerful and the business powerful users can build their own analytical reports.

My company had previously used a different solution before Informatica and we are still in the transition phase, ETL from data stage. Before choosing this product we evaluated Informatica, Oracle ODI and our current ETL data stage. We switched because Informatica is better in terms of tool, support, and at the same time, because we bought Informatica data quality tool for the data governance dept after vendor selection process. During the deployment of Informatica ETL there were some performance issues but they were solved.

Regarding the level of technical support, I would say that for Teradata it is average, for Cognos and Informatica it is good. The initial set up for Teradata was a little bit complex due to some specific applications used in my country while for Cognos, it was straightforward. For Informatica, the initial set up was a little bit complex due to the different environment where the tool has to be implemented. We always implemented in-house but in collaboration with a vendor team and found that their level of expertise was good. My advice to others concerning Teradata, it is a powerful product to build a data warehouse in the organization, but take into consideration that Teradata is using its own hardware to have a good performance. I have found that Informatica’s data quality is the best tool to profile, clean and monitor the data.

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: April 2025
Buyer's Guide
Download our free Teradata Report and get advice and tips from experienced pros sharing their opinions.