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://media.trustradius.com/product-logos/6C/b9/XR09NAFJA7EB-180x180.JPEGAmazon Redshift2https://media.trustradius.com/vendor-logos/LY/YM/1TDXH4LPI5BH-180x180.JPEGOracle Exadata Database Machine3https://media.trustradius.com/vendor-logos/e7/6G/F3JK0T3RS775-180x180.PNGSnowflake4https://media.trustradius.com/product-logos/Ir/sp/J5XIE3MICFO8-180x180.PNGSAP Business Warehouse5https://media.trustradius.com/vendor-logos/sW/OA/CZD3RG21S16S-180x180.JPEGOracle Data Warehouse6https://media.trustradius.com/vendor-logos/e7/6G/F3JK0T3RS775-180x180.PNGSAP BW/4HANA7https://media.trustradius.com/product-logos/WY/yQ/77X0XXIUUUPN-180x180.PNGVertica8https://media.trustradius.com/vendor-logos/Zi/ju/TCH0JRTW622Q-180x180.JPEGDatabricks Unified Analytics Platform9https://media.trustradius.com/vendor-logos/mW/hY/DARVLBGGUT7U-180x180.JPEGMerrill DatasiteOne10https://media.trustradius.com/vendor-logos/71/sF/WWEI8ERKPLMT-180x180.PNGTeradata Enterprise Data Warehousing11https://media.trustradius.com/vendor-logos/iI/9B/U8C6TECF7RP4-180x180.JPEGActian Matrix12https://media.trustradius.com/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGMemSQL13https://media.trustradius.com/vendor-logos/4S/WB/K4QXDHCXNHW8.pngOracle Autonomous Data Warehouse14https://media.trustradius.com/vendor-logos/e7/6G/F3JK0T3RS775-180x180.PNGPanoply15https://media.trustradius.com/product-logos/su/ND/1W6DAOKK4IT5-180x180.PNGIBM Netezza Data Warehouse Appliances16https://media.trustradius.com/vendor-logos/yf/sf/DNSXTG99HOK3-180x180.JPEGSAP Adaptive Server Enterprise17https://media.trustradius.com/product-logos/Yc/Ey/8RLX199DR1BM-180x180.JPEGStitch18https://media.trustradius.com/vendor-logos/4o/2F/KCMQTOXKAA85-180x180.JPEGWebtrekk Digital Intelligence Suite19https://media.trustradius.com/product-logos/jk/Ae/KVQAND9WPSZS-180x180.JPEGAnalyza20https://media.trustradius.com/vendor-logos/Ie/YS/HZ0JW9QA6ERU-180x180.PNGVectorWise21https://media.trustradius.com/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGSAP Data Warehouse Cloud22https://media.trustradius.com/product-logos/2N/mH/22KDTQ3X2GOI-180x180.PNGCloudera Data Platform23https://media.trustradius.com/vendor-logos/vs/zF/28EBZ7FNB71M-180x180.PNGDb2 Warehouse on Cloud24https://media.trustradius.com/product-logos/Uv/Xp/77N37PEPH17Z-180x180.PNGTeradata Data Warehouse Appliance25https://media.trustradius.com/vendor-logos/iI/9B/U8C6TECF7RP4-180x180.JPEG

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.

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 42)

Arm Treasure Data

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
98 Ratings

Arm® Treasure Data™ is designed to empower marketers with rich customer insights to drive remarkable customer experiences. Arm 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 o…

Amazon Redshift

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
136 Ratings

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

Oracle Exadata Database Machine

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
175 Ratings

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

Snowflake

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
59 Ratings

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

17 Ratings

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…

22 Ratings

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

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 well …

4 Ratings

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.

SAP® Adaptive Server® Enterprise (SAP ASE) promises to allow you to handle massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. The value proposition is to drive value with a faster, more efficient transactional system that is d…

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

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

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…

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

TrustRadius Top Rated for 2019

2019 Top Rated Data Warehouse Software

There are plenty of options out there, but here's our shortlist of the best Data Warehouse Software. 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. To qualify, a product must have 10 or more recent reviews and a trScore of 7.5 or higher, indicating above-average satisfaction for business technology. The products with the highest trScores appear first on the list. Read more about the Top Rated criteria.