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 usage
What do you like best about the product?
One of the best databases I have used and helps greatly
What do you dislike about the product?
Nothing in particular it is very user friendly
What problems is the product solving and how is that benefiting you?
Business continuity
- Leave a Comment |
- Mark review as helpful
Clunky and awful
What do you like best about the product?
What do I like best about Teradata? Not much. Seems like it was made by a kid in a garage somewhere. I hope we don't pay for this.
What do you dislike about the product?
What do I dislike about Teradata? Everything. Not much. Seems like it was made by a kid in a garage somewhere. I hope we don't pay for this.
What problems is the product solving and how is that benefiting you?
The business problem we're solving here is looking like we're actually busy doing work because otherwise not much else is getting done on this system.
Recommendations to others considering the product:
don't use it
The best Relational Database Ever
What do you like best about the product?
Performance, Muti-process, Handling huge volume of data effectively. Ease of use.
What do you dislike about the product?
Does not support Non-ANSI SQL statements in stage generated SQL statements.Does not support byte data types. Other than this we don't need anything to dislike.
What problems is the product solving and how is that benefiting you?
Extract Transform and Load. Bteq queries, fastload,fastexport
One size fits all
What do you like best about the product?
Data processing, really helpful when you have to troubleshoot an error because it provides great diagnostic information, Parllelism
What do you dislike about the product?
The client tools, weird/lame installation process on windows, table mapping features
What problems is the product solving and how is that benefiting you?
To store and retrieve our huge traffic history data. Teradata is helping us to move the real material across US with efficiency
Recommendations to others considering the product:
Big data equals ease in Teradata. Teradata's connectivity capabilities to other DB systems is a big plus. Implementation with JAVA was very easy. The only thing with Teradata is you should have clear picture about what you want to do with Teradata because if you don't scale it right it will be like they say, it will be killing a fly with an atom bomb.
Teradata Databse
What do you like best about the product?
Great place to warehouse data, create new tables, manipulate current tables and extract to Excel for additional analysis.
What do you dislike about the product?
Syntax differs from basic SQL, no unified help function to quickly correct mistakes.
What problems is the product solving and how is that benefiting you?
Lots of data analysis from predictive models to specific adhoc questions for the business on commercial sets of data.
Great tool for learning to optimize queries
What do you like best about the product?
I'm an end user of Teradata's query system, who was granted access to Viewpoint in order to gain a better understanding of how my queries were impacting the system and understand how many resources I was using when running certain codes. I was able to optimize my codes to run in under a second vs 15 minutes or longer before. It also allowed me to know when to not run a code due to the system being overtaxed by other users - I no longer was sitting there waiting for a code to run, not knowing if it was an issue with my code, the table(s) being accessed, or due to other users taking up the resources.
What do you dislike about the product?
No complaints! It gave me exactly what I needed - It even has smiley/frowny faces to tell you the health of the system at a glance!
What problems is the product solving and how is that benefiting you?
Fixed my codes to run more efficiently and was better able to schedule when to run codes since I knew when the system was being overtaxed.
Teradata Dataware house
What do you like best about the product?
Teradata is super fast when it comes to accessing data. It is scalable linearly so adding hardware is relatively easy. It does parallel processing and data is stored in different amps which enables fast reads. It also has a shared-nothing architecture and is highly fault tolerant. It Supports ETL efficiently and has jdbc and odbc connections to leverage data transfer from different platforms.
What do you dislike about the product?
It's not very beneficial for small OLTP databases. And if the primary index is not defined properly then it's much slower to access the data. The licensing is super expensive hence not suitable for smaller enterprises. It is not open source either.
What problems is the product solving and how is that benefiting you?
Solving data science problems
Recommendations to others considering the product:
This is a great product if you are looking for a managed solution.
Good relational database
What do you like best about the product?
It take very less time to execute queries
What do you dislike about the product?
It’s cost, the database is very expensive
What problems is the product solving and how is that benefiting you?
It’s throughput is fast
Good
What do you like best about the product?
It's flexibility and integration of massive data. It provides text, path and statistics within the same syntax.
What do you dislike about the product?
Sql finds this tool complicated and takes longer to familiarize
What problems is the product solving and how is that benefiting you?
Rather than move data out of Hadoop into an analytic server, users can eliminate costs, delays and security risks associated with data movement and accelerate the process which I believe is the most important asoect if this tool
It helps us with connectivity and making sure the data is secure
We have all our workloads on AWS.
How has it helped my organization?
Having Teradata in AWS:
* Helps us with connectivity.
* Making sure the data is secure.
* Reduces the hops.
* Helps us more with real-time data.
We had few reports which were taking more than 45 minutes. Then, with Teradata, we received results within minutes, and a few under a minute. We thought that something went wrong, and we hadn't done the work properly, but we saw the exact same results on both. So, our end users were pretty happy.
What is most valuable?
It is quick, secure, and has less hassles because we don't have to involve our networking team, infrastructure, etc. It is very easy to deploy and make market ready.
What needs improvement?
Teradata wants to come out of the hardware business and to run its own cloud on other public clouds. I think that is a great way to go. However, there are challenges to doing this. There are multiple layers of security and caching. E.g., if you have a lot of compute or a caching that will offload a lot of compute activity because it's already there, it will save its cycles for something which needs to be done. This way, you are offloading your compute, so you can go with a lesser capacity than a higher capacity. That is what this appliance does. If they are moving off of the appliance, I am curious to see if their software will withstand the change, or will Teradata still run but need a bigger box?
I would like more security and speed. These days, everyone is not just moving to cloud, but they are moving to clout. In a multi-cloud environment, you have to be cognizant of data transfer, bandwidth, and egress charges, not just from a performance and scalability point of view, but also how to keep costs low.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
We haven't had any outages in one and a half years. That is a good statement.
What do I think about the scalability of the solution?
I have not heard anyone complain about performance.
How is customer service and technical support?
The technical support is pretty good. The response rate is good.
Which solutions did we use previously?
We had a bunch of legacy warehouses, which we wanted to consolidate, as well as stay up-to-date with warehousing options. This is why we moved into Teradata.
How was the initial setup?
The integration and configuration were seamless for us.
We have multiple sources of data, so Teradata has a lot of connectors which pulls all our data from different workloads. The integration works really well.
What about the implementation team?
We had help with the integration and configuration.
What was our ROI?
When your customer is happy, dollars and cents sort of blur. Our return on investment would be customer satisfaction, which I think is priceless.
What's my experience with pricing, setup cost, and licensing?
We had a lot of parties involved when purchasing from the AWS Marketplace. They are very flexible and aggressive in trying to close the deal. They are good at what they have to offer and listening to the customer. It's a two-way street.
In this day and age, we want to get things done quickly. So, we go to the AWS Marketplace.
Also, we have a consistent experience with Teradata usage on its cloud, so we already know the product.
For what Teradata has to offer, their price is comparable to its competitors.
Which other solutions did I evaluate?
We evaluated Redis and Teredata, doing PoCs with both. We had more support from Teradata to start with, and we were new to both. We were not in a situation to tell which one was good, because both were new to us. We just had more support from Teradata to help us see the results on what we are looking for.
What other advice do I have?
Do your homework before you make a decision. Everyone is different; every shop is different. That is what makes it fun to be in IT.
When you look for a solution, you will uncover many advantages. All those hidden things which are not clear initially when you do a cost analysis. A cost analysis is something that you have to do from the get-go, but it also has to be an ongoing process. Your workloads change, requirements change, everything changes, so it has to be a constant feedback.
showing 181 - 190