Teradata Reviews

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. 

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. 

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 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. 

Our use case is for data warehousing and BI reporting. We are customers of Teradata.

The solution is speedy and doesn't require much of a DBA team, it's kind of baked right into the product.

Any value this product provides is offset by the high cost and lack of scalability. We're moving to Snowflake because of the scalability and cost differentials. There are better, more flexible, robust, and economical options out there.

I've been using this solution on and off for 20 years. 

The solution is stable, it's a best-of-breed product, but the architecture is old school.

The technical support is fine. 

The initial setup was fine but whenever we needed to increase the size and capacity, it would literally take a room full of people, a very coordinated effort and it was a huge project, in contrast to a product like Snowflake, where you literally just change the warehouse size and it auto-scales. So those types of things really hindered Teradata prem. 

The cost depends on the size and it can be quite expensive. If you have 1,000 users, the cost can be anywhere from half a million to a million dollars a year. 

It's hard to compare their on-prem solution to current cloud environments. From an on-prem perspective, it's expensive but fantastic.The problem is that nobody's playing in that space anymore. People are using the cloud, and the cloud has better options.  

Because it's on-prem, I rate this solution four out of 10. 

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.

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.

We primarily use the solution as a relational database. We use it mainly for logistics. 

The solution offers very good features. It's useful when you are working with data. 

The level of complexity is okay.

It can handle very large amounts of data. It is very powerful. 

Designing the database is easy.

The solution is stable.

It is easy to set up.

The scalability is good. 

Technical support was fine to deal with.

I'd like to see a better relationship with the business itself. Business users have trouble finding solutions when they run into issues in the data warehouse.

It can be a bit complex to work with.

Regarding data warehousing, I'd like to see more data and business analysis to help with the design and development. 

It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies. 

I've been using the solution for 20 years.

The solution is stable and reliable. It doesn't crash or freeze. There are no bugs or glitches. As long as it was designed well, a company shouldn't have issues. 

The solution can scale well.

I'm not sure how many users are on the solution. Likely, it is up to hundreds of users. 

We do not have plans to increase usage. We stopped using it this summer. 

We've used support in the past. I had worked closely with them. The technical team was fine to deal with.

It's not too complex. It's designed for huge amounts of data, and it's planned out well. As long as you follow some principles, it won't be too complicated. 

I've used the solution for more than a decade. It was a while since I deployed the solution. 

You start with business analysis and design the database structure from there. After that, you can start populating and developing. 

How many people you need for deployment or maintenance would depend on how big the implementation is. 

Typically, we handle the initial setup in-house. It is possible to get help if we need it. Whether or not a company needs help depends on the customer and their level of comfort with the setup.

I have witnessed an ROI while using the solution. 

The pricing makes sense for bigger projects. It wouldn't make sense for smaller companies or smaller projects.

We are primarily using the latest version of the solution. 

It works well both on-premises and on the cloud. 

I would recommend the solution. However, it depends on the project itself. Based on the stability alone, I would recommend it. It's good for bigger projects. If it is used for small projects, the complexity and price may be too high. 

I'd rate the solution nine out of ten. 

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.

The two types of partitioning have been very significant for us - row and columnar partitioning.

With the current machine we are able to eliminate the use of OLAP cubes and allow customer queries to run directly on the Teradata machine.

We have now started running more profit generating activities on the Teradata machine, as opposed to just running reports, as in the past.

Data synchronization to the DR site.

My company’s management has to decide whether to invest in this area. This is more an internal issue at the company and definitely not a problem with the Teradata product. If we end up migrating to another platform, this will be the reason.

We have been using the solution for seven years.

Teradata is the most stable platform that I’ve worked with in my 20-year career.

Teradata’s scalability is excellent.

Teradata’s technical support is excellent. The support people are highly professional, and nice, to boot.

My previous background was with Oracle. I changed jobs and was asked to handle the Teradata team. It was a chance to learn something new and interesting.

Initial setup is quite straightforward, but previous experience with other databases tends to make it more difficult, because it takes a while until you get used to thinking in Teradata terms, rather than Oracle/SQL Server/PostgreSQL terms.

It’s a different animal. However, once you start thinking like a Teradata DBA, things are much easier.

Pricing can seem high, but when all factors are taken into account, the total costs are comparable to other databases as:

• Few DBA’s are required
• Unplanned downtime is very rare.

By avoiding the Enterprise solutions, you can actually end up with a cheaper, yet much more powerful machine. We moved from an Enterprise platform, to non-Enterprise and ended up with a machine that was 20X more powerful. We got an amazing performance boost.

Every few years we examine the option of migrating to other platforms such as HPE Vertica, Oracle Exadata, or SQream.

In the past, it turned out that other solutions, in order to provide the full range of abilities that the Teradata platform provides plus the migration costs, would end up costing more than Teradata does.

Make sure that you have a good Teradata DBA to help implement the solution. A great Oracle DBA is not sufficient, because it takes a while to internalize that they are two different things.

Make sure that you have a good backup/recovery/DR plan, and that it is covered by the infrastructure you are purchasing. Otherwise, you might find yourself with a system that performs great, but has no good DR solution.