These products won a Top Rated award for having excellent customer satisfaction ratings. The list is based purely on reviews; there is no paid placement, and analyst opinions do not influence the rankings. Read more about the Top Rated criteria.
TrustMaps are two-dimensional charts that compare products based on trScore and research frequency by prospective buyers. Products must have 10 or more ratings to appear on this TrustMap.
(1-25 of 49) Sorted by Most Reviews
Treasure Data is an enterprise customer data platform (CDP) that powers the entire business to reclaim customer-centricity in the age of the digital customer. It does this by connecting all data and uniting teams and systems into one customer data platform to power purposeful engagements…
ThoughtSpot is an analytics platform that enables users to leverage natural language search and AI to find data insights and tap into the most cutting edge innovations the cloud data ecosystem has to offer. The vendor states companies can put the power of their modern data stack…
Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.
Apache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.
Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
Oracle now offers their Autonomous Data Warehouse Cloud PaaS, a fully managed data warehouse available through Oracle Cloud.
Oracle Exadata is software and hardware engineered to support high-performance running of Oracle databases.
Oracle Autonomous Data Warehouse is a cloud data warehouse service that eliminates virtually all the complexities of operating a data warehouse, securing data, and developing data-driven applications. It automates provisioning, configuring, securing, tuning, scaling, patching,…
The Cloudera Enterprise Data Hub powered by SDX is a multifunction analytics solution that supports a range of operational and analytic use cases for enterprises.
SAP BW/4HANA is a next-generation data warehouse solution. It is specifically designed to use the advanced in-memory capabilities of the SAP HANA platform. For example, SAP BW/HANA can integrate many different data sources to provide a single, logical view of all the data. This could…
Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources,…
Teradata Vantage is presented by the vendor as a powerful, modern analytics cloud platform that unifies everything—data lakes, data warehouses, analytics, and new data sources and types. Aiming to lead the way with hybrid multi-cloud environments and priced for flexibility, Vantage…
ClicData is a 100% cloud-based business intelligence platform that allows users to connect, process, blend, visualize and share data from a single place. As an automated platform, users are able to rely on the latest version of company data, to ensure users make the right decisions.…
ParAccel was a data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013). It was offered for some time as Actian Matrix, but has since been discontinued, and is superseded by Actian Avalanche.
Actian Avalanche hybrid cloud data warehouse is a fully managed service that aims to deliver high performance and scale across all dimensions – data volume, concurrent user, and query complexity – at a lower cost than alternative solutions. Avalanche has built-in self-service data…
Netezza Performance Server (NPS) is an add-on data warehouse solution available on Cloud Pak for Data System platform, built over open source and optimized for High Performance Analytics with built-in hardware acceleration. Netezza Performance Server was previously named IBM Performance…
Teradata Data Warehouse Appliance, most recent model 2850, is a fully-integrated system purpose built for data warehousing. The appliance features Teradata Database with a Teradata hardware platform with dual Intel Xeon 18-core processors, up to 12TB of memory in a single cabinet,…
Cloudera Data Platform (CDP), launched September 2019, is designed to combine the best of Hortonworks and Cloudera technologies to deliver an enterprise data cloud. CDP includes the Cloudera Data Warehouse and machine learning services as well as a Data Hub service for building custom…
The IBM Smart Analytics System was an integrated data warehouse and analytics solution. It is no longer available.
IBM InfoSphere Warehouse, since late 2013, is a legacy data warehouse brand.
A data warehouse is a database designed for data analysis instead of standard transactional processing. A data warehouse acts as a conduit between operational data stores and supports analytics on the composite data. Slices of data from the warehouse—e.g. summary data for a single department to use, like sales or finance—are stored in a “data mart” for quick access.
In order for a data warehouse to support decision-making effectively, data extracted from various data sources and loaded into the warehouse is normalized. It can be organized into tables, cleaned of redundancy and transformed for consistency. The process by which this happens is called Extract, Transform, and Load (ETL). Once appropriately structured data is made available for querying and analysis.
To support analyses data warehouses provide the following capabilities:
Associated input, extract, and data management tools for preparation
Extract from a multitude of source file types (flat files, excel, application data, etc.)
May load & normalize structured, semi-structured, or unstructured data
Data transformation (cleansing, deduplication, consistency)
Data reconciliation for various naming conventions
Native & autonomous storage and processing optimization
Provide a 360 view of all enterprise data
Multiple deployment options (private or public cloud, on-premise, hybrid cloud)
Available as-a-service (automated infrastructure management)
Integrated machine-learning algorithms, AI
Access controlled data sharing, data mart
Deploy virtualized data warehouse for extra security, access control
In-built data encryption for high-security needs
Data warehouses from full-stack vendors are often sold as standalone products that must be integrated with other tools. Many data warehouses can be deployed and tested with ease under a free trial for 30 or 60 days. Vendors compete on performance but also pricing. Many popular data warehouses feature on-demand pricing, based on (for instance) compute per second. Alternately, some vendors offer a reduction in on-demand pricing for annual or multi-year commitments.
Integrations: Data warehouses are built to store and analyze data from different sources. When selecting a data warehouse, be sure to select one that has built-in connectors for the sources you need to pull in data from, or supports the building of custom integrations.
Performance: Some data warehouses support extremely fast performance, with some able to process tens of trillions of tables in a single day. With high performance usually comes a higher cost, though, so consider how much data analysis and manipulation you expect to perform in a day and choose a solution that meets those needs but isn’t over the top.
Stability: Many data warehouses claim to achieve near 100% uptime, but a common complaint users list in data warehouse reviews is lack of stability. Be sure to choose a data warehouse with high stability, especially if your business is highly data driven.
