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
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 (or SAP NetWeaver Business Warehouse) is... a data warehouse for businesses.
Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.
Oracle Exadata is software and hardware engineered to support high-performance running of Oracle databases.
ParAccel is an data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013).
Databricks in San Francisco offers a big data management cloud platform and cluster manager.
SQL Data Warehouse from Microsoft is a data warehouse-as-a-service for enterprises.
Snowflake is the eponymous data warehouse with an emphasis on analysis, from the company in San Mateo, California.
MemSQL is a NoSQL database offering from the company of the same name in San Francisco.
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.
Part of IBM PureSystems, IBM Netezza Data Warehouse Appliances is that company's big data-focused DWA offering.
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 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 is that company's DWA offering.
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, since late 2013, is a legacy data warehouse brand.
The IBM Smart Analytics System provides an integrated data warehouse and analytics solution.
WX2 is the data and analytics focused data warehouse appliance solution from UK company Kognitio.