Try our new research platform with insights from 80,000+ expert users
it_user291063 - PeerSpot reviewer
Lead Teradata DBA at a manufacturing company with 10,001+ employees
Vendor
It's complex in terms of physical data modeling, but it can process large amounts of data quickly.

What is most valuable?

  • The ability to process large amounts of data very quickly
  • Its adaptability

How has it helped my organization?

Our business processes are much more efficient with Teradata's speed.

What needs improvement?

I'd like to see better processing on a transactional level and star schema optimization.

For how long have I used the solution?

I've been using it for 13 years.

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

What was my experience with deployment of the solution?

No issues encountered.

What do I think about the stability of the solution?

No issues encountered.

How are customer service and support?

Customer Service:

It's excellent, 10/10.

Technical Support:

It's excellent, 10/10.

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

No other previous solution for these applications was used.

How was the initial setup?

It's complex in terms of physical data modeling.

What about the implementation team?

We used a hybrid team of both in-house staff, and a vendor team.

What was our ROI?

It's more than 100%.

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

It's not cheap but definitely worth it. It's been chosen by companies that tried cheaper solutions.

Which other solutions did I evaluate?

We also looked at DB2.

What other advice do I have?

Know your data.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1645335 - PeerSpot reviewer
Director of Product Management at a computer software company with 11-50 employees
Real User
Scalable, reliable and easy to access data
Pros and Cons
  • "The product is reliable."
  • "It could be a bit more user-friendly."

What is our primary use case?

We primarily use the solution for data warehousing. 

Primarily what happens is, in Juniper, they have internal business analytics and intelligence, a business intelligence analytics dashboard, and a lot of databases that capture the customer feedback. 

It actually captures all the internal defects that are tracked on products. There are different databases that accumulate all this data. Basically, you need to be able to source the data and do some filtering. We extract, transform, and load logic. We have to run certain business rules based on what the program or management team looks at. The teams want to filter out some of these problems that they have, and they want to analyze how well the company is responding to many of these customer issues, et cetera.

Our company is a large company with each particular team using its own database and its own database tables. It becomes extremely hard for the company to take the data from different data sources and be able to correlate everything and be able to analyze many of the processes that are happening within. There is a workflow discontinuity that has been observed due to the fact that the data is distributed. In order to understand exactly how a request comes in from the customer and what goes on behind the scenes in order to resolve the problem or to be able to provide the support to the customer, and how long does it take before the problem gets fixed and delivered, et cetera, we need to centralize everything and we use data warehousing for that. 

There are other similar kinds of business rules filtering that happen on the dashboard as well. This enables people to be able to view the data that is needed and the metrics that are of interest to them and is especially useful when it comes to the executive team.

What is most valuable?

The most valuable feature is the ability to be able to access the different data anywhere, and the Cloud Data Warehouse solution enables that. 

To be able to extract, transform, and load logic, and also to be able to correlate the data in different databases and not just correlate it in one is great. 

If I want to be able to perform certain database queries on a joint operation between database tables located on two different database sources, et cetera, I can do that. 

The most important thing we get out of the product is the intelligence that we derive. How the company feels in terms of process efficiencies is positive. In order to understand how a workflow is actually executed within the company, we need the assistance of this product. That's where the maximum value comes from. 

The ability to access the data from a website or from anywhere is very important. The people themselves can also be anywhere. 

The licensing system enables the company to track how a switch is used by an end customer, an end-user, and what different features the customer is actually running. It tells us a lot about the product. You have a lot of quantitative data that can provide an understanding of people's behavioral patterns and people's usage patterns when it comes to understanding what features or what are those elements that customers are most interested in - that can be tracked. 

The solution is stable. The product is reliable.

The scalability is good. 

Technical support has been good. They are helpful.

What needs improvement?

In terms of improvements, I can only speak from the dashboard perspective. 

The most important thing is that I don't know how far the dashboard integration goes. People, for example, were using the Cloud Data Warehousing product, however, they were actually building their own dashboards, et cetera. That's like double the amount of work. The company should have the ability to integrate with something like Tableau to make everything more standardized.  

With the customer data, we were able to integrate very successfully with Tableau and we were able to use it well from an end-user perspective. We were using the Tableau interface for understanding what our customer buys, et cetera. For example, for the customer financial data aspect of it, the business data, we were able to use Tableau dashboards. It would be better to use back-end data warehousing and also have dashboard reporting and have everything integrated properly. It doesn't need to be Tableau. It can be some other dashboard. However, it needs to be standardized. 

The usability could be a bit better. It could be a bit more user-friendly.

For how long have I used the solution?

I've been using the solution for five or six years or so. We've used it for a while. 

What do I think about the stability of the solution?

The solution does seem to be a quite stable solution. We haven't had any major issues that I am aware of. Generally, stability has never been a problem with the product. There are no bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

The scalability seems to be pretty good. If a company needs to expand it, it can do so.

How are customer service and support?

Technical support is decent. We are satisfied with the level of support we receive. 

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

Some time ago, we also implemented SAP internally within the organization. For some reason, there was a decision not to go with the SAP HANA. I don't know why that decision was taken. Likely, it had to do with the kind of data or the kind of use case that we had and the data sources that we had. Teradata was considered to offer better performance and was a better-performing product.

What other advice do I have?

Teradata definitely does what it says, in terms of an on-demand platform, as it's a cloud service and it is definitely scalable. It's secure and it does provide scope for a lot of automation. The provisioning part of it, the administration and backup recovery as well as the analytics are some things that could be integrated in a more advanced manner. Maybe certain enterprise use cases need to be included so that users in an enterprise environment can build an analytics dashboard out of it. Support is good, however, the support requirements are not too much. Overall, the usability can be a little simpler. In general, we've been satisfied with it as a product.

I would rate the product at an eight out of ten. I want to be a little bit conservative in my rating as I want to be sensitive to the fact that people really want to be able to do the slicing and dicing of data at a user interface level and to be able to see all the insights at once. At that level of usability, to be able to slice and dice, you need to give a dashboard to a user. 

If, for example, I have a certain type of organization that has a hierarchical organizational setup, I should be able to slice it to a specific group or a specific department, or a specific team. I should be able to see the metrics corresponding to that, or corresponding to the drilled-down data. While that's possible today, what I'm trying to say is that to be able to do it as a business user, to be able to use an interface in order to be able to do that kind of custom slice and dice operation and see the data in real-time, people are looking for more. Users want a level of usability from a business rules perspective, et cetera. That's something that people are looking forward to from intelligent and smart dashboards. It just needs to offer something that is much closer to capturing real-time information.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Teradata
November 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,660 professionals have used our research since 2012.
it_user6057 - PeerSpot reviewer
Senior Java Developer at EPAM Systems at a tech vendor with 10,001+ employees
Vendor
Improved the performance of our ETL procedures and reporting
Pros and Cons
  • "Improved performance of ETL procedures, reporting."
  • "We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
  • "GUI of administrative tools is really outdated."

What is our primary use case?

How has it helped my organization?

Improved performance of ETL procedures, reporting. Decreased efforts, time, and number of staff supporting DWH.

What is most valuable?

  • Scalability
  • Functionality
  • Performance

What needs improvement?

GUI of administrative tools is really outdated.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

Nothing major, as far as I can recall.

What do I think about the scalability of the solution?

No issues, scalability is a key feature of Teradata.

How are customer service and technical support?

Support is on par with other vendors.

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

We used Oracle. Scalability and performance were the reasons we decided to try Teradata.

How was the initial setup?

It was easy, the whole job was done by Teradata.

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

It is still a very expensive solution. While I very much like the pure technological supremacy of the software itself, I believe Teradata as a company needs to become more affordable. They are already losing the market to more flexible or cheaper competitors.

Which other solutions did I evaluate?

We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server.

What other advice do I have?

Go with the Enterprise series and don't waste time and money on 25xx. Sooner or later you will migrate anyway, so don't even start with departmental solutions.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Solution Lead at a tech company with 10,001+ employees
Real User
This solution has proven technology with significant advantages in some key areas, and greater depth and experience in providing industry knowledge and solutions.
Pros and Cons
  • "Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
  • "There is some improvement required on OLTP level and some analytical function is missing."

What is most valuable?

  1. "Parallel Everything” design and smart Teradata Optimizer enables fast query execution across platforms.
  2. Fully parallel MPP “shared nothing” architecture scales linearly across data, users, and applications, providing consistent and predictable performance and growth.
  3. In-database data mining, virtual OLAP/cubes, geospatial and temporal analytics, custom and embedded services in an extensible open parallel framework, drive efficient and differentiated business insight.
  4. Workload management options by user, application, time of day, and CPU exceptions.
  5. Teradata Columnar/Teradata Temporal.
  6. Compress on cold and intelligent multi-temperature data management.
  7. Enhanced security.
  8. Customer driven innovation in application migration and temporal.
  9. Intelligent Scan Elimination.

How has it helped my organization?

Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services.

Teradata has proven technology with significant advantages in some key areas, and greater depth and experience in providing industry knowledge and solutions.

What needs improvement?

There is some improvement required on OLTP level and some analytical function is missing.

For how long have I used the solution?

I've used it for almost five years.

What was my experience with deployment of the solution?

Did not encounter any issues during deployment.

What do I think about the stability of the solution?

No stability issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

They deliver the products to customers faster and with greater accuracy, i.e. within the agreed-upon due date .

Technical Support:

Teradata already had a excellent customer satisfaction and the rating would be eight out of 10.

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

No other solution used.

How was the initial setup?

Teradata setup is straightforward and simple.

What about the implementation team?

The implementation done mainly with the in-house teams and also some support of vendor team.

What was our ROI?

100%.

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

Teradata is easy-to-use for data warehouse and BI application. It's extremely fast and also advanced analytics work can be done in a very flexible manner.

Which other solutions did I evaluate?

We also looked at Oracle Exadata.

What other advice do I have?

Teradata provides the analytical performance we need through its “parallel everything” design and industry leading optimizer to intelligently process all types of analytical and business intelligence queries.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Head of Information management with 1,001-5,000 employees
Vendor
Top 20
Working with Teradata, Cognos and Informatica is a positive combination of good tools but implementation can be complex

I have been using Teradata and Cognos for the past 8 years and Informatica ETL tool for 1 year. I have found that the analytical CRM functionalities from Teradata using Teradata database has been the most valuable feature of this product. It has helped the way my organization functions in that we build a data warehouse to have a single version of the truth with all the needed aggregations, and all the analytical reports are now using this database which leads to consistent data. Additionally, all the analytical reports are now generated using Cognos BI tool which is very powerful and the business powerful users can build their own analytical reports.

My company had previously used a different solution before Informatica and we are still in the transition phase, ETL from data stage. Before choosing this product we evaluated Informatica, Oracle ODI and our current ETL data stage. We switched because Informatica is better in terms of tool, support, and at the same time, because we bought Informatica data quality tool for the data governance dept after vendor selection process. During the deployment of Informatica ETL there were some performance issues but they were solved.

Regarding the level of technical support, I would say that for Teradata it is average, for Cognos and Informatica it is good. The initial set up for Teradata was a little bit complex due to some specific applications used in my country while for Cognos, it was straightforward. For Informatica, the initial set up was a little bit complex due to the different environment where the tool has to be implemented. We always implemented in-house but in collaboration with a vendor team and found that their level of expertise was good. My advice to others concerning Teradata, it is a powerful product to build a data warehouse in the organization, but take into consideration that Teradata is using its own hardware to have a good performance. I have found that Informatica’s data quality is the best tool to profile, clean and monitor the data.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Solution Sales and Lead Information at TechAccess Asia Distribution
Real User
Good performance, flexible, easy to tune queries, and scales well
Pros and Cons
  • "The flexibility in design is very good."
  • "Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

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.

What do I think about the stability of the solution?

We are satisfied with the stability.

What do I think about the scalability of the solution?

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.

How was the initial setup?

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.

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

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.

Which other solutions did I evaluate?

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.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
it_user1043649 - PeerSpot reviewer
Senior Analyst at a consultancy with 501-1,000 employees
Real User
Easy to run queries, but very large datasets cause problems and technical support needs improvement
Pros and Cons
  • "The most valuable feature is the ease of running queries."
  • "Stability-wise, we have had some issues with automation and the ability to handle large datasets."

What is our primary use case?

Our primary use case for Teradata is reporting. I am a business analyst and I use this solution to first analyze my data and then visualize it. 

What is most valuable?

The most valuable feature is the ease of running queries. 

Automation is very important to us.

What needs improvement?

To run our reports I have to upload data from past tables and it is always a problem, so there is a lot of room for improvement there. It just struggles when I have to load data and I would like to see better file processing power.

I have seen instability in automation when working with very large datasets.

Technical support needs improvement.

For how long have I used the solution?

I was been using Teradata Cloud Data Warehouse for three years.

What do I think about the stability of the solution?

Stability-wise, we have had some issues with automation and the ability to handle large datasets. 

What do I think about the scalability of the solution?

We have approximately 800 people using this solution. We are not planning to increase usage at this time. In fact, we may be shifting to a different storage or different data warehouse.

How are customer service and technical support?

I have contacted Teradata technical support lots of times. I would rate them a two out of five. They do not solve the problem, most of the time.

What about the implementation team?

This solution was set up by our technical person.

Which other solutions did I evaluate?

We evaluated Microsoft SQL Server as a trial version and we thought that we preferred Teradata.

What other advice do I have?

My advice for anybody who is considering this solution is first to look into the availability of customer support and make sure that it can be done. Teradata customer support in India is very bad. This is my main complaint.

Fixing the problems that I have mentioned would make this a great tool.

I would rate this solution a six out of ten.

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
PeerSpot user
Operations Manager at a tech services company with 10,001+ employees
Real User
​We enjoy the FastLoad, TPump, and MultiLoad features
Pros and Cons
  • "​We really enjoy the FastLoad, TPump, and MultiLoad features.​"
  • "Things have started moving faster in my company, such as data retrieval happens more quickly.​"
  • "​I think the UI is not there yet. It could be improved by being more user-friendly.​"

What is our primary use case?

Its primary use is a superfast database.

How has it helped my organization?

Things have started moving faster in my company, such as data retrieval happens more quickly.

What is most valuable?

We really enjoy the FastLoad, TPump, and MultiLoad features.

What needs improvement?

I think the UI is not there yet. It could be improved by being more user-friendly.

For how long have I used the solution?

One to three years.

Which other solutions did I evaluate?

It is faster than Oracle, and that is what we need.

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