Try our new research platform with insights from 80,000+ expert users
Rupal Sharma - PeerSpot reviewer
Data Architect at Three Ireland (Hutchison) - Infrastructure
Real User
Top 5Leaderboard
Fast data ingestion, manipulation, and exploration capabilities but expensive solution
Pros and Cons
  • "It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
  • "Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."

What is our primary use case?

Our use cases are all about data ingestion, data manipulation, and data exploration. It's the core database for us.

What is most valuable?

It's the same as your visual database. I like the fast load feature for data, BTQ nd storage procedures are very good. They can avoid table locking, which is very good.

What needs improvement?

Sometimes the large ingestion jobs takes days to load data, and some of our stored procedures take longer. I don't know whether it's the tool or the network, but it takes a long time to execute complex commands.

For how long have I used the solution?

I've been using this solution for around five years Now. We currently use the latest version. 

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

What do I think about the stability of the solution?

It is a stable solution. I would rate the stability a nine out of ten.

What do I think about the scalability of the solution?

I would rate the scalability a nine out of ten. It is scalable. 

There are more than 100 users currently using Teradata in our organization.

How are customer service and support?

The customer service and support are good. But they take a long time to respond.

So there is room for improvement in response time. 

How was the initial setup?

It's a very straightforward installation process. It's good in terms of installation.

What about the implementation team?

The solution requires maintenance. Our team of ten engineers manage and maintain the solution.

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

It is yearly basis. The licensing is based on a contract. It's a very expensive product.

I would rate the pricing model a three out of ten, where one is very expensive and not cost-effective, and then ten is a very cheap product. The solution is fairly expensive. 

What other advice do I have?

Overall, if I consider the expense, features, and everything, then I would rate the solution a six 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 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
Buyer's Guide
Teradata
December 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
830,526 professionals have used our research since 2012.
AbhikRay - PeerSpot reviewer
Co-Founder at Quantyc
Real User
Easy to set up with fast data input but needs more documentation surrounding their on-premises offering
Pros and Cons
  • "It's stable and reliable."
  • "From my perspective, it would be good if they gave better ITIN/R plugins to use the data for AI modeling, or data science modeling. We can do it now; however, it could be more elegant in terms of interfacing."

What is most valuable?

There are two very useful features. 

One is the fast data input for more or less any online data. It performs rather well. Two, it also has a lot of tools for data engineering or data manipulation that are compatible. 

The solution offers an easy setup.

It's stable and reliable.

The solution like scales just fine.

What needs improvement?

Some of our clients are looking for on-premise installations as well. Although we don't have any, some of our prospects are also asking, and we are not sure if that part is easily doable or is as effective. We haven't tried on-premises, so we don't know how good it is. We are not confident about proposing on-premise to them, since we are more familiar with the cloud. Maybe some documentation on how on-prem works or what other things to look for in on-premise deployment would be helpful. We'd love to see more tutorials. 

Our company does data science and AI machine learning algorithms on the data that is deciding on the Teradata, so that's the value we add. From my perspective, it would be good if they gave better ITIN/R plugins to use the data for AI modeling, or data science modeling. We can do it now; however, it could be more elegant in terms of interfacing.

For how long have I used the solution?

I've been using the solution for four or five years. 

What do I think about the stability of the solution?

The solution is very stable, and the performance is good. It's reliable. There are no bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

Our clients do not have very large data sets. So far, the environment has scaled fine, however, once the volumes grow, we will have to see whether we are facing any problems or not. Right now, we don't see any problems. We just haven't tried to scale massively.

How are customer service and support?

We haven't needed much technical support. That said, some of my colleagues have been able to contact them and get service as and when required. It's all right. 

How would you rate customer service and support?

Positive

How was the initial setup?

On cloud, it is very easy to set up. 

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

It's moderately priced. It's not cheap. I'd rate it 2.5 out of five in terms of affordability.

Which other solutions did I evaluate?

I am not knowledgeable about the other vendors to make a meaningful comparison. I haven't really taken the time to evaluate other options. 

What other advice do I have?

The solution is most suitable for medium to large-scale businesses. 

I'd rate the solution seven out of ten.

I would recommend the solution to others. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Director8158 - PeerSpot reviewer
Director of Data at a leisure / travel company with 1,001-5,000 employees
Real User
It helps us with connectivity and making sure the data is secure
Pros and Cons
  • "It is quick, secure, and has less hassles because we don't have to involve our networking team, infrastructure, etc. It is very easy to deploy and make market ready."
  • "I would like more security and speed."

What is our primary use case?

We have all our workloads on AWS.

How has it helped my organization?

Having Teradata in AWS:

  • Helps us with connectivity.
  • Making sure the data is secure.
  • Reduces the hops.
  • Helps us more with real-time data.

We had few reports which were taking more than 45 minutes. Then, with Teradata, we received results within minutes, and a few under a minute. We thought that something went wrong, and we hadn't done the work properly, but we saw the exact same results on both. So, our end users were pretty happy.

What is most valuable?

It is quick, secure, and has less hassles because we don't have to involve our networking team, infrastructure, etc. It is very easy to deploy and make market ready.

What needs improvement?

Teradata wants to come out of the hardware business and to run its own cloud on other public clouds. I think that is a great way to go. However, there are challenges to doing this. There are multiple layers of security and caching. E.g., if you have a lot of compute or a caching that will offload a lot of compute activity because it's already there, it will save its cycles for something which needs to be done. This way, you are offloading your compute, so you can go with a lesser capacity than a higher capacity. That is what this appliance does.  If they are moving off of the appliance, I am curious to see if their software will withstand the change, or will Teradata still run but need a bigger box?

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.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

We haven't had any outages in one and a half years. That is a good statement.

What do I think about the scalability of the solution?

I have not heard anyone complain about performance.

How are customer service and technical support?

The technical support is pretty good. The response rate is good.

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

We had a bunch of legacy warehouses, which we wanted to consolidate, as well as stay up-to-date with warehousing options. This is why we moved into Teradata.

How was the initial setup?

The integration and configuration were seamless for us.

We have multiple sources of data, so Teradata has a lot of connectors which pulls all our data from different workloads. The integration works really well.

What about the implementation team?

We had help with the integration and configuration.

What was our ROI?

When your customer is happy, dollars and cents sort of blur. Our return on investment would be customer satisfaction, which I think is priceless.

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

We had a lot of parties involved when purchasing from the AWS Marketplace. They are very flexible and aggressive in trying to close the deal. They are good at what they have to offer and listening to the customer. It's a two-way street.

In this day and age, we want to get things done quickly. So, we go to the AWS Marketplace.
Also, we have a consistent experience with Teradata usage on its cloud, so we already know the product.

For what Teradata has to offer, their price is comparable to its competitors.

Which other solutions did I evaluate?

We evaluated Redis and Teredata, doing PoCs with both. We had more support from Teradata to start with, and we were new to both. We were not in a situation to tell which one was good, because both were new to us. We just had more support from Teradata to help us see the results on what we are looking for.

What other advice do I have?

Do your homework before you make a decision. Everyone is different; every shop is different. That is what makes it fun to be in IT.

When you look for a solution, you will uncover many advantages. All those hidden things which are not clear initially when you do a cost analysis. A cost analysis is something that you have to do from the get-go, but it also has to be an ongoing process. Your workloads change, requirements change, everything changes, so it has to be a constant feedback.

We have used both the on-premise and AWS versions.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Data Engineer at a recreational facilities/services company with 10,001+ employees
Real User
Top 5
An industry-leading data warehousing solution that has MPP architecture
Pros and Cons
  • "Teradata is a great, industry-leading data warehousing product that has MPP architecture."
  • "Teradata hardly supports unstructured data or semi-structured data"

What is most valuable?

Teradata is a great, industry-leading data warehousing product that has MPP architecture. In recent times, there have been many other products available in the cloud space. It has a lot of other features like linear scalability and unconditional parallelism.

What needs improvement?

Teradata hardly supports unstructured data or semi-structured data. Teradata is very costly, and it's not easy to upgrade or expand the components in Teradata. A lot of infrastructure needs to be set up in order to use Teradata.

For how long have I used the solution?

I have been using Teradata for more than 15 years.

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

Teradata is a very expensive solution.

Which other solutions did I evaluate?

Many other products equivalent to Teradata are available in the market, like BigQuery, Redshift, and Snowflake.

What other advice do I have?

Teradata is a suitable solution for small customers.

Overall, I rate Teradata an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1306140 - PeerSpot reviewer
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.

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.
PeerSpot user
MartinPotgieter - PeerSpot reviewer
Services Manager at Bytes Systems Integration
Real User
Top 5
Reliable and high-quality data warehousing solution
Pros and Cons
  • "IntelliFlex is easy to scale - one of its best features is that you can upscale it to the size you want."
  • "The initial setup is complex because there are a lot of factors that come into play, including the amount of software and applications that require access."

What is our primary use case?

IntelliFlex is used in the banking sector as a production system.

What is most valuable?

IntelliFlex's best feature is its reliability.

For how long have I used the solution?

I've been using IntelliFlex for three years.

What do I think about the stability of the solution?

IntelliFlex is very stable, aside from some issues with the Unity Software, though I believe those are being resolved now.

What do I think about the scalability of the solution?

IntelliFlex is easy to scale - one of its best features is that you can upscale it to the size you want. For example, we started in vertical with a six-node system and now have a twenty-four-node system.

How are customer service and support?

IntelliFlex's technical support is excellent.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup is complex because there are a lot of factors that come into play, including the amount of software and applications that require access. Deployment takes around two to four months, assuming that all the company's applications are compatible with the system - if not, it may take longer.

What other advice do I have?

IntelliFlex is the Rolls Royce of data warehousing. I would recommend it to other users and rate it 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
Al Krause - PeerSpot reviewer
Managing Director at advanced business horizons
Real User
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
Download our free Teradata Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2024
Buyer's Guide
Download our free Teradata Report and get advice and tips from experienced pros sharing their opinions.