SAP Data Warehouse Cloud Update + Upcoming Webcasts

[TammyPowlas]

Join us for these upcoming webcasts:

August 14 BI: SAP Data Warehouse Cloud Overview and Road Map


August 27 BI: SAP Analytics Cloud – Preparing your data

September 4 BI: SAP BW/4HANA Overview and Roadmap

September 5 BI: SAP Analytics Cloud - Data Connectivity, including Road Map

September 11 - BI: SAP BW/4HANA Conversion

Disclaimer applies; everything is subject to change.



Source: SAP

Beta program starts later in August

Solution Overview

Source: SAP

In the past, had 2-3 productions positioning

BW/4HANA is the highly integrated application

For customers familiar with building data warehouses, offered the native approach

Customers have the mixed scenarios

SQL Data Warehouse and BW/4HANA are on premise implementations

Not replaced by Cloud Data Warehouse

Will provide hybrid scenarios - both in place - on premise with SAP Data Warehouse Cloud



Source: SAP

How SAP Data Warehouse Cloud is positioned

Elasticity - pay as you go - there might be periods in the year when you need more storage/computing power

Only pay for what you use, enabled based on space concept

End to end - tight integration with SAP Analytics Cloud

Collaborative - design for enterprise IT and line of business



Source: SAP

Leverages SAP HANA Cloud - it provides connectivity, smart data access, smart data integration and use to connect to SAP system

Virtualized access has limitations; can switch to replication mode, classic ETL approach, ELT too

Open for 3rd party data load, API's available

Consumption layer is covered by tight integration with SAP Analytics Cloud

Opened product for 3rd party consumption, BI tools



Source: SAP

Space concept

Generate space for line of business

Expose data model to spaces

"Marketing" has possible to bring in data from other sources

Under governance; expose model centrally, control authorization

Cost control with pay per use, each space can be strictly managed



Source: SAP

Sample default space, see how much storage is used, how much costs consumed by space, hibernate space



Source: SAP

Data layer - design connectivity

Semantic layer - define dimensions, KPI's, facts, hierarchies

BW customer - info object mentioned in dimension

Semantic objects can be mapped to data layer

Graphical modeling capabilities supported, along with SQL



Source: SAP

Business catalog is similar to a central metadata repository

Versioning, data lineage

New scenario, look at catalog first, leverage existing scenario or build on top



Source: SAP

When used, information on existing scenario (picture of lab business catalog)



Source: SAP

Separate semantic layer, data layer

Above shows the semantics side

Graphical modeling, view, mode, switch to SQL console



Source: SAP

SQL Console lab preview

Provide graphical model



Source: SAP

Can directly connect to SAC

Scenarios

Source: SAP

Connect to your on premise system, reuse in SAP Data Warehouse Cloud - virtually or replicate

Component is Data Builder



Source: SAP

Transformations; can connect to different sources

Local files are a possibility

Model joins, unions, rename columns

Use scheduling to provide updates



Source: SAP

Focus on business modeling

Domain models such as purchase orders

Discussion:

Licensing - covered later when product is GA

Connectivity - to on premise and cloud - SAP and non-SAP system; can switch from virtualized to replication mode

GA will have first business content - and will include content from partners

SAP TechEd will have multiple sessions - lectures + hands-on

Planned integration with Data Hub

After SAP TechEd, plan an OpenSAP Class for SAP Data Warehouse Cloud

Q&A:

Q: Is Cloud Data Warehouse a replacement for BW?

A: It is not a replacement; on-premise will still be BW/4HANA - strategic approach

Q: Conversion or migration from BW/4HANA?

A: Provides tight integration to BW/4HANA

Future - copy data BW/4HANA flows to Data Warehouse Cloud