TrustRadius
https://dudodiprj2sv7.cloudfront.net/product-logos/6B/AA/S3ZRA12SLSJZ.pngA Great Reporting Tool...But, Be Careful if Integrating with Hadoop or its EcosystemPrimarily used by BI & Analytics team in a Retail setting for reporting purposes.Good reporting tool but quite expensive and needs expert level learning.,Good Support Scalable & can work on large dataset with good performance. Uses TeraData DB Arch.,Expensive (why go with it when you have similar setup thru big data technologies like Hadoop?) No concept of Unstructured Data; everything is inline to what Oracle provides.,7,Can accommodate any type of reports on your entire dataset. Reporting performance is very good on large data sets. More bang for your buck if your data architecture landscape is around Teradata.,,Hadoop, Hortonworks Data Platform, Cloudera Data Science WorkbenchAnalytics in the Cloud without Reinventing the WheelI was recently involved in a top 500 company cloud migration to Teradata Enterprise on AWS https://aws.amazon.com/marketplace/pp/B01LW1R13T. There was a need to migrate the local company owned data center to the cloud and that included the existing production Teradata Enterprise Data Warehouse and all its dependencies. This was the largest and the first MMP in the AWS cloud whereas previously the only option for Teradata in the cloud were single node options. The biggest challenge we faced was not related to Teradata but getting the network configuration tuned to satisfy the interfacing of the existing non cloud enterprise with the cloud Teradata Enterprise. This also was critical so that we could migrate nearly 100TB of data to the cloud over a single weekend.,The Teradata Enterprise provides the best workload management bar none. There is virtually no analytic task that it can not handle. It is designed to handle mixed workloads and it shows. Tactical query related reports and applications can easily be given high priority while more processing intensive queries can be throttled and prioritized internally like a finely tuned data super highway so to prevent data traffic jams and allow the entire enterprise to be served efficiently. Designed to be easily maintained. Teradata requires very little maintenance compared to other enterprise DBs. Also, the integrated Viewpoint server provides a central view of the enterprise data-warehouse and supports servers. It also has convenient direct integration with DSA backups and supports analytic data labs that can be used to empower users. Teradata supports all the latest analytic open source languages and has advanced APIs that can be easily be leveraged within custom scripts and applications. The feature set integrated out of the box in Teradata is something few competitors can match. It also supports Map Reduce and other analytic functions natively in the database. The new Teradata Enterprise in the Cloud on AWS makes changing node configurations to handle increased workloads a matter of hours rather than weeks type process and rather than dealing with trying to reinvent the wheel with a new infant "open source" or "new" cloud database that is missing core features that mature databases like Teradata have supported for years as a customer you get the maturity as well the cutting edge cloud capabilities in a no-compromise solution. Teradata Intellicloud support provides pain-free management of the cloud environment. It handles the backups and manages EC2 instances to keep everything running smoothly. The Teradata Querygrid product provides a level of interoperability between itself and competitor and open sources data sources without having to design complex ETL.,Teradata can improve by supporting more native AWS cloud features. Currently if a node goes down the EC2 instance must be restarted. It isn't something that happens frequently but more tight integration with cloud providers like AWS and Azure will allow Teradata to offer truly dynamic scaling. Some Teradata features are oversold before they are ready for prime-time. Teradata is not unique in this but if something is sold as an integrated product stack it should really be integrated not something that requires an extensive development cycle to be integrated at a customer's expense. If something is supported it should've really be tested and QAed thoroughly before a customer touches it.,9,Moving to Teradata in the Cloud-enabled a level of agility that previously didn't exist in the organization. It also enabled a level of analytic competency that was not achievable using other options on the aggressive timeline that was required. We didn't want to settle for reinventing a wheel when we had a super tuned performance capable beast readily available in Teradata. Teradata lets us focus on our business rather than spending money and effort trying to design software or database foundations features on an open source or lower performance platform.,Pricey, but performance comes at a costTeradata was bought to consolidate and unify our data platform, leverage the performance of the Teradata Appliance to derive faster results,Very capable enterprise data warehouse platform leveraging the MPP architecture. One of the leaders in the market in MPP space today High performance data ingestion and query engine Utilities like QueryGrid allows for data federation, BTEC and FastLoad etc allow for high performance data ingestion and processing Ideally being used for ELT type data integration, with push down optimisation where complex logic is processed using the power of Teradata appliance than the ETL server,MPP architecture is becoming legacy architecture with the advent of Hadoop, MongoDB etc. Though QueryGrid and Teradata on Hadoop are available, they are add-ons to an already pricey Teradata appliance,8,Performance is well appreciated Data ingestion is faster and so is data retrieval compared to erstwhile database platform Helped with faster decision making,,Microsoft SQL Server, Oracle Exadata Database Machine, Informatica Enterprise Data Integration, MicroStrategy AnalyticsTeradata DatawarehouseIt is used for most of the IT service departments and it has majorly solved business intelligence problems for the sales and marketing team.,Teradata DB architecture. Fast query performance compared to other databases because of its unique architecture. Parallel execution of queries in DB internally. Supports a 3NF datamodel structure very nicely for business intelligence reporting. Great reporting on hyperion interactive reporting tool, BI Publisher, and OBIEE.,Cursors, procedures similar to Oracle DB. Hadoop is more preferred over teradata for big data implementation because of cost, scalability, storage etc.,9,Excellent performance on reports We were able to report on all the different large amounts of data across departments with the help of Teradata Enterprise Data Warehousing,Netezza,Cloudera Manager, Cloudera Enterprise, Hortonworks Data Platform
Unspecified
Teradata Enterprise Data Warehousing
52 Ratings
Score 8.4 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Teradata Enterprise Data Warehousing Reviews

Teradata Enterprise Data Warehousing
52 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101
Show Filters 
Hide Filters 
Filter 52 vetted Teradata Enterprise Data Warehousing reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-4 of 4)
  Vendors can't alter or remove reviews. Here's why.
Bharadwaj (Brad) Chivukula profile photo
January 16, 2018

Teradata Enterprise Data Warehousing: "A Great Reporting Tool...But, Be Careful if Integrating with Hadoop or its Ecosystem"

Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Primarily used by BI & Analytics team in a Retail setting for reporting purposes.
  • Good reporting tool but quite expensive and needs expert level learning.
  • Good Support
  • Scalable & can work on large dataset with good performance.
  • Uses TeraData DB Arch.
  • Expensive (why go with it when you have similar setup thru big data technologies like Hadoop?)
  • No concept of Unstructured Data; everything is inline to what Oracle provides.
  • Works well if you have the purse to hire Teradata specialists directly from the company and provide solution.
  • Lot of possibilities on reporting, and can accommodate any pattern/type.
  • Works with Hyperion Reporting.
Read Bharadwaj (Brad) Chivukula's full review
No photo available
March 29, 2018

Teradata Enterprise Data Warehousing Review: "Analytics in the Cloud without Reinventing the Wheel"

Score 9 out of 10
Vetted Review
Verified User
Review Source
I was recently involved in a top 500 company cloud migration to Teradata Enterprise on AWS https://aws.amazon.com/marketplace/pp/B01LW1R13T. There was a need to migrate the local company owned data center to the cloud and that included the existing production Teradata Enterprise Data Warehouse and all its dependencies. This was the largest and the first MMP in the AWS cloud whereas previously the only option for Teradata in the cloud were single node options. The biggest challenge we faced was not related to Teradata but getting the network configuration tuned to satisfy the interfacing of the existing non cloud enterprise with the cloud Teradata Enterprise. This also was critical so that we could migrate nearly 100TB of data to the cloud over a single weekend.
  • The Teradata Enterprise provides the best workload management bar none. There is virtually no analytic task that it can not handle. It is designed to handle mixed workloads and it shows. Tactical query related reports and applications can easily be given high priority while more processing intensive queries can be throttled and prioritized internally like a finely tuned data super highway so to prevent data traffic jams and allow the entire enterprise to be served efficiently.
  • Designed to be easily maintained. Teradata requires very little maintenance compared to other enterprise DBs. Also, the integrated Viewpoint server provides a central view of the enterprise data-warehouse and supports servers. It also has convenient direct integration with DSA backups and supports analytic data labs that can be used to empower users.
  • Teradata supports all the latest analytic open source languages and has advanced APIs that can be easily be leveraged within custom scripts and applications. The feature set integrated out of the box in Teradata is something few competitors can match. It also supports Map Reduce and other analytic functions natively in the database.
  • The new Teradata Enterprise in the Cloud on AWS makes changing node configurations to handle increased workloads a matter of hours rather than weeks type process and rather than dealing with trying to reinvent the wheel with a new infant "open source" or "new" cloud database that is missing core features that mature databases like Teradata have supported for years as a customer you get the maturity as well the cutting edge cloud capabilities in a no-compromise solution.
  • Teradata Intellicloud support provides pain-free management of the cloud environment. It handles the backups and manages EC2 instances to keep everything running smoothly.
  • The Teradata Querygrid product provides a level of interoperability between itself and competitor and open sources data sources without having to design complex ETL.
  • Teradata can improve by supporting more native AWS cloud features. Currently if a node goes down the EC2 instance must be restarted. It isn't something that happens frequently but more tight integration with cloud providers like AWS and Azure will allow Teradata to offer truly dynamic scaling.
  • Some Teradata features are oversold before they are ready for prime-time. Teradata is not unique in this but if something is sold as an integrated product stack it should really be integrated not something that requires an extensive development cycle to be integrated at a customer's expense. If something is supported it should've really be tested and QAed thoroughly before a customer touches it.
Teradata is the premier analytic platform. If you need to enable real-time access to multiple terabytes/petabytes of your organization's data to help you make real-time decisions in a way that translates into real dollars in sales and strengthened customer relationships then there is no better choice. Teradata is NOT an OLTP appropriate database and it may not be the best place to process all your data but as far as enabling your Analytic enterprise Teradata is always going to provide the best ROI for medium and large enterprises and now with new cloud integration even small enterprises can have the advantages of Teradata that used to be only available to the larger enterprises.
Read this authenticated review
No photo available
March 08, 2018

Teradata Enterprise Data Warehousing Review: "Pricey, but performance comes at a cost"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Teradata was bought to consolidate and unify our data platform, leverage the performance of the Teradata Appliance to derive faster results
  • Very capable enterprise data warehouse platform leveraging the MPP architecture. One of the leaders in the market in MPP space today
  • High performance data ingestion and query engine
  • Utilities like QueryGrid allows for data federation, BTEC and FastLoad etc allow for high performance data ingestion and processing
  • Ideally being used for ELT type data integration, with push down optimisation where complex logic is processed using the power of Teradata appliance than the ETL server
  • MPP architecture is becoming legacy architecture with the advent of Hadoop, MongoDB etc.
  • Though QueryGrid and Teradata on Hadoop are available, they are add-ons to an already pricey Teradata appliance
Pricey, but performance comes with price
Frequent version upgrades is a pain
Increasing storage space is not always easy as you buy a pre-built storage
Read this authenticated review
Hemant Prabhakar Patil profile photo
May 31, 2016

Teradata Enterprise Data Warehousing Review: "Teradata Datawarehouse"

Score 9 out of 10
Vetted Review
Verified User
Review Source
It is used for most of the IT service departments and it has majorly solved business intelligence problems for the sales and marketing team.
  • Teradata DB architecture.
  • Fast query performance compared to other databases because of its unique architecture.
  • Parallel execution of queries in DB internally.
  • Supports a 3NF datamodel structure very nicely for business intelligence reporting.
  • Great reporting on hyperion interactive reporting tool, BI Publisher, and OBIEE.
  • Cursors, procedures similar to Oracle DB.
  • Hadoop is more preferred over teradata for big data implementation because of cost, scalability, storage etc.
It is well suited for a large data warehouse business intelligence system but it's not suited for big data implementation where you want structured and unstructured data.
Read Hemant Prabhakar Patil's full review

Teradata Enterprise Data Warehousing Scorecard Summary

About Teradata Enterprise Data Warehousing

Categories:  Data Warehouse

Teradata Enterprise Data Warehousing Integrations