Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Why you should know more about SAP Data Warehouse Cloud

Why you should know more about SAP Data Warehouse Cloud


Learn more about the benefits of SAP Data Warehouse Cloud and why you should be interested in the future developments of this public cloud solution.

The session by Klaus-Peter Sauer, a data warehousing expert and author of multiple books from the SAP product management team, will also give you an end-to-end overview and demo of the product.

Vitaliy Rudnytskiy

October 19, 2022

More Decks by Vitaliy Rudnytskiy

Other Decks in Technology


  1. Public Klaus-Peter Sauer, Product Management Data Warehouse Cloud, SAP SE

    Why you should know more about SAP Data Warehouse Cloud
  2. 2 Public The information in this presentation is confidential and

    proprietary to SAP and may not be disclosed without the permission of SAP. Except for your obligation to protect confidential information, this presentation is not subject to your license agreement or any other service or subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or any related document, or to develop or release any functionality mentioned therein. This presentation, or any related document and SAP's strategy and possible future developments, products and or platforms directions and functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in this presentation is not a commitment, promise or legal obligation to deliver any material, code or functionality. This presentation is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. This presentation is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this presentation, except if such damages were caused by SAP’s intentional or gross negligence. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions. Disclaimer
  3. 3 Public Demo Part 2 and Q&A More about Data

    Modeling and Consumption Demo Part 1 Introduction & Overview Agenda
  4. 4 Public Our Strategic SAP Data and Analytics Solutions Addressing

    the data-to-value challenge with a holistic approach SAP & Non SAP 3rd Party Data Lakes Streaming Data Unstructured Data Non SAP Applications SAP Applications LOB users Business users/ Analysts Data Modeler/ Engineer Developers & experts Total Spend Analytics Workforce Planning & Analysis People Analytics Customer Insights Financial Planning & Analysis Lifecycle Management Machine Learning Security & Authorization Data Privacy & Protection Business Content Unified SAP Data Data Scientists SAP HANA Cloud SAP Data Warehouse Cloud SAP Data Intelligence Cloud Self-Service Modelling & Preparation Data Spaces Business Semantics Data Marketplace Data Cataloging Data Quality & Transformation Orchestration & Processing Multi-tier Data Storage Smart Multi-Model Data Federation Replication App Development SAP Analytics Cloud Business Intelligence Enterprise Planning Augmented Analytics Analytics & Planning Business Semantics & Data Warehousing Database
  5. 5 Public How SAP Data Warehouse Cloud can help SAP

    Data Warehouse Cloud goes beyond classical Data Warehousing and brings IT and Business together
  6. 6 Public So why should you know more about it?

    Extended Self-Service Onboard Cloud Apps Integrate ML/AI Embrace Hyperscalers Extend the flexibility for self-service & data sharing with Spaces controlled by the business to boost agility Offer managed schemas to simplify the use of SAP data for data scientists within their environment Onboard new data sets quickly, enabled by the integrated connection management Build a common view across cloud and on-premise data sources ▪ Integrate multiple hyperscaler with out-of-the- box connectivity ▪ Blend data from SAP sources, data lakes, cloud databases, etc. ▪ You decide if data is virtually accesses or persisted ▪ Speed up your data onboarding with out-of-the box connectivity for cloud applications ▪ i.e. SAP SuccessFactors, SAP Fieldglass, salesforce, workday, Google Analytics, etc. ▪ Let LoB blend data to answer their urgent business questions fast ▪ Allow Data Scientists to access SAP data simple & fast with the tools they already use ▪ Let them collaborate with LoB stakeholders more effectively ▪ Feed ML/AI insights back into your DWH or SAP applications ▪ Provide your line of business (LoB) users with their own data space ▪ LoBs can collaborate easier and can share data while avoiding to export & import files ▪ LoBs can implement their own projects independently, easy and fast
  7. 7 Public SAP Data Warehouse Cloud. High-level Component Overview Business

    Layer Data Layer Business Catalog Spaces & Data Sharing Connectivity API Analytics, Predictive, Planning, Apps DATA Data Marketplace
  8. 8 Public Spaces provide your business process with the right

  9. 9 Public What you can connect? SAP Applications Databases &

    Generic Connections External Tooling Hyperscaler & Cloud Apps SAP S/4HANA SAP S/4HANA Cloud SAP Marketing Cloud SAP Open Connectors SAP ECC SAP ABAP SAP HANA on-prem & Cloud SAP BW/4HANA Model Transfer SAP SuccessFactors SAP Fieldglass SAP BW SAP HANA Data Lake Google Cloud Storage Google BigQuery Azure Data Lake Store Gen1 Azure Data Lake Store Gen2 HDFS Amazon Redshift Amazon S3 Amazon Athena Microsoft SQL Server Oracle Azure SQL Database Azure Blob Storage Generic Cloud Data Integration Generic JDBC Generic OData Local CSV File Generic SFTP Snaplogic Informatica Precog Datazeit APOS Adverity SAP Data Intelligence SAP Data Services SAP HANA Smart Data Integration SAP Landscape Transformation Available Partner SAP Help: Connection Overview
  10. 10 Public Consume Instantly explore, test, sample, and license relevant

    external and internal data products from a central catalog Combine Easily connect, model, visualize, and share external and internal data using self-service, intuitive tools in your SAP Data Warehouse Cloud space Control Empower business user to easily manage data access, monitor usage, and automatically enforce license compliance External data Commercial Data Providers Public Data Providers Business Partners 100+ Data Providers 2000+ Data Products 150+ Data Products around Sustainability Enable Integration of External Data Products & Sharing Data Marketplace live since January – to be extended towards private & internal Marketplaces SAP data 3rd party application data
  11. 12 Public Open for Virtual Access and Persistence Data Flow

    ETL beyond view modeling ▪ Combine structured and semi structured data while defining ETL processes ▪ Advanced transformation capabilities leveraging Python 3 ▪ Schedule in task chains External Tools Integrate with all data sources Allow external data movement tools like SAP Data Services, SAP Data Intelligence, SAP Open Connectors, SnapLogic, Precog, Adverity, etc. to bring data into SAP Data Warehouse Cloud using SQL interfaces Virtual Access Real-time virtual data access ▪ Leave data in the source system and access remotely when needed ▪ No upfront data movement ▪ Federation is supported across various sources and hyperscalers Persisted Single table replication ▪ Real-time table replication for up-to-date data ▪ Materialize views and update snapshots using automated, scheduled data loads ▪ Schedule in task chains REMOTE TABLES CLASSIC DATA INTEGRATION
  12. 13 Public Modeling for Everybody Developer Power User Business Analyst

    (no-code/low-code) Graphical & Scripted ▪ Collection of no-code/low-code editors to support Graphical Modeling ▪ Model E/R-models, Tables, Views, SQL & SQL-Script Views ▪ Focuses on most commonly used modeling operators Business Modeling ▪ Allow for a greater degree of self-service ▪ Non-disruptive environment for business scenarios – independent from the data integration layer SAP HANA Deployment Infrastructure ▪ SAP HANA Cloud Modeling capabilities leveraging Calculation View, Flowgraph, Synonym, etc. ▪ Simply re-use HANA based Modeling within SAP Data Warehouse Cloud Open SQL Schema ▪ Option to use SQL DDL & DML leveraging e.g. SQL Views, Tables, Procedures, etc. ▪ Leveraging existing SQL-tooling & skillset ▪ SAP Database Explorer BUILT-IN EDITORS modeling for all users EXTERNAL EDITORS integrated SQL Data Warehousing
  13. 14 Public Choice and openness with pre-built business content SAP

    Analytics Cloud One seamless user experience ▪ Direct consumption of models in SAP Analytics Cloud (live connection) ▪ Any number of SAP Data Warehouse Cloud systems can be connected to any number of SAP Analytics Cloud systems Business Content Business accelerators ▪ Content packages ready to use and accelerate your project ▪ Packages SAP and partners for various LOB and industry scenarios ▪ Separate packages for data models and visualizations 3rd Party API for consumption ▪ Freedom of choice ▪ Use consumption interface to connect any 3rd party front end tool to your exposed views ▪ Make your data models accessible for consumption tools & applications 3rd Party API API 3rd Party consumption * According to the SAP Data Warehouse Cloud Roadmap. MS Office Integration Live Connection to MS Excel ▪ SAP Analytics Cloud, add-in for Microsoft Office 365 (live connection) online or desktop version ▪ SAP Data Warehouse Cloud with SAP Analysis for Microsoft Office 2.8 SP14+
  14. 15 Public ▪ External access via API to support automation

    tooling ▪ Create, read, update and delete spaces and space properties e.g. user assignment etc. ▪ Command Line Interface tool that allows you to outsource repeated and time-consuming tasks programmatically from the outside ▪ Download the latest @sap/dwc-cli from npmjs.com (requires the latest node.js version) ▪ More information in the blog: New Command Line Interface for SAP Data Warehouse Cloud Space API & Command Line Interface
  15. 16 Public ▪ External tools can create artifacts in an

    Open SQL Schema of a Space ▪ Connect via 3rd party SQL client like SAP Database Explorer directly from Space Management ▪ Usage of SAP HANA SQL capability (DDL & DML) − Create views, tables − Define & execute stored procedures − Leverage Data Anonymization and Data Masking − Automated Predictive Library (APL) and Predictive Analysis Library (PAL), if enabled in Space Open SQL Schema Modeling
  16. 17 Public SAP Analytics Cloud SAP Data Warehouse Cloud Structured

    dataset Machine Learning and Advanced Analytics Automated Predictive Library (APL) Predictive Analysis Library (PAL) (Geo-)Spatial Graph Text Mining SAP HANA Cloud Self-Service Modeling & Preparation Data Spaces Business Semantics Data Marketplace Data Science enrichment in SAP DWC, without data extraction .. and many others… SAP Data Warehouse Cloud Embedded Machine Learning and Advanced Analytics
  17. 19 Public SAP Analytics Cloud SAP Data Warehouse Cloud Automated

    Predictive Library (APL) Predictive Analysis Library (PAL) (Geo-)Spatial Graph Text Mining SAP HANA Cloud SAP Data Warehouse Cloud Embedded Machine Learning and Advanced Analytics HANAMLBRIDGE SAPBWBRIDGE TABLE Z_DEMAND-REPORTING VIEW V_DEMAND_ DEVTOBERFEST2022 TABLE DWCML_FORECAST SHARED READ WRITE
  18. 21 Public Want to know more? Additional content around Machine

    Learning with SAP Data Warehouse Cloud Build your Machine Learning Scenario for your SAP HANA Cloud application from Python https://www.youtube.com/watch?v=CX38-95uBtc Machine Learning engines embedded in SAP Data Warehouse Cloud https://www.youtube.com/watch?v=xJx37aX1qds Innovate your IT landscape with SAP Data Warehouse Cloud, SAP BW Bridge https://www.youtube.com/watch?v=Kb19xQvCMDg Hands-on To try out the Machine Learning example (classification) yourself, email [email protected] to get the Jupyter Notebooks and data
  19. 22 Public SAP TechEd 2022 Sessions Related SAP TechEd Sessions

    Lectures ▪ DA110 – The Future of Data Management and Data Warehousing ▪ DA204 – SAP Data Warehouse Cloud: Road Map and Strategy ▪ DA205 – SAP BW Bridge for SAP Data Warehouse Cloud: The Journey to the Public Cloud Breakout Sessions ▪ DA300 – Data Warehousing Scenario: SAP Data Warehouse Cloud and SAP HANA Cloud ▪ DA301 – Innovate and Move SAP Business Warehouse to SAP Data Warehouse Cloud In-person workshop ▪ DA160 – Explore SAP Data Warehouse Cloud from A to Z ▪ DA262 – Modeling External and SAP Software Data in SAP Data Warehouse Cloud Public SAP Web sites ▪ SAP Data Warehouse Cloud community: https://community.sap.com/topics/data-warehouse-cloud ▪ Use the Developer Tutorials to learn more ▪ SAP product page: https://www.sap.com/products/data-warehouse-cloud.html ▪ More product details: documentation on SAP Help
  20. 24 Public ▪ Check out the product page on www.sap.com

    ▪ Get started with documents & training, videos or visit our Learning Journey ▪ Use the tutorials to learn more ▪ Join the Community and check out the Best Practices ▪ Online Documentation on SAP Help ▪ Stay informed & join the LinkedIn group
  21. Thank you. © 2022 SAP SE or an SAP affiliate

    company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to SAP Materials for general audiences. Contact information: Klaus-Peter Sauer Product Management - SAP Data Warehouse Cloud SAP SE [email protected]