Best Data Warehouse Software22A Data Warehouse Appliance (DWA) is generally a pre-configured architecture specifically dedicated to big data analytics and as such emphasizes simplicity, focus, and high performance with data over general computational needs.Arm Treasure Data1https://dudodiprj2sv7.cloudfront.net/product-logos/6C/b9/XR09NAFJA7EB.JPEGSAP Business Warehouse2https://dudodiprj2sv7.cloudfront.net/vendor-logos/sW/OA/CZD3RG21S16S-180x180.JPEGAmazon Redshift3https://dudodiprj2sv7.cloudfront.net/vendor-logos/LY/YM/1TDXH4LPI5BH-180x180.JPEGOracle Data Warehouse4https://dudodiprj2sv7.cloudfront.net/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGOracle Exadata Database Machine5https://dudodiprj2sv7.cloudfront.net/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGDatabricks Unified Analytics Platform6https://dudodiprj2sv7.cloudfront.net/vendor-logos/mW/hY/DARVLBGGUT7U-180x180.JPEGVertica7https://dudodiprj2sv7.cloudfront.net/vendor-logos/Zm/IY/D5DAJSH3LPPI-180x180.GIFTeradata Enterprise Data Warehousing8https://dudodiprj2sv7.cloudfront.net/vendor-logos/5l/z7/2FHZJK4K1FK3-180x180.JPEGSnowflake9https://dudodiprj2sv7.cloudfront.net/product-logos/bt/dw/2T2R5G719T12.pngActian Matrix10https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGSAP HANA Express Edition11https://dudodiprj2sv7.cloudfront.net/product-logos/F7/Kp/032VN2TB2UNT.PNGIBM Netezza Data Warehouse Appliances12https://dudodiprj2sv7.cloudfront.net/vendor-logos/yf/sf/DNSXTG99HOK3-180x180.JPEGSQL Data Warehouse13https://dudodiprj2sv7.cloudfront.net/vendor-logos/tf/J4/RTX1AO2GSVNS-180x180.JPEGMemSQL14https://dudodiprj2sv7.cloudfront.net/vendor-logos/4S/WB/K4QXDHCXNHW8.pngStitch15https://dudodiprj2sv7.cloudfront.net/vendor-logos/4o/2F/KCMQTOXKAA85-180x180.JPEGAnalyza16https://dudodiprj2sv7.cloudfront.net/product-logos/Po/cF/K7QRNT6IJ31H.PNGVectorWise17https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGDb2 Warehouse on Cloud18https://dudodiprj2sv7.cloudfront.net/vendor-logos/yf/sf/DNSXTG99HOK3-180x180.JPEGTeradata Data Warehouse Appliance19https://dudodiprj2sv7.cloudfront.net/vendor-logos/5l/z7/2FHZJK4K1FK3-180x180.JPEGMerrill DatasiteOne20https://dudodiprj2sv7.cloudfront.net/vendor-logos/71/sF/WWEI8ERKPLMT-180x180.PNGIBM InfoSphere Warehouse21https://dudodiprj2sv7.cloudfront.net/vendor-logos/yf/sf/DNSXTG99HOK3-180x180.JPEGIBM Smart Analytics System22https://dudodiprj2sv7.cloudfront.net/vendor-logos/yf/sf/DNSXTG99HOK3-180x180.JPEGIngres23https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGPivotal Greenplum24https://dudodiprj2sv7.cloudfront.net/product-logos/NW/0Z/W55XLT2DEPSX.PNGTajo25https://dudodiprj2sv7.cloudfront.net/vendor-logos/LN/4T/QCXUVWPH4BJL.png

Data Warehouse Software

Best Data Warehouse Software

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 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 Products

Listings (1-25 of 35)

Arm Treasure Data

74 Ratings

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

SAP Business Warehouse

76 Ratings

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

Amazon Redshift

86 Ratings

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

Oracle Exadata Database Machine

156 Ratings

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

Databricks Unified Analytics Platform

10 Ratings

Databricks in San Francisco offers the Databricks Unified Analytics Platform, a data science platform and Apache Spark cluster manager.

Vertica

18 Ratings

The Vertica Analytics Platform supplies enterprise data warehouses with big data analytics capabilities and modernization. Vertica is owned and supported by Micro Focus.

Snowflake

16 Ratings

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

Actian Matrix

3 Ratings

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

SAP HANA Express Edition

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

SQL Data Warehouse

13 Ratings

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

MemSQL

7 Ratings

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

Stitch

3 Ratings

Stitch in Philadelphia offers their flagship ETL tool to developers; the company was spun off from RJMetrics after that company's acquisition by Magento, and is an independent entity.

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

Db2 Warehouse on Cloud

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, anal...

Teradata Data Warehouse Appliance

13 Ratings

Teradata data warehouse appliance is that company's DWA offering.

Merrill DatasiteOne

1 Ratings

Merrill Corporation in St Paul offers DatasiteOne, the company's virtual data room (VDR) for due diligence, investment banking, IPOs, private equity or venture capital, and other goals, featuring ease of tools (e.g. drag-and-drop files, in document text search, etc.), five minute setup) and as we...

IBM InfoSphere Warehouse

We don't have enough ratings and reviews to provide an overall score.

IBM InfoSphere Warehouse, since late 2013, is a legacy data warehouse brand.

IBM Smart Analytics System

We don't have enough ratings and reviews to provide an overall score.

The IBM Smart Analytics System provides an integrated data warehouse and analytics solution.

Ingres

We don't have enough ratings and reviews to provide an overall score.

Pivotal Greenplum

We don't have enough ratings and reviews to provide an overall score.

Pivotal Greenplum (formerly from EMC) is a massively parallel processing (MPP) data platform, based on the open source Greenplum Database. The data warehouse application is supported by Pivotal Software.

Tajo

We don't have enough ratings and reviews to provide an overall score.