Data Warehouse Software

Top Rated Data Warehouse Software include: Amazon Redshift, SQL Data Warehouse, Oracle Data Warehouse, and SAP BW.
Other Data Warehouse Software on the TrustMap include: Snowflake, Netezza, Vertica, and Teradata Data Warehouse Appliance.
A complete list of Data Warehouse Software is available here.

TrustMaps are two-dimensional charts that compare products based on satisfaction ratings and research frequency by prospective buyers. Products must have 10 or more ratings to appear on this TrustMap, and those above the median line are considered Top Rated.

Data Warehouse Software Overview

What is Data Warehouse Software?

A data warehouse is usually a relational database, designed specifically for data analysis instead of standard transactional processing. The data warehouse acts as the conduit between operational data stores and the gaining of insight based on composite data. Slices of data from the warehouse—usually summary data for a single department like sales or finance—are stored in a “data mart” for quicker access. Data warehouses from full-stack vendors are often sold as standalone products that must be integrated with other tools.

In order for a data warehouse to be an effective decision-making tool, the first important task is to extract the data from the various data sources and load it into the warehouse where it is normalized (organized into tables while cleaning the data and removing redundancy and inconsistencies). This is achieved through a process called Extract, Transform Load (ETL). Once it has been appropriately structured it is then available for querying and analysis.

The data manipulated in an ETL process can come from any source including:

Flat files
Excel data
Application data like CRM or ERP data
Mainframe application data

Perhaps the most difficult part of the process is the “Transform” component, where not only must the data be cleansed and any duplicates removed, but the software also has to resolve data consistency issues and apply rules to consistently convert data to the appropriate form for the data warehouse ore repository. Different enterprise applications might have different naming conditions for the same entities and the ETL software is able to reconcile these different naming conventions.

Treasure Data

72 Ratings

Treasure Data manages customer data for global brands and Fortune 500 enterprises like Warner Brothers, Mattel, Subaru, AXA, Canon, LG and disruptive startups like Wish.com, Fivestars, and Zoom.

SAP Business Warehouse

72 Ratings

SAP Business Warehouse (or SAP NetWeaver Business Warehouse) is... a data warehouse for businesses.

Amazon Redshift

79 Ratings

Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.

Oracle Data Warehouse

99 Ratings

Vertica

17 Ratings

Teradata Enterprise Data Warehousing

51 Ratings

Oracle Exadata Database Machine

34 Ratings

Oracle Exadata is software and hardware engineered to support high-performance running of Oracle databases.

Actian Matrix

3 Ratings

ParAccel is an data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013).

Databricks

8 Ratings

Databricks in San Francisco offers a big data management cloud platform and cluster manager.

SQL Data Warehouse

13 Ratings

SQL Data Warehouse from Microsoft is a data warehouse-as-a-service for enterprises.

Snowflake

13 Ratings

Snowflake is the eponymous data warehouse with an emphasis on analysis, from the company in San Mateo, California.

MemSQL

7 Ratings

MemSQL is a NoSQL database offering from the company of the same name in San Francisco.

SAP HANA Express Edition

7 Ratings

SAP HANA, Express Edition is a scaled down version of the HANA product that can run on laptops and other resource-constrained hosts, such as cloud-hosted virtual machines. The product is free to use for in-memory databases up to 32GB of RAM.

IBM Netezza Data Warehouse Appliances

16 Ratings

Part of IBM PureSystems, IBM Netezza Data Warehouse Appliances is that company's big data-focused DWA offering.

Analyza

1 Ratings

Analyza is a business intelligence solution that is provided by PIT Business. The vendor provides support services in Luxembourg, Belgium, France, and other parts of Europe. Analyza allows users to: Build several indicators and dashboardsBuild ad-hoc analysis without IT knowledgeNavigate through...

VectorWise

2 Ratings

IBM dashDB

2 Ratings

IBM dashDB is a fully managed cloud data warehouse, ideal for business intelligence reporting and analytics. Use dashDB to store relational data, including special types such as geospatial data. Then analyze that data with SQL or advanced built-in analytics like Netezza predictive analytics,...