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.Ingres1https://media.trustradius.com/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGPivotal Greenplum2https://media.trustradius.com/product-logos/00/0u/W55XLT2DEPSX-180x180.PNGTajo3https://media.trustradius.com/vendor-logos/LN/4T/QCXUVWPH4BJL.pngKognitio4https://media.trustradius.com/product-logos/De/RS/QH6439JXHSKK-180x180.JPEGSAND5https://media.trustradius.com/product-logos/Xm/hE/WBA445VRHCCG.jpegTIBCO Live Datamart6https://media.trustradius.com/vendor-logos/kf/kH/RMNIMTW93FUN-180x180.PNGCertica Data Connect7https://media.trustradius.com/vendor-logos/OM/A5/V3ZH3EFE801D-180x180.JPEGIBM Db2 Warehouse8https://media.trustradius.com/vendor-logos/yf/sf/DNSXTG99HOK3-180x180.JPEGOracle Database Exadata Cloud Service9https://media.trustradius.com/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGOracle Database Exadata Express Cloud Service10https://media.trustradius.com/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGIBM Integrated Analytics System11https://media.trustradius.com/vendor-logos/yf/sf/DNSXTG99HOK3-180x180.JPEGWhereScape Data Vault Express12https://media.trustradius.com/vendor-logos/n4/8N/4LL3FHRDEPNZ-180x180.PNGSAP Data Warehouse Cloud13https://media.trustradius.com/product-logos/2N/mH/22KDTQ3X2GOI-180x180.PNGAlibaba Cloud MaxCompute14https://media.trustradius.com/vendor-logos/Xn/nS/SAWGAP5SL3HE-180x180.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.

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 (26-39 of 39)

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

Actian Corporation enables organizations to transform Big Data into Business Value with data management solutions to transact, analyze, and take automated action across their business operations. Actian is the first to unveil a cloud development platform for building Action Apps, lightweight co...

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.

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

The Apache Software Foundation provides support for the Apache community of open-source software projects. The Apache projects are characterized by a collaborative, consensus based development process, an open and pragmatic software license, and a desire to create high quality software that leads...

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

WX2 is the data and analytics focused data warehouse appliance solution from UK company Kognitio.

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

SAND, from Sand Technology in Quebec, is an big data and analytics focused software based data warehouse solution.

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

Certica Solutions offers Data Connect, a hosted, fully-managed and supported operational data store based on the open-source Ed-Fi technology and data standard. Designed for school districts, Data Connect is a turnkey, productized ODS which supports quick adoption and avoids resource-intensive an...

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

IBM is a global technology and innovation company headquartered in Armonk, NY. It is one of the largest technology and consulting employers in the world, with approximately 427,000 employees serving clients in 170 countries. IBM offers a wide range of technology and consulting services; a broad ...

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

The IBM Integrated Analytics System is a data warehouse built for data science which combines the capabilities of PureData System and Netezza. It comprises a high-performance hardware platform and optimized database query engine software that work together to support various data analysis and bus...

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

One of the world's leading providers of business software, SAP delivers products and services which help accelerate business innovation for its customers. The vendor believes that doing so will unleash growth and create significant new value – for their customers, SAP, and ultimately, entire indu...

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

Alibaba Cloud MaxCompute (previously known as ODPS) is a general purpose, fully managed, multi-tenancy data processing platform for large-scale data warehousing. MaxCompute supports various data importing solutions and distributed computing models, enabling users to effectively query massive data...