Excellent MPP-Teradata
We have spin up 6 node enterprise machine using cloud formation template for POC, Up and running in less than 30 minutes and once the security group is updated for port 1025 then we are all set to go, Excellent performance , Works as onsite database after updating TCP settings.
Challenge is with documentation on adding amazon to tays website for support, We need twice the space as fall back is enabled by default, Block level compression is enabled , This is needed to reduce io on database
Over all this is quick and easy for POC or DR system, For long term or replacing onsite solution we need to use ICAWS services.
It was a very good experience and I liked the product very much
What do you like best about the product?
The scalability and ability to resolve complex database queries with no impact on performance are the best features
What do you dislike about the product?
The UI of this tool can be improved a bit and even the admin console of this tool can have a better user interface
What problems is the product solving and how is that benefiting you?
Solved multiple complex queries and data storage issues with this tool
Recommendations to others considering the product:
More forums to discuss issues and ideas on
Good Database
What do you like best about the product?
Teradata is a solid performance DB and it's easy to fetch and append the data in the DB. Addition of rows of data and importing from data sources is easy.
What do you dislike about the product?
The cost of implementation can be higher at time as compared to other DBs in the market.
What problems is the product solving and how is that benefiting you?
Great database with performance and ease of appending data
Teradata Review
What do you like best about the product?
Teradata have designed a DW database for fast loading of huge data volumes and fast SQL querying.
What do you dislike about the product?
It is not suitable for small transaction OLTP databases.
What problems is the product solving and how is that benefiting you?
The Teradata Database easily and efficiently handles complex data requirements and simplifies management of the data warehouse environment.
it's an opensource distributed SQL query engine!!
What do you like best about the product?
we can run analytical query with the data sources of all size and all types , so we can use it in highly scale able systems for analytics , it's easy to integrate it with your older databases , it also provides support for java language , it provides type-1 driver for jdbc(java database connectivity) too.
What do you dislike about the product?
it provides type-1 driver of jdbc which very slow in performance, Quality Of support is not good , pricing is very high!!
What problems is the product solving and how is that benefiting you?
we use it with java for analytical queries with different kind of data sources Amazon S3 , MySQL etc.
Recommendations to others considering the product:
Just try get your hands dirty on it , it's a highly scale able and easy to use Query engine!!
Teradata SQL product review
What do you like best about the product?
A) explorer Tree
B) Query Builder
C) options available under “Tools”
What do you dislike about the product?
String to date conversions can be improved in teradata
What problems is the product solving and how is that benefiting you?
Number of rows in table with 8 billions rows in TD is done in just few seconds with low_profile and low_account rights.
Easy to use Tool for querying large data from multiple databases
What do you like best about the product?
Connect to multiple databases and the answerset output
What do you dislike about the product?
No SQL so not as fluent as Microsoft Sql
What problems is the product solving and how is that benefiting you?
Just querying data and joining across multiple database makes it easier to get solid datasets
Recommendations to others considering the product:
Great tool to use for Big Data. The Answerset is very helpful for formatting your data before exporting to excel or similar tool. However it take some time to get familiar with if you are used to other tools such as Sql Server Management Studio.
Teradata Geek
What do you like best about the product?
It allows mass of structured data to be queried with great speed
What do you dislike about the product?
Inability to connect with hadoop platform
What problems is the product solving and how is that benefiting you?
Cross channel customer journey analytics. Allows me to include all data elements i need in order to come up with insights
Helpful storage database
What do you like best about the product?
It is great that it is easy to use and maintains all the data I need in one place and can be easily extracted with queries.
What do you dislike about the product?
It is a large operating system so sometimes it will take a while to process my function.
What problems is the product solving and how is that benefiting you?
It has helped my company store large data sets in one place without slowing down our servers.
Great product
What do you like best about the product?
Best in handling large volume of data anywhere
What do you dislike about the product?
nothing..............................................
What problems is the product solving and how is that benefiting you?
Healthcare