Vice President IT Architecture at a comms service provider with 1,001-5,000 employees
Real User
Robust data warehousing capabilities that offer high stability, with notable challenges with scalability costs and hardware dependencies
Pros and Cons
  • "Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
  • "The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."

What is our primary use case?

We use it primarily as a dedicated platform for aggregating structured data, essentially serving as our structured data repository or data warehouse.

What is most valuable?

Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable.

What needs improvement?

One issue we've identified is that its performance varies across different on-premises setups and doesn't consistently meet our standards. This limitation necessitates the purchase of Teradata's proprietary hardware to ensure the desired level of performance. The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial.

For how long have I used the solution?

I have been using it for four years.

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.
765,386 professionals have used our research since 2012.

What do I think about the stability of the solution?

The stability is excellent, and I would rate it nine out of ten.

What do I think about the scalability of the solution?

The challenge lies in the necessity to purchase additional hardware for scaling, so I would lean towards a rating of around four out of ten for the overall experience.

How are customer service and support?

The technical support is satisfactory; I would rate it seven out of ten.

How would you rate customer service and support?

Neutral

How was the initial setup?

I would rate the initial setup six out of ten when it comes to complexity.

What was our ROI?

I would rate the return on investment eight out of ten.

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

The cost is significantly high. I would rate it eight out of ten.

What other advice do I have?

Overall, I would rate it seven 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.
Flag as inappropriate
PeerSpot user
Al Krause - PeerSpot reviewer
Managing Director at advanced business horizons
Real User
Top 5Leaderboard
Expensive and lacking scalability but functions speedily

What is our primary use case?

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

What is most valuable?

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

What needs improvement?

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.

For how long have I used the solution?

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

What do I think about the stability of the solution?

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

How are customer service and support?

The technical support is fine. 

How was the initial setup?

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. 

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

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. 

What other advice do I have?

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. 

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
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.
765,386 professionals have used our research since 2012.
Data warehouse consultant at Profinit
Consultant
Top 20
Powerful, good for large amounts of data, and easy to set up
Pros and Cons
  • "Designing the database is easy."
  • "It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

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. 

For how long have I used the solution?

I've been using the solution for 20 years.

What do I think about the stability of the solution?

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. 

What do I think about the scalability of the solution?

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. 

How are customer service and support?

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

How was the initial setup?

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. 

What about the implementation team?

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.

What was our ROI?

I have witnessed an ROI while using the solution. 

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

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

What other advice do I have?

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. 

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
Blaine VandeBerg - PeerSpot reviewer
Principal at Insight Data Consulting
Real User
Excellent native features, highly stable, and impressive automation
Pros and Cons
  • "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."

What is our primary use case?

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

How has it helped my organization?

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

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

I have been using Teradata for approximately 20 years.

What do I think about the stability of the solution?

The stability of Teradata is outstanding.

What do I think about the scalability of the solution?

Teradata is highly scalable, it is excellent.

We have approximately hundreds of users using this solution.

How are customer service and support?

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

Which solution did I use previously and why did I switch?

I previously used SQL Server.

How was the initial setup?

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.

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

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.

What other advice do I have?

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.

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
Data Engineer III at a media company with 1,001-5,000 employees
Real User
Top 20
Fast with good monitoring and able to handle big queries
Pros and Cons
  • "Teradata's pretty fast."
  • "Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."

What is our primary use case?

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.

What is most valuable?

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. 

What needs improvement?

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. 

For how long have I used the solution?

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

What do I think about the stability of the solution?

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. 

What do I think about the scalability of the solution?

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. 

How are customer service and support?

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

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

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. 

How was the initial setup?

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.

What about the implementation team?

Teradata handled a lot fo the implementation for us. 

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

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. 

What other advice do I have?

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. 

Which deployment model are you using for this solution?

Private Cloud
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
Top 20
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
Rajdeep Biswas - PeerSpot reviewer
Technical Architect - Sr. Manager at Axtria - Ingenious Insights
Real User
Stable and easy to use data warehousing
Pros and Cons
  • "Teradata's most valuable feature is that it's easy to use."
  • "Teradata's UI could be more user-friendly."

What is our primary use case?

My primary use of Teradata is for data warehousing.

What is most valuable?

Teradata's most valuable feature is that it's easy to use.

What needs improvement?

Teradata's UI could be more user-friendly.

For how long have I used the solution?

I've been using Teradata for over five years.

What do I think about the stability of the solution?

Teradata is pretty stable.

What do I think about the scalability of the solution?

Teradata is scalable.

How was the initial setup?

The initial setup was straightforward.

What about the implementation team?

We used an in-house team.

What other advice do I have?

I would rate Teradata as eight 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
Test Engineer at cigniti
Real User
Top 5Leaderboard
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. 

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