PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias.
Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why.
You can read user reviews for the Top 5 Data Warehouse Tools to help you decide which solution is best for you.
Users compare and give feedback on Data Warehouse Tools that they’ve used — based on product reviews, ratings, and comparisons.
#1 Snowflake
Snowflake was ranked as PeerSpot’s #1 Data Warehouse Tool of 2021. Our users give Snowflake an average rating of 8 out of 10.
Sreenivasan R., Director -Data Architecture and Engineering at Decision Minds, explains why he gives the solution a 4 out of 5 star rating, stating, "Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."
Another PeerSpot reviewer, a Solution Architect at a wholesaler/distributor says, "The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff.”
Another reviewer, a director of business operations at a logistics company explains, “The query and load speed is phenomenal.”
#2 Oracle Exadata
Oracle Exadata was ranked as PeerSpot’s #2 Data Warehouse Tool of 2021. Our users give Oracle Exadata an average rating of 8 out of 10.
Adriano S., IT System Integrator at a financial services firm, says, "Oracle Exadata's performance is one of its best features. We are very satisfied with it. He goes on to say, the solution is “High performing and has a reliable work environment.”
Rodolfo P., SubDirector of Project Management at a comms service provider, mentions, “The data replication is very good, the solution offers a good data warehouse, and it allows us to avoid conflict with the transactional databases.”
A Deputy CEO, CIO at an insurance company comments, “The most valuable part of the product is performance enhancement.”
In addition, reviewer Radu B., IT Consultant at Trend Import-Export, explains that the solution offers “Excellent storage cell capabilities and intelligence with great speed.”
#3 Vertica
Vertica was ranked as PeerSpot’s #3 Data Warehouse Tool of 2021. Our users give Vertica an average rating of 10 out of 10.
Sean O., Senior Database Architect at a real estate/law firm, expresses, "I think the most valuable thing about the product is the speed and resilience. I would say the strong, well-featured SQL engine with many built-in features — including machine-learning — is also a strong point."
PeerSpot user Jelson G., Creator and Manager of Intelligent Water Loss Management Models at Qintess, says, "The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
A Director - Big Data, IoT and Analytics at a tech services company exclaims that he likes Vertica for multiple reasons, stating that it has several appealing features including, “It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
#4 Teradata
Teradata was ranked as PeerSpot’s #4 Data Warehouse Tool of 2021. Our users give Teradata an average rating of 8 out of 10.
Khurram A., Solution Sales and Lead Information at TechAccess Asia Distribution, says, “Performance-wise, Teradata beats everything. The flexibility in design is very good. When you want to tune it, it is very easy to do. I have worked a lot as a DB and I know that when there is a query that is stuck for hours, and you want to tune it, the task is quite easy. You can use the indexes and architecture, and exploit the power of Teradata.”
A Data Architect, Section Head at an energy/utilities company comments, "It has good data warehousing, is scalable, and offers good functionality.”
A Managing Director at a tech services company mentions, "Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
#5 Apache Hadoop
Apache Hadoop was ranked as PeerSpot’s #5 Data Warehouse Tool of 2021. Our users give Apache Hadoop an average rating of 8 out of 10.
A Vice President - Finance & IT at a consumer goods company shares, "The solution is easy to expand. We haven't seen any issues with it in that sense. We've added 10 servers, and we've added two nodes. We've been expanding since we started using it since we started out so small. Companies that need to scale shouldn't have a problem doing so."
Donghan K., e-Business Department Professor at MANU MEDITEC, states, "We selected Apache Hadoop because it is not dependent on third-party vendors."
In addition, a Founder & CTO at a tech services company expresses what he likes about the product, commenting that it is able to “Process large data sets across clusters of computers.” He also says, "Hadoop is designed to be scalable, so I don't think that it has limitations in regards to scalability."
Another reviewer, a Technical Lead at a government, mentions the three reasons he likes the solution: “The distributed processing is excellent on the solution, Spark is very good. The performance is pretty good.”