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.Treasure Data1https://dudodiprj2sv7.cloudfront.net/product-logos/dW/zs/XTAWHTC4KGW1.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.PNGVertica5https://dudodiprj2sv7.cloudfront.net/vendor-logos/qq/uK/ZTECRXT03ME3-180x180.JPEGTeradata Enterprise Data Warehousing6https://dudodiprj2sv7.cloudfront.net/vendor-logos/5l/z7/2FHZJK4K1FK3-180x180.JPEGOracle Exadata Database Machine7https://dudodiprj2sv7.cloudfront.net/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGActian Matrix8https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGDatabricks9https://dudodiprj2sv7.cloudfront.net/product-logos/wT/iW/AOTJLME221KK.pngSQL Data Warehouse10https://dudodiprj2sv7.cloudfront.net/vendor-logos/tf/J4/RTX1AO2GSVNS-180x180.JPEGSnowflake11https://dudodiprj2sv7.cloudfront.net/product-logos/bt/dw/2T2R5G719T12.pngMemSQL12https://dudodiprj2sv7.cloudfront.net/vendor-logos/4S/WB/K4QXDHCXNHW8.pngSAP HANA Express Edition13https://dudodiprj2sv7.cloudfront.net/product-logos/F7/Kp/032VN2TB2UNT.PNGIBM Netezza Data Warehouse Appliances14https://dudodiprj2sv7.cloudfront.net/vendor-logos/pB/Jj/SEO8QKLQWG7P-180x180.JPEGAnalyza15https://dudodiprj2sv7.cloudfront.net/product-logos/Po/cF/K7QRNT6IJ31H.PNGVectorWise16https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGIBM dashDB17https://dudodiprj2sv7.cloudfront.net/product-logos/he/6I/9PGVKRVTCQEL.PNGTeradata Data Warehouse Appliance18https://dudodiprj2sv7.cloudfront.net/vendor-logos/5l/z7/2FHZJK4K1FK3-180x180.JPEGStitch19https://dudodiprj2sv7.cloudfront.net/vendor-logos/4o/2F/KCMQTOXKAA85-180x180.JPEGIBM InfoSphere Warehouse20https://dudodiprj2sv7.cloudfront.net/vendor-logos/pB/Jj/SEO8QKLQWG7P-180x180.JPEGIBM Smart Analytics System21https://dudodiprj2sv7.cloudfront.net/vendor-logos/pB/Jj/SEO8QKLQWG7P-180x180.JPEGIngres22https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGTajo23https://dudodiprj2sv7.cloudfront.net/vendor-logos/LN/4T/QCXUVWPH4BJL.pngEMC Greenplum Data Computing Appliance24https://dudodiprj2sv7.cloudfront.net/vendor-logos/xW/Gb/SGTVSU5KIT5G-180x180.JPEGKognitio25https://dudodiprj2sv7.cloudfront.net/product-logos/qo/b1/QH6439JXHSKK.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, 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.


Data Warehouse Products

Listings (1-25 of 32)

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

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

Teradata Data Warehouse Appliance

13 Ratings

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

Stitch

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

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.

Tajo

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

EMC Greenplum Data Computing Appliance

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

Kognitio

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.