The AI-ready data warehouse for operational analytics

Benefits

Save time and resources

hour glass

Deploy a pre-configured data warehouse in minutes on your supported infrastructure of choice with elastic scaling for easier updates and upgrades.

Extract fresh insights faster

magnifying glass and a sheet of paper

Apply in-database analytics where the data resides, allowing enterprise AI to operate faster and more efficiently.

Gain flexible deployment

circle with two curved lines connecting the sides

Write your application once and move that workload to the right location, whether public cloud, private cloud or on premises — with minimal or no changes required.

Customer stories

Nedbank Group

globe with a piece of paper currency and a line graph

Nedbank Group

This South African bank turned to IBM Db2® Warehouse on Cloud to meet the increasing demand for analytics across its divisions and keep storage costs under control.

KONE Corp.

person in an elevator

KONE Corp.

This elevator manufacturer stores sensor data on Db2 Warehouse on Cloud to help predict, identify and resolve issues, even before equipment breaks.

Constance Hotels, Resorts & Golf

hotel buildings

Constance Hotels, Resorts & Golf

This company connects business data from its nine island resorts for unified insight using a cloud data warehouse and analytics architecture.

City Furniture

cloud with rain

City Furniture

This retailer ensures that business-critical computer operations and customer data are protected against hurricane disruptions using Db2 Warehouse on Cloud.

Valor Holdings

bank building

Valor Holdings

This Japanese supermarket chain moved a database of over 10 billion transactions to Db2 Warehouse on Cloud, enabling high-performance analytics to support operations.

Features

Fast and simple hybrid data warehousing

Fast query processing

Apache Spark and IBM BLU® Acceleration in-memory SQL columnar processing with an MPP cluster architecture speed up complex queries and predictive model building, testing and deployment.

In-memory data processing

IBM BLU Acceleration eliminates the need for entire data sets and decompression in-memory. Includes pre-fetching of data and data skipping.

Automatic schema generation, data loading

In a few clicks, unstructured data — such as that from Twitter or geospatial programs — is automatically transformed into a structured format for analysis.

Common SQL engine

A common SQL analytics engine works across public and private clouds and on-premises data warehouses, so you can move workloads to the right location easily.

Compatibility with Db2, PDA and Oracle

Supported Db2 drivers and compatibility with Db2, PDA and Oracle accelerate migration. Deploy as a stand-alone cloud data warehouse, or integrate with an on-premises data warehouse.

Embedded Apache Spark engine

Db2 Warehouse and Spark deliver higher performance than Spark alone, providing a better data exploration experience.

Product images

Console dashboard

Screen shot showing number of hardware issues, software issues, database alerts, and storage usage and the database time breakdown

Console dashboard

The console dashboard gives you a view of hardware and software issues, database alerts, storage usage and a database time breakdown.

Monitoring overview

Screen shot showing the time breakdown of SQL execution, input/output, lock waits and other processing

Monitoring overview

The monitoring overview shows the database time breakdown in more detail, including SQL execution, input/output, lock waits and other processing.

Spark analytics

Screen shot showing the Spark analytics choices, such as using Jupyter Notebooks, developing Spark application code and running Spark applications

Spark analytics

Db2 Warehouse offers multiple choices for Sparks analytics, including Juypter Notebooks, developing application code and running Spark applications.

R analytics

Screen shot showing R analytics choices, such as writing R scripts, developing applications that run R code and R packages

R analytics

RStudio is integrated so you can develop applications that run R code and R packages.

Resources

Training and tutorials

Getting started with Db2 Warehouse on Cloud

Follow this tutorial to get up and running in 5 minutes.

Db2 Warehouse interactive product tour

Take a short tour of Db2 Warehouse, including the web interface. Create and explore a new table within an existing schema.

Db2 Warehouse on Cloud guided product tour

Learn how to set up cloud object storage, create tables and insert data in this interactive tour.

Documentation & support

Documentation

Find answers quickly in IBM product documentation.

Community

Get technical tips and insights from others who use the product.

Support

See the latest support information for new or changed features and functions.

Frequently asked questions

Find licensing and support information at a glance.

Webinar

Use cases for a hybrid data warehouse

Hear from IDC and BPM Northwest experts on how a hybrid data warehouse architecture enables IT to regain control of data.

Additional resources

Cloud data management buyer’s guide

Distinguish between different cloud vendor offerings so you can make an informed choice.

Analyst report: Hybrid data warehouses

Learn from Aberdeen Group why top companies are seeing value with hybrid data warehousing.

Brief: Db2 Warehouse on Cloud

Learn how a fully managed, elastic data warehouse can reduce analytics costs while delivering deep insights.

Data sheet: IBM Common SQL Engine

Learn the benefits of IBM Common SQL Engine, which lets you write a query once and run it anywhere.

Related products

IBM Db2 Warehouse on Cloud

An elastic cloud data warehouse built for high-performance analytics

IBM Db2® Event Store

A memory-optimized database for real-time analytics on streaming data

IBM Db2® Big SQL

An enterprise SQL-on-Hadoop engine for advanced big data queries

Get started with IBM Db2 Warehouse at no cost.