Teradata Reviews

Teradata is used for many use cases, such as clickstream, website support, and manufacturing control.

Teradata has helped our organization accelerate substantially the decision-making that happens.

The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good.

I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement.

I have been using Teradata for approximately 20 years.

The stability of Teradata is outstanding.

Teradata is highly scalable, it is excellent.

We have approximately hundreds of users using this solution.

I have not used support recently, but I have previously.

I previously used SQL Server.

The initial setup of Teradata is complex. The business layers on top of Teradata add to the complexity. The way the business uses Teradata adds to the complexity that the software itself doesn't necessarily have. 

You can do an upgrade for Teradata in a couple of days. Deploying it is not difficult at all, nor is it time-consuming.

I rate the ease of setup for Teradata a one out of five.

The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing.

There are add-ons that you can purchase, such as special features. Teradata likes to sell an industry logical data model that's customized for just about every industry they have clients in. That is an extremely expensive add-on, but it does give you a step up in getting your logical modeling created. They've also done some work towards being able to go from logical to physical in an automated fashion with that ILM.

Teradata is being used on-premise, but we're moving to the cloud and I don't know that we'll retain Teradata further. We might be switching to the Google platform and their native databases.

Make sure that your data volumes are large enough for it and that you follow their standards. The modeling for Teradata is slightly different than anything else out there. Match your primary indexes if you can. These PI-to-PI joins are incredibly fast, even with massive amounts of data. I've worked on Teradata installations in the petabyte range.

I rate Teradata a nine out of ten.

On-premises

We primarily use the solution for data warehousing.

The loading time of the solution is quite good.

What really impressed me is their approach to design the data warehouse. It's very different from other solutions. They have their own methodologies for doing things, and they can come up with a very solid and good design that can stand the test of time.

The functionality of the solution is excellent.

The solution can scale.

It's quite a stable product.

On the product side, I don't think anyone can actually beat them with data warehousing.

I'm not sure about the unstructured data management capabilities. It could be improved.

They should, I think, try to do more of this open-source initiative to encourage more people to use it. Otherwise, it's my opinion that they might lose our business in the long run.

I've been using the solution for about three years at this point.

As one of the top companies in the world, the solution is very stable. There aren't bugs or glitches. It doesn't crash or freeze. It's quite good.

Product-wise the scalability and usability, is all excellent. They are the top players in this with their new database. The cloud helps make it so scalable. We're catching up and starting to scale, however, we aren't there yet.

I don't recall if the solution had a complex or straightforward setup. I wasn't part of the process.

I'm not sure if we would want to keep paying for the solution. They should make some of the software a community edition or something like that to encourage more people to use it.

This is a very good solution. 

After looking at the recent price drops, they need to offer very good discounts for people that bought it. The value proposition is actually quite good compared to many years ago. For most of the enterprises out there, they're focusing mainly on structure data. This solution ticks that box.

As long as they can control the price incrementally in the future, I think they're a very good strong platform.

I'd rate this product in terms of its functionality, stability, and scalability, as almost perfect. It's a nine out of ten. I don't think there's anything to complain about. It's only the price that's a sticking point for us.

On-premises

We currently use the on-prem model of this solution. Our primary use case of this solution is as an enterprise tech warehouse for business intelligence across different domains. 

We've been using Teradata for close to twenty years and this version is a lot faster and more improved than the previous version that we used. It gives us more. It gives us the ability to be more resilient. It has fallback on default. We always have a copy of the copied data. There's more resilience and from a banking perspective, that is a good thing. 

Having continual fallback is good for security. We use the standard TTU utilities. That's what we use with all the different versions. It's faster and more resilient. 

They should add more connectors to different platforms. 

It could use a more powerful CPU and a faster IO. 

I have been using this solution for the last twenty years. We upgraded to the version we are currently using in December.

It is very stable. It's 100% uptime. Speed and resilience are one of the greatest features of this product. In almost twenty years we've never had downtime, except for outages for patches and upgrades. We've never had a system failure in twenty years. 

Its scalability is first class. We can easily add more nodes to it. We have around three to four thousand users. 

We have 100 people maintaining different applications. We don't currently have major plans to increase usage.

Their technical support is excellent. If you have a P1 you call within the hour. 

The initial setup was straightforward. We didn't have any problems installing the new platform. The deployment took six months. 

We implemented it ourselves. 

We didn't evaluate other options because we've been using Teradata for 20 years. We update versions. 

It's an excellent product. It's tried and tested with large organizations. The on-prem product is very powerful. Teradata has a cloud option. Both are good options. It depends on what your organizational plans are. 

I would rate this solution a nine out of ten. 

We have been using the on-premise PostgreSQL, and most of our data comes from SAP. We have all our Oracle logs being pushed to Teradata, which is where we take the data, then skim it. We pass it through whatever it is we are using, then turn it back to the customers. 

Therefore, our primary use case is to distribute the data across all types of commercial and personal consumers, making it available as fast as possible.

We are able to distribute Teradata in different regions to increase availability. As we are slowly moving everything to AWS cloud, we haven't had to worry about anything.

I like writing preformance queries for preprocessing on AWS Cloud.

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.

One to three years.

The stability is fine. We did not see a lot of downtime while migrating. It was a pretty clean transfer from on-premise to the cloud.

The scalability is great. AWS is all about the scalability.

I have not used the technical support.

Since we also use the AWS PostgreSQL, and some of our data is in there too, we came to the conclusion to move solutions within Teradata. Because already had the on-premise Teradata, it was easy for us to migrate from on-premise Teradata to AWS Teradata.

The integration and configuration of Teradata in our AWS environment was great. This lead us to use all the databases after making the move to AWS Cloud in Teradata.

I don't know about the pricing and licensing.

Initially, the whole infrastructure was on-premise. For the past year, we have started moving over to the cloud. The support that we receive from AWS is great.

The on-premise version is fairly to use. We don't have to scale it up nor scale it down.

Each has its strengths and weaknesses; this is why we use a blended environment. We have a holistic view which is very mature and thus, it is impossible to give a concise answer.

However, converting the Teradata from a pure BI to an ODS has been our greatest achievement; it effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes.

It is the core of our fundamental real-time reporting and operational planning. It has saved us over eight figures in the operational run costs, improved data quality and consistency as well as reduced our overall infrastructure support requirements.

The increasing volumes of data demand more and more performance. I truly believe that in five years, we will breach the effective limits of Teradata to perform in a multi-petabyte environment, i.e., without significant changes to its underlying architecture. If this occurs, we will be forced to migrate to a more traditional platform (such as IBM Informix).

We have aggressively been using BI for over 20 years, with this evolving environment. Our most recent setup was about three years ago.

We have a broad range of BI and reporting tools, built on top of the Teradata Platform. It, currently, is the active Data Warehouse on 12.x , although we are migrating to 13.x after the New Year. This is supported by our IBM Congos (12), MicroStrategy (10) and the QlikView (12) reporting tools. We have also built extensive analytics on a Java base as well as some Microsoft BI integration.

We have had stability issues quite frequently, but this is mostly with the Cognos environment, as it is growing beyond its limits in terms of the active user access. This is why we are considering migrating significant portions of our over 4000 users to a coded environment in place of the platform.

Again as mentioned before, there were scalability issues in regards to Cognos and the over 4000 users in a single active environment.

Our in-house team is world-class, so we are not reliant on any external support.

We have moved from a distributed heterogeneous to a centralized homogeneous environment. Costs, data quality, sharing of information, and supportability were the reasons as to why we switched over to Teradata.

The setup took place too long ago to remember.

Negotiate, negotiate, and negotiate some more. But long before you start to have a clear understanding of your direction, use patterns and check the roles that BI plays in the organization. Make sure you have the in-house skills to design and support the solution, as relying on external sources is extremely costly and tends to lock you into specific platforms, tools, and paradigms.

We did a six-month review of potential candidates and options. Every three to five years, we re-evaluate the selection criteria and re-open the solution's design with an invitation to the vendors to offer an alternative. The process consumes about three months, but it has allowed us to keep current and, more importantly, to leverage off the process so as to ensure that we are getting the best value for our money.

This comes back to understanding the what, why, and how of the solution. Once you understand that, then plan it accordingly and ensure you have sufficient time to address any of the surprises that could occur.

Each tool fills a niche and is used accordingly. I doubt if there is anything perfect out there, as each tool has its own considerations when being deployed.

Our greatest concern with Teradata is the performance impact of the OUTER RIGHT JOINS across a petabyte environment.

I am a Teradata administrator as well as a developer. I have about 700 users who are using our system, and we are maintaining the system in terms of tuning and in terms of all end-to-end items above the Teradata system.

We are using it as a data warehouse. In the data warehouse, we have got so many users who are doing their reporting and different types of analytics work using the solution.

Teradata's pretty fast. That is one very important aspect of the solution.

There are other tools, like Viewpoint, in Teradata, which is a monitoring tool.  

The integration is pretty easy here in Teradata.

It can scale.

We have found the solution to be stable. 

The market is enhancing, and every day, BigQuery, Snowflake, Redshift, and all these competitors are moving very, very fast. They're bringing out many new features. For example, Snowflake now has Time Travel and cloning and all these very interesting features. Teradata is an old data warehouse, and they're not improving in terms of new, innovative features. Basically, they're pretty much consistent and unchanging. They're not bringing new features. I've been working with it for eight years, and I have not seen so many new features. Maybe there have been only one or two in the last eight years. Innovation is something that is a bit slow with respect to Teradata. Other competitors are better in terms of new innovations. I'd like to see Teradata add features like cloning or time travel.

There is a query tool. However, we need to install the tool in order to fetch records. With other data warehouses, they have a web-based tool that allows for queries without having to download.

The initial setup is not too easy.

When we want to scale, we need to go to Teradata to initiate the process. 

I've been using the solution for around eight years. 

The solution is stable and reliable. I'd rate it nine out of ten. There are no bugs or glitches, and it doesn't crash or freeze. 

While the solution is scalable, and you can add new nodes if you want to, it's not instantaneous. We need to reach out to Teradata and they will handle the changes we require. Scaling is a process. 

Technical support has been very good. We have been pleased with the level of attention we receive. 

Positive

I also use BigQuery and Snowflake. They are more complex, and therefore, it can be harder to integrate using them.

Teradata is a better monitoring tool, and it offers better performance with respect to bigger data queries. However, it continues to lack innovation. 

The solution is not straightforward to set up. For example, if I target the users, the users need to install things and set up things up. Even the LDAP integration and all those things are not easy with respect to Teradata if I compare it with BigQuery, Snowflake, and Redshift.

If I want to spin off a new node or anything like that with Teradata, it's a bit tricky compared to other data warehouses where we can easily spin off new nodes and work on them.

Since our system is like a fixed system, when we did this deployment, it didn't take that much time. However, it was not easy. If I wanted to add additional load into the system, I needed to hand over the Teradata system to Teradata, and they had to do it, and that would take a day to do. Now, if I compare it with BigQuery or Snowflake, I can spin off new clusters without any issues. I can just add the number of nodes in that new warehouse, and I can run it. 

How long it takes to deploy depends on how big the system is. That said, compared to others, it definitely takes a little bit of extra time.

Since Teradata takes care of the implementation, I'm not sure how many people are ultimately involved in the deployment. From our side, we had two or three people involved in the setup. 

We have five to six admins to manage a 24/7 project.

Teradata handled a lot fo the implementation for us. 

I'm not overly aware of pricing. That said, my understanding is that it is reasonable. While it has a bit of an edge in pricing, everyone is relatively close in pricing. 

I'm a customer.

I'd advise potential users to do a proper POC first. 

Teradata is beneficial when we have a huge amount of data, and queries are complex. It works well with small queries as well. However, companies won't benefit that much from Teradata if they are only focused on small queries.

I'd rate the solution eight out of ten. If they were more innovative, I would rate them higher. 

Private Cloud

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.

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.

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

Teradata is superior, stable, and has no problems.

Teradata is easily scalable. 

The setup is complex and requires specialized people for implementation.

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

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

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

Teradata Data Lab is used for simulations.

In Data Lab, you can schedule any testing you want to do in production. You can take a small subset of data from production, copy it there, and run all your tests. It reduces your testing costs because it's all in the lab.

If I want to implement an upgrade, I'd like to see how it will be different. Ideally, Data Lab should help me test production items and also do future things. Future releases should be downloadable and testable in Data Lab.

Data Lab is very stable. It has been in the market for 25 years.

Data Lab is highly scalable. My organization has a lot of users, but each company has more than 30,000 users. More than a thousand customers are using it, so there are more than 300,000 users out there.

Teradata technical support is excellent. 

You don't have to do any installation. It is an out-of-the-box solution. It's low maintenance. We have one person, but if you need 24/7 coverage, you need four or five people. 

We have a subscription. Nowadays, everything is cloud-based, so you pay for the subscription, and it is pretty affordable. There aren't any additional costs. So what you see is what you get. 

I rate Teradata Data Lab nine out of 10. 

Public Cloud