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.

Teradata was mostly a control system for us where we were fetching the data from it on basic time intervals, on various DVs and various schema where we had to fetch the data. Reading was the main operation that we used Teradata for, but while reading, there were complex ENTs that we had to write because of a few data that was supposed to be transformed and then fetched, so that was the major use case for the solution.

There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems.

Teradata is good, but eventually, my company is moving to a higher-level system. You wouldn't want to work on a lower-level system.

As for the areas for improvement in Teradata, since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time.

What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good.

I've been using Teradata for a year and a half now, and I'm using its latest version.

In terms of stability, Teradata is stable. All legacy systems are quite stable and do not have that much downtime, probably because no one would work with a system that is not stable.

Teradata is scalable, but it takes time because you have to increase the servers. On the legacy system, it's the physical servers that you increase and that takes time.

I don't have experience with Teradata technical support, because the client handles the maintenance. It's the client who reaches out to the technical support team in case there's a need to increase service on the Teradata system, or if there's any downtime or any glitches in terms of catching or loading the data, but that doesn't happen often.

Setting up Teradata took time. The server has to be set up and that takes time. Next, the IDs need to be set up and the role level security that the legacy system provides is definitely not up to the mark when compared to the cloud, so that is a concern. I'm talking truly about the legacy system. I haven't worked on the cloud part of it. It took more time to deploy Teradata.

Deploying the solution from dev to the QA environment, for example, creating tables, then copying over the data, are completed within twenty four to forty eight hours. It's the timeframe the DBA used to give, which is pretty high. With the closing features that we have normally, that would be a long time.

Implementation was taken care of by the client.

Teradata pricing is fine, and it's competitive with all the legacy models. On a scale of one to five, with one being the worst and five being the best, I'm giving Teradata a three, because it can be a little expensive, when compared to other solutions.

Teradata requires maintenance, but the team in charge of the maintenance was not in-house. It was taken care of by an external support team. There are forty to fifty users of the solution in the company. I'm use Teradata on a daily basis.

I'm rating Teradata an eight out of ten.

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. 

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.

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.

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.

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.

We are satisfied with the stability.

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.

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.

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.

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.

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.

We used the solution for our data warehouse. 

The availability is very good.

We have found performance to be one of the most valuable aspects. 

The solution scales well on the cloud. 

Teradata is a bit late for the cloud. They maybe need to have some room for cloud improvements.

Scalability is limited on-premises. 

The solution could use more AI support.

I've used the solution for a while. The last time I used it was two months ago.

The performance is great. It's stable and reliable. There are no bugs or glitches. It doesn't crash or freeze. 

Teradata is a 100% stable environment.

In on-premise systems, it was a bit tricky to scale. However, in the cloud, it's very easy.

People are not directly connecting to Teradata. However, they are using reports that are fed from Teradata. In that sense, the entire company is using Teradata. It's more than 1,000 people.

I'm not directly connected with technical support from Teradata. I connect the local support here, and they are connected to Teradata, and on the weekends or after working hours, we get support and solutions. So we were happy with Teradata's and local company's support.

Positive

This product was already set up when I joined the organization. As far as I know, they were trying to replace SAP BW. There was an SAP BW system, and they were trying to replace it with Teradata. 

It was easy for me to set up since I didn't handle the setup. Our local support company managed everything and prepared the environment, and handed it over to us. It was very easy in that sense.

We had a local support organization assist us in the setup.

We have seen an ROI. It's worth the money.

Teradata is not a very cheap solution, yet it is a good solution. You get a good return on what you have paid for.

I'm an end-user.

If new users are experienced database users, they will know the administration side is different than the other databases. However, it's almost the same for an end user, a developer, or somebody doing reports on Teradata on another database. It has some differences, yet the logic is the same.

I'd recommend the solution to others. I love Teradata.

I would rate the solution an eight out of ten.

I was happy to use it. I was glad to have Teradata, since, with Teradata, we can meet the requests of the customers, and it is highly available. 

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

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

Teradata's UI could be improved.

I've been using Teradata for about four years.

Teradata's stability is good.

Teradata's scalability is one of its best features.

Teradata's licensing is on the expensive side.

I would rate Teradata nine out of ten.

The purpose that we are using Teradata for is to migrate data to the cloud.

The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security.

Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency.

I have been using Teradata for approximately one year.

Teradata is stable.

I rate the stability of Teradata a seven out of ten.

We have more than 1,000 people using Teradata in my company.

I have not used the support from Teradata.

The initial setup of Teradata is not simple.

We have different teams of approximately 200 people total that are supporting Teradata in many cities and branches.

The price of Teradata could be less expensive.

I rate the price of Teradata a seven out of ten.

We did not evaluate other vendors before choosing Teradata.

I rate Teradata an eight out of ten.

We primarily use the solution for the EDW. 

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. 

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.

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

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. 

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. 

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. 

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. 

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.

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

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. 

Primarily, Teradata is a traditional data warehouse, but we also encourage our customers to adapt to the logical data warehouse and data lab.

The most valuable feature is the ability to be anywhere - Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again.

Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives. In the next release, I would like Teradata to refine their Object Store to be more compatible with cloud environments.

I've been working with Teradata since 2014.

Teradata's stability is very strong, and our customers feel their data is safe with it.

Teradata's scalability is good, it takes only the push of a button to scale up, and if that's not enough, you could scale with the cloud or a virtual machine.

The initial setup is straightforward if you have some knowledge about the logic of the environment. However, for those without knowledge, there will be a learning curve to understand how to use the solution.

Our customers say that Teradata makes them faster, smarter, and capable of more sophisticated analytics.

For anyone thinking of implementing Teradata, I would recommend preparing by understanding the technology and putting in the effort to keep it being adaptive to different and urgent requirements from your business. I would give Teradata a score of ten out of ten.