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.PNGDatabricks Unified Analytics Platform5https://dudodiprj2sv7.cloudfront.net/vendor-logos/mW/hY/DARVLBGGUT7U-180x180.JPEGVertica6https://dudodiprj2sv7.cloudfront.net/vendor-logos/qq/uK/ZTECRXT03ME3-180x180.JPEGTeradata Enterprise Data Warehousing7https://dudodiprj2sv7.cloudfront.net/vendor-logos/5l/z7/2FHZJK4K1FK3-180x180.JPEGOracle Exadata Database Machine8https://dudodiprj2sv7.cloudfront.net/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGSnowflake9https://dudodiprj2sv7.cloudfront.net/product-logos/bt/dw/2T2R5G719T12.pngActian Matrix10https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGIBM Netezza Data Warehouse Appliances11https://dudodiprj2sv7.cloudfront.net/vendor-logos/pB/Jj/SEO8QKLQWG7P-180x180.JPEGSQL Data Warehouse12https://dudodiprj2sv7.cloudfront.net/vendor-logos/tf/J4/RTX1AO2GSVNS-180x180.JPEGMemSQL13https://dudodiprj2sv7.cloudfront.net/vendor-logos/4S/WB/K4QXDHCXNHW8.pngSAP HANA Express Edition14https://dudodiprj2sv7.cloudfront.net/product-logos/F7/Kp/032VN2TB2UNT.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/pB/Jj/SEO8QKLQWG7P-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/pB/Jj/SEO8QKLQWG7P-180x180.JPEGIBM Smart Analytics System22https://dudodiprj2sv7.cloudfront.net/vendor-logos/pB/Jj/SEO8QKLQWG7P-180x180.JPEGIngres23https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGTajo24https://dudodiprj2sv7.cloudfront.net/vendor-logos/LN/4T/QCXUVWPH4BJL.pngEMC Greenplum Data Computing Appliance25https://dudodiprj2sv7.cloudfront.net/vendor-logos/xW/Gb/SGTVSU5KIT5G-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, 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)

Arm Treasure Data

73 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

73 Ratings

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

Amazon Redshift

82 Ratings

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

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.

Oracle Exadata Database Machine

35 Ratings

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

Snowflake

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

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.

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.

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

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

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

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.