We performed a comparison between AWS Lake Formation and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services."
"We use AWS Lake Formation typically for the data warehouse."
"The solution has many features that are applicable to events such as audits."
"The solution is quite good at handling analytics. It's done a good job at helping us centralize them."
"The most important advantage in using AWS Lake Formation is its ability to connect the data lake to the other technologies in AWS. This is what I advise my clients."
"I've never had any issues with scalability."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"It's very mature from a technology perspective."
"The performance is great, we are able to query our data in one operation."
"Cuts time to process huge amounts of data with efficient analytical queries."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"It falls short when it comes to more granular access control, such as cell-level or row-level entitlements which is a significant drawback for organizations that require precise control over who can access specific rows of data."
"For the end-users, it's not as user-friendly as it could be."
"The solution could make improvements around orchestration and doing some automation stuff on AWS front automation. It would be useful if we could use automation to build images and use hardened images which are CIS compliant."
"AWS Lake Formation's pricing could be cheaper."
"In our experience what could be improved are not the support, performance or monitoring, but at a managerial level, the very expensive professional services of AWS. This could be an area of improvement for them. It's too expensive to acquire their support."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Teradata's UI could be more user-friendly."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"There is some improvement required on OLTP level and some analytical function is missing."
AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. AWS Lake Formation is rated 7.6, while Teradata is rated 8.2. The top reviewer of AWS Lake Formation writes "Strategically aligning data management in a multi-cloud environment with significant reporting challenges". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". AWS Lake Formation is most compared with Snowflake, Azure Data Factory, Amazon Redshift, Microsoft Azure Synapse Analytics and BigQuery, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our AWS Lake Formation vs. Teradata report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.