Data Warehouse Software

Best Data Warehouse Software include:

Snowflake, Oracle Exadata Database Machine, and Amazon Redshift.

Data Warehouse Software TrustMap

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.

Data Warehouse Software Overview

What is Data Warehouse Software?

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.

Data Warehouse Features & Capabilities

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

Pricing Information

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.

Data Warehouse Comparison

When considering Data Warehouse options, consider the following aspects of each product offering.
  1. 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.

  2. 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.

  3. 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.

Data Warehouse Products

(1-25 of 44) Sorted by Most Reviews

Treasure Data
44 ratings
68 reviews
Top Rated
Treasure Data is designed to empower marketers with rich customer insights to drive remarkable customer experiences. Treasure Data is an enterprise-grade Customer Data Platform (CDP) that handles the complex, data-intensive needs of large teams. Dedicated to managing the entire process of building …
Amazon Redshift
116 ratings
31 reviews
Top Rated
Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.
Apache Hive
56 ratings
25 reviews
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.
57 ratings
23 reviews
Top Rated
The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data…
Google BigQuery
89 ratings
22 reviews
Top Rated
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 Exadata Database Machine
156 ratings
19 reviews
Top Rated
Oracle Exadata is software and hardware engineered to support high-performance running of Oracle databases.
Oracle Autonomous Data Warehouse
3 ratings
18 reviews
Oracle now offers their Autonomous Data Warehouse Cloud PaaS, a fully managed data warehouse available through Oracle Cloud.
SAP Business Warehouse (SAP BW), formerly SAP NetWeaver Business Warehouse
119 ratings
15 reviews
SAP Business Warehouse, or SAP BW (formerly SAP NetWeaver Business Warehouse) is SAP's legacy data warehouse solution, now superseded by SAP BW/4HANA, and the SAP Data Warehouse Cloud which was launched in 2019. SAP BW versions up to 7.4 have reached end of maintenance. SAP BW 7.5 support is extend…
Oracle Data Warehouse
200 ratings
10 reviews
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, backing up, and re…
19 ratings
7 reviews
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 include data co…
17 ratings
6 reviews
The Vertica Analytics Platform supplies enterprise data warehouses with big data analytics capabilities and modernization. Vertica is owned and supported by Micro Focus.
SAP Data Warehouse Cloud
4 ratings
5 reviews
Designed for business, SAP Data Warehouse Cloud includes pre-built templates, integration to SAP and other data sources and the power of SAP HANA. This new managed service solution will enable businesses to achieve results faster, benefit from simple cloud-based end user analytics, and have the flex…
Azure Synapse Analytics (Azure SQL Data Warehouse)
11 ratings
4 reviews
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, at scale. Azu…
Teradata Vantage - Enterprise Data Warehousing
50 ratings
4 reviews
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 delivers unlimite…
Actian Matrix
0 ratings
3 reviews
ParAccel is an data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013).
1 rating
3 reviews
Panoply is an ETL-less, smart end-to-end data management system built for the cloud. Panoply specializes as a unified ELT and Data Warehouse platform with integrated visualization capabilities and storage optimization algorithms.
3 ratings
2 reviews
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. Hundreds of data…
IBM Netezza Performance Server
16 ratings
2 reviews
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 Server for P…
Actian Avalanche
7 ratings
1 review
Actian Avalanche is a fully managed hybrid cloud data warehouse service designed from the ground up to deliver high performance and scale across all dimensions – data volume, concurrent user, and query complexity – at a fraction of the cost of alternative solutions. It is a true hybrid platform that…
Teradata Data Warehouse Appliance 2850
13 ratings
1 review
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, SUSE Linux operati…
Db2 Warehouse on Cloud
3 ratings
1 review
IBM Db2 Warehouse on Cloud is a fully managed cloud data warehouse, ideal for business intelligence reporting and analytics. Use Db2 Warehouse on Cloud to store relational data, including special types such as geospatial data. Then analyze that data with SQL or advanced built-in analytics like Nete…
Cloudera Data Platform
4 ratings
1 review
Cloudera Data Platform (CDP), launched September 2019, is designed to combine the best of Hortonworks and Cloudera technologies, to deliver the industry’s first enterprise data cloud. CDP delivers self-service analytics across hybrid and multi-cloud environments, along with sophisticated and granula…
IBM Smart Analytics System (legacy)
The IBM Smart Analytics System was an integrated data warehouse and analytics solution. It is no longer available.

Frequently Asked Questions

Are all data warehouses compatible with all data sources?

Most data warehouses include tools for integrating with different business sources, but they may not be able to integrate with all sources of data. Additionally, many data warehouses are built using specific database engines, making them easier to pull in data from some applications compared to others.

Are there any free or open source data warehouse options?

There are a few open source data warehouse tools, but many of them require cloud hosting, or include limited features. Most offer either powerful ETL features, or advanced analytics, but few include both.

Do data warehouses ensure regulatory compliance?

Some data warehouses provide higher standards for encryption security than others. Data warehouses designed for the medical field, for example, ensure that stored data is HIPAA compliant. Businesses can find information about what compliance standards are supported on vendor websites.