Teradata Vantage Enterprise (DIY)
Teradata | 17.20.03.20Linux/Unix, Other SUSE SLES 12 SP3 TDC - 64-bit Amazon Machine Image (AMI)
External reviews
External reviews are not included in the AWS star rating for the product.
Teradata helps me to access research data
What do you like best about the product?
Teradata helps me to store and access research data that is generated by a third party vendor. We can easily map this data back to our own customer database using a key field.
What do you dislike about the product?
Difficult to explain to others in the marketing and research organziations, but this is a function of any relational database, not the fault of this product.
What problems is the product solving and how is that benefiting you?
Ability to take ownership and control of our data.
Recommendations to others considering the product:
Suits my needs as a technical market research user.
- Leave a Comment |
- Mark review as helpful
Up and running in under an hour...
...just as promised by Teradata CTO Stephen Brobst. Woo-hoo!!!By using mostly default settings you should be up and running without too much trouble. You will have to choose/provide the following:>- AWS region - number of nodes required (1-32) - system name & DBC password - EC2 instance type & storage It will be necessary to configure a separate ETL server (EC2 instance) running Teradata Tools Utilities (TTU) so you can run things like TPT, Arc, Fastload, BTEQ etc. Desktop access is straightforward via Visual Studio or SQL Assistant ('Queryman'). This is v15.1 of Teradata's Enterprise edition which contains good stuff like TASM, columnar & temporal. The ability to perform backup/restore via S3 is a great benefit. A big 'well done' to Teradata and Amazon :-)
Highly Scalable with massive parallel processing
What do you like best about the product?
Teradata is highly scalable database with massive parallel processing capability. Teradata has shared nothing architecture providing high level data protection. Ad hoc requests are processed across multiple AMPS and well suited for datawarehousing applications.
What do you dislike about the product?
Teradata database license and hardware is expensive. Not suitable for OLTP system. Partitioned columns has to be part of Primary Index.
What problems is the product solving and how is that benefiting you?
Data warehousing solutions for big data volume.
Recommendations to others considering the product:
Highly recommended for data warehousing application with big data volume.
Data "Power" house
What do you like best about the product?
> Teradata is one of the most reliable RDBMS platforms available in the market
> Teradata is a power house when it comes to hosting a large data warehouse with greater storage and faster processing power
> Importing and exporting data is super easy with the teradata utilities
> Teradata has a strong admin setup which helps keep your data safe using a sound layer of access control
> Teradata is a power house when it comes to hosting a large data warehouse with greater storage and faster processing power
> Importing and exporting data is super easy with the teradata utilities
> Teradata has a strong admin setup which helps keep your data safe using a sound layer of access control
What do you dislike about the product?
> Teradata can get tangled up in multiple queries running simultaneously and result in a much delayed processing
> I think the UI is still backdated and desperately needs a next gen look and feel
> I think the UI is still backdated and desperately needs a next gen look and feel
What problems is the product solving and how is that benefiting you?
> We have a large data warehouse that has been performing great for the past 4 years
> It serves as our organization's data back bone
> We have been able to use teradata to fuel our tableau data extracts and thus use it for data analysis
> It serves as our organization's data back bone
> We have been able to use teradata to fuel our tableau data extracts and thus use it for data analysis
Recommendations to others considering the product:
> You should purchase teradata if you are looking for stability, scalability and reliability.
Teradata
What do you like best about the product?
Excellent as this IS Tools Specialized data storage and business analytics tools
What do you dislike about the product?
all ok .. nothing I dislike this app because apart from all motor has a relational database oriented processing large volumes of data
What problems is the product solving and how is that benefiting you?
many benefits as it helps me to process large catidad of information contained in the databases of my company
Recommendations to others considering the product:
100 % recommended to all my colleagues and friends who want a fast tool when managing their databases
Easy use software!
What do you like best about the product?
Wow! There are so many things.
-> I guess I can start with MPP architecture. Yes, of course other database shave caught up to Teradata with that regard.
-> easy syntax. The syntax of Teradata is clean and pure. It is not as complicated as SQL Server or Oracle.
-> Used extensively for Datawarehousing and Business Intelligence Applications
-> Primary and Secondary Index for Data Storage and Data Retreival
-> Full table scanning is a real possibility in this table, without taking much time.
-> Fastload, Multiload capablities couples with t-pump for near real time operations.
-> I guess I can start with MPP architecture. Yes, of course other database shave caught up to Teradata with that regard.
-> easy syntax. The syntax of Teradata is clean and pure. It is not as complicated as SQL Server or Oracle.
-> Used extensively for Datawarehousing and Business Intelligence Applications
-> Primary and Secondary Index for Data Storage and Data Retreival
-> Full table scanning is a real possibility in this table, without taking much time.
-> Fastload, Multiload capablities couples with t-pump for near real time operations.
What do you dislike about the product?
Having worked on this database for quite a few years, there is very little that I do not like about this product.
-> The fast load and multiload are currently a set of scripts. If this can be somehow made into a GUI that can enable easier load of data (like the fastload and multiload supported expressions in other ETL tools) it could be useful.
-> May be if at all there was anything to be worked on (like 1/10 chances if any changes would be made), may be the GUI (the visuals) could be made a little more appealing.
-> The fast load and multiload are currently a set of scripts. If this can be somehow made into a GUI that can enable easier load of data (like the fastload and multiload supported expressions in other ETL tools) it could be useful.
-> May be if at all there was anything to be worked on (like 1/10 chances if any changes would be made), may be the GUI (the visuals) could be made a little more appealing.
What problems is the product solving and how is that benefiting you?
I have worked on more than a couple of projects dealing with Teradata Database. The best of the implementations was as a Data Driven Decision making application.
Benefits
-> Can load multiple sources of data
-> Unlike SQL Server or Oracle, there was no need to write PL/SQL. SQL DML was sufficient to suffice the requirement.
Benefits
-> Can load multiple sources of data
-> Unlike SQL Server or Oracle, there was no need to write PL/SQL. SQL DML was sufficient to suffice the requirement.
Recommendations to others considering the product:
Great Product. Depends on the application to be used. If the company needs massive data to be queries and reported on then go for Teradata. If the data volume is not too high this could be a costly expense.
Useful But Not for Amateur Users
What do you like best about the product?
The error messages give you obvious feedback on lines that need to be changed in order to make your query run.
What do you dislike about the product?
This is a heavy manual use application. There are no wizards that walk you through selecting data elements from various tables. You have to know exactly what you need and where it is sourced from in order to write an efficient query.
What problems is the product solving and how is that benefiting you?
It is helpful for pulling data quickly to do on-the-spot trending and pull dollar figures associated with certain criteria.
Recommendations to others considering the product:
I recommend purchasing a supplemental software that is more of a plug-and-play or wizard based application, as it may be more user friendly than working with Teradata directly.
Strong and powerful database for data analysis
What do you like best about the product?
I have used lot many database softwares and Teradata is one of them. This product is also referred to as a "data warehouse system".
I like working with teradata as it provides strong technology solution towards industry data models,data mart consolidation, warehouse migration,hybrid cloud.. and many other features. So much diversified and fits for small and big corporation.
I like working with teradata as it provides strong technology solution towards industry data models,data mart consolidation, warehouse migration,hybrid cloud.. and many other features. So much diversified and fits for small and big corporation.
What do you dislike about the product?
I so far enjoyed working with this system. I did not find much negative points but listing some here which I faced while working with it:
1. The names of Teradata columns cannot exceed 30 characters.
2. When writing to Teradata, the InfoSphere DataStage column definitions should not contain fields of the following types like:
BigInt (int64)
Unsigned integer of any size
String, fixed- or variable-length, longer than 32 KB
Raw, fixed- or variable-length, longer than 32 KB
vectors
1. The names of Teradata columns cannot exceed 30 characters.
2. When writing to Teradata, the InfoSphere DataStage column definitions should not contain fields of the following types like:
BigInt (int64)
Unsigned integer of any size
String, fixed- or variable-length, longer than 32 KB
Raw, fixed- or variable-length, longer than 32 KB
vectors
What problems is the product solving and how is that benefiting you?
Get a 360-degree view of customer characteristics, with discovery from multiple new sources: social media, sensors in products, web site,customer purchase and phone interaction data.
Used teradata for data analysis and reporting to. Currently using it to analysis company sales and demand report.
Used teradata for data analysis and reporting to. Currently using it to analysis company sales and demand report.
Best data warehouse system present
What do you like best about the product?
Terracotta helps store enormous amounts of data smoothly and access them remotely without much hassles. We can even choose which set of users need access to what amounts of data.
What do you dislike about the product?
Not friendly for data deep diving and in-depth big data analytics. Alternatives like Hadoop are much cheaper.
What problems is the product solving and how is that benefiting you?
We were facing issues in smoothly reporting the enormous amount of data generated by our users on a day-to-day basis. With Teradata, we are able to maintain our dashboards up-to-date across various categories and functions.
Recommendations to others considering the product:
Big data stored and read easily - go for it.
Big data simplified - Teradata
What do you like best about the product?
Teradata is the tool to use when you have very huge databases to query. We were handling the largest retail data in the world and were facing issues in querying from this data. With teradata, we could query in SQL and get tome to time reports.
One more important thing is the data is well indexed which makes querying much faster.
One more important thing is the data is well indexed which makes querying much faster.
What do you dislike about the product?
One major lacking is not being able to build complex models without having to query a lot. Most other systems started having this feature, Teradata needs to improve in this aspect. Also, small organisations cannot afford something like this - only those with deep pockets where querying TBs of data makes business impact, will have a positive impact.
What problems is the product solving and how is that benefiting you?
We are a bit retailer, with multiple stores across various geographies. To track metrics for this kind of data could not have been possible if not for teradata.
Recommendations to others considering the product:
Definitely a go for companies wanting to make sense out of their of big data,
showing 301 - 310