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
March 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,924 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
PeerSpot user
Sr. Data Management Specialist at a computer software company with 1,001-5,000 employees
Real User
Top 10
Highly scalable and fast with historical data
Pros and Cons
  • "Teradata's best feature is its speed with historical data."
  • "Teradata's UI could be improved."

What is our primary use case?

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

What is most valuable?

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

What needs improvement?

Teradata's UI could be improved.

For how long have I used the solution?

I've been using Teradata for about four years.

What do I think about the stability of the solution?

Teradata's stability is good.

What do I think about the scalability of the solution?

Teradata's scalability is one of its best features.

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

Teradata's licensing is on the expensive side.

What other advice do I have?

I would rate Teradata 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
March 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,924 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
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
it_user689559 - PeerSpot reviewer
Senior IT Business Analyst at a comms service provider with 10,001+ employees
Vendor
Viewpoint, the detailed query logs and performance statistics are valuable features.
Pros and Cons
  • "Viewpoint, the detailed query logs and performance statistics are valuable features."
  • "The SQL Assistant is very basic. This tool can be improved for usability."

What is most valuable?

Viewpoint, the detailed query logs and performance statistics are valuable features. As a specialist for Teradata Performance, I find this data valuable for system tuning and query tuning.

How has it helped my organization?

Our enterprise data warehouse (EDW) runs on Teradata and it is the single version of truth for management decision-making and reporting.

What needs improvement?

The SQL Assistant is very basic. This tool can be improved for usability.

For how long have I used the solution?

I have used this solution for around ten years.

What do I think about the stability of the solution?

There were no stability issues.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

Technical support is good.

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

We have used Teradata since day one.

How was the initial setup?

The setup was complex, but the work was outsourced to the Teradata Professional Services.

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

Teradata is not cheap, but you get what you pay for.

A cost-benefit analysis (CBA) needs to be done by the customers so as to make sure it serves the intended purpose.

What other advice do I have?

Have a long-term vision, the ROI will not come in the short-term.

A cost-benefit analysis (CBA) needs to be done by the customers so as to make sure it serves the intended purpose.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Analytics Lead at a tech vendor with 10,001+ employees
Real User
Needs improvement in its stability, support and pricing
Pros and Cons
  • "It's very mature from a technology perspective."
  • "The solution needs improvement in its stability, support and pricing."

What is our primary use case?


What is most valuable?

It's very mature from as technology perspective.

What needs improvement?

The solution overall needs improvement in its stability, support and pricing. 

For how long have I used the solution?

I have been using Teradata for 23 years. 

What do I think about the stability of the solution?

The stability is bad. 

What do I think about the scalability of the solution?

Two clients are using the solution. 

How was the initial setup?

The initial setup is straightforward.

What other advice do I have?

Overall, I rate the solution a one out of ten. 

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