We performed a comparison between Amazon Redshift and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"It allows for the storage of huge amounts of data."
"The feature that we find most useful is the ability to do analytics on the fly."
"The solution is scalable. It handles different loads very well."
"The valuable features are performance, data compression, and scalability."
"This service can merge and integrate well with all databases."
"The initial setup of this solution is straightforward."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"The performance is great, we are able to query our data in one operation."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"Teradata's pretty fast."
"The solution scales well on the cloud."
"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."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"Improvement could be made in the area of streaming data."
"It would be good to see Redshift as a serverless offering."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"Amazon Redshift is a little more expensive than other products."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"Should be made available across zones, like other Multi-AZ solutions."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Data synchronization to the DR site."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"It would help to make scaling easier with a reduced cost. "
"The user interface needs to be improved."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"It needs a teaching web site with more training on third-party tools used for BI."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 24 reviews while Teradata is ranked 3rd in Data Warehouse with 21 reviews. Amazon Redshift is rated 7.8, while Teradata is rated 8.4. The top reviewer of Amazon Redshift writes "A cost-effective warehouse solution that needs to improve the access limitations". On the other hand, the top reviewer of Teradata writes "Very fast with good database control and excellent support". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Microsoft Azure Synapse Analytics, Vertica and Oracle Exadata, whereas Teradata is most compared with SQL Server, Snowflake, MySQL, Oracle Exadata and Microsoft Azure Synapse Analytics. See our Amazon Redshift vs. Teradata report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.