SAP Data Warehouse Cloud - Amazon S3

Transcription

SAP Data Warehouse CloudOverviewKlaus-Peter Sauer, Product Management Data Warehouse Cloud, SAP SEJuly 2021

DisclaimerThe 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 serviceor subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or any relateddocument, 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 andfunctionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in thispresentation is not a commitment, promise or legal obligation to deliver any material, code or functionality. This presentation is providedwithout a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for aparticular purpose, or non-infringement. This presentation is for informational purposes and may not be incorporated into a contract. SAPassumes no responsibility for errors or omissions in this presentation, except if such damages were caused by SAP’s intentional or grossnegligence.All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially fromexpectations. 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. 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC2

The Challenge: Data and Analytics How to empowerall stakeholders?PEOPLE How to break downdata silos? 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICDATATECHNOLOGY How to getresults faster?4

SAP Data Warehouse CloudSAP Data Warehouse Cloud goes beyond classical DataWarehousing and brings IT and Businesstogether 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC5

SAP Data Warehouse Cloud and the SAP Business Technology PlatformSAP Analytics CloudBusiness IntelligenceAugmented AnalyticsEnterprise PlanningBusiness Intelligence, planning and predictive analyticsSpacesData & Business LayerData FlowSAP Data Warehouse CloudSAP Data IntelligenceCloudSelf-service modeling, data democratization, end-to-end data warehouseData CatalogSAP HANA CloudOrchestrationMulti-model EngineTiered Data StorageIntegrationData Management (memory, disk, lake), federation and replication 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC6

SAP Data Warehouse Cloud. High-level Component OverviewAnalytics, Predictive, Planning, AppsData LayerAPISpaces &Data SharingConnectivityBusiness ContentBusiness LayerDATA 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC7

SAP Data Warehouse Cloud. ArchitectureUse.SourcesBusiness Modeling ServicesSAP HANACloudSpace ManagementIn-MemoryCloud SourcesDisk, Data LakeBusiness CatalogAdministration & Security ServicesReplicationOn-Premise SourcesVirtual AccessData FlowSAP BTP Core & External ToolsIntegrate.Data Modeling ServicesSAP Data IntelligenceOperate.Business ContentManage.API 3rd-Party consumptionSAP Analytics CloudAPI 3rd-Party Data LoadProvide your users an end-to-end view of their data landscape that is trusted, secure, and actionable 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC8

Integrate. Open for Virtual Access and PersistenceREMOTE TABLESVirtual AccessRealtime virtual data access Leave data in the source systemand access remotely whenneeded No upfront data movement Federation is supportedacross various sources andhyperscalers 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICCLASSIC DATA INTEGRATIONPersistedSingle table replication Real-time table replication forup-to-date data Materialize views and updatesnapshots usingautomated, scheduled dataloadsData FlowETL beyond view modeling Combine structured and semistructured data while definingETL processes Advanced transformationcapabilities leveraging Python 3External ToolsIntegrate with all data sourcesAllow external data movementtools like SAP Data Services, SAPData Intelligence, SAP OpenConnectors, SnapLogic, Precog,Adverity, etc. to bring data into SAPData Warehouse Cloud using SQLinterfaces10

Integrate. Data Sources OverviewCurrent2021 and beyond*Connection TilesSAP ABAPNew Connection TilesSAP HANA on-prem & CloudSAP ECCSAP BWSAP FieldglassGeneric JDBCAdveritySAP BW/4HANA Model TransferSAP SuccessFactorsGeneric ODataPrecogSAP S/4HANA CloudSAP ConcurSAP Cloud 4 CustomerLocal CSV FileSAP HANA Data LakeGeneric Cloud Data IntegrationAmazon RedshiftSAP BPCAmazon S3Azure Data Lake Store Gen2Google BigQuerySAP AribaSAP Marketing CloudSAP Open ConnectorsAmazon AthenaAzure Data Lake Store Gen1Google Cloud StorageSAP S/4HANAMicrosoft SQL ServerOracleSFTPHDFSSAP Sybase IQSAP IBPAzure SynapseAzure SQL DatabaseSAP Cloud 4 CommerceAzure Analysis ServicesRESTful WebservicesIBM DB2mySQLPostgreSQLSnaplogicTeradataSAP and partner tools supporting data ingestion via Open SQL SchemaAPOSDatazeitSAP Data IntelligenceInformaticaSAP Data ServicesSAP Help: Connection OverviewPrecogSnaplogicSAP HANA Smart Data IntegrationAvailableSAP Landscape TransformationPlanned*Partner* According to the SAP Data Warehouse Cloud Roadmap.Note: The shown sequence does not reflect priority and timewise planning 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC11

Integrate. Hybrid SAP BW Integration OverviewTwo different ways available for integrating SAP BW & SAP BW/4HANAsystems:Business ViewFederated/replicated business semantics integration scenarios via SAPBW/4HANA Model Transfer connectionRemote Table Differences in support of consumable entities, supported entityfeatures, federated or replicated scenarios, location & usage ofcalculation engineon-premisesRemote or replicated data consumption scenarios supported with SAPBW & SAP BW/4HANABusiness semantics migration support for SAP BW/4HANA only via SAPBW/4HANA Model Transfer connectionSAP ABAP ConnectionQuery asInfoProviderInfoProviderInfoObjectBWBusiness LayerData Layer 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICRemote TablecloudAny DBSAP ABAP ConnectionSAP ABAP ConnectionSAP HANA Connection Remote TableQuery asInfoProviderInfoProviderInfoObjectQuery ANAHANAHANAExternal HANA ViewsExternal HANA Views12SAP BW/4HANA Model Transfer Connection SAP Data Warehouse CloudFederated/replicated data consumption scenarios via Operational Data Provisioning framework (SAP ABAP connection) External SAP HANA Views (SAP HANA connection)HTTP SAP HANA Connection

Integrate. Hybrid SAP HANA for SQL data warehousing Integration SAP HANA for SQL data warehousing integratingloosely coupled, but deeply integrated tooling (SAPand open Source) enabled to connect, access &process data, governed by SAP HANA 2.0 or SAPHANA Cloud External Tools Database Explorer Web IDESQL Artefacts: HANA SQL DDL & DML BusinessApplication Studio Data Services Data IntelligenceEditors empower Business & IT Users to create End-toEnd ScenariosData is accessed, processed, federated and persistedusing SAP HANA Cloud 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICSAP Data Warehouse CloudSAP Analytics Cloud3rd party AppsSAP ToolsHANA Artefacts, like: Calculation View, remote Source,Flowgraph, Roles, virtual Table, Table, NDSO SAP Data Warehouse Cloud SAP HANA for SQL data warehousingOther Tools SQL Editor Data Modeling Data Integration& ETL Tools Others MARKETINGFINANCESQLSchema1 SALESBusiness ModelsSQLSchemanHDIContainer1Data Flows & Models HDIContainernSAP HANAConnectionsEditors Business Builder Data Builder Data Flow Builder SpaceManagement DatabaseExplorer Scheduling MonitoringSAP HANA Cloud13

Operate. Unlocking data insights with integritySpace ManagementCollaboration across spaces Access to globally managed datawithout export & importWork independently with your localdata and create new insights Share your results with others Governed by IT 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICConfigurationManage your system settingsSecuritySecurity on all layers IP-Allowlisting User Management Data Provisioning Agentsmonitoring & configuration Row-level Security Secure Source SystemConnections Data Anonymization & DataMasking 3rd Party driver & certificateManagement Access HANA Cloud Cockpit Auditing & Resource MonitoringTransportTransfer content between tenants Move your own content betweendifferent tenants Export content packages and sharewith other tenants15

Operate. SpacesIndependent virtual work environmentsfor departments, LOB’s, data domains, project teams, and individualsData sharing fosters collaborationbetween IT, business units, and projects to connect global & local dataGet in control of data sprawlby reusing shared data & avoid maintaining disconnected data sets 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC16

Operate. Space Management Spaces are secured virtual work environments which provide isolation for metadata objects and space resources define space storage quota and control resource usage enables sharing of data with other spaces Transparent monitoring & statistics Manage user access for space members Maintain source system connections Database users for read access from other applications write access to an Open SQL Schema via external tools deployment of SAP HANA Deployment Infrastructure (HDI)containers Time dimension Optional Auditing for read and change operations Optional SAP HANA Data Lake Integration 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC17

DEMO 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC18

Manage. Modeling for EverybodyBusiness AnalystDeveloperPower User(no-code/low-code)BUILT-IN EDITORSEXTERNAL EDITORSmodeling for all usersintegrated SQL Data WarehousingBusiness Modeling Allow for a greater degree of selfservice Non-disruptive environment forbusiness scenarios – independentfrom the data integration layer 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICGraphical & ScriptedSAP HANA DeploymentInfrastructureOpen SQL Schema Collection of no-code/low-codeeditors to support GraphicalModeling Option to use SQL DDL & DMLleveraging e.g. SQL Views, Tables,Procedures, etc. SAP HANA Cloud Modelingcapabilities leveraging CalculationView, Flowgraph, Synonym, etc. Model E/R-models, Tables, Views,SQL & SQL-Script Views Leveraging existing SQL-tooling &skillset Focuses on most commonly usedmodeling operators SAP Database ExplorerSimply re-use HANA basedModeling within SAP DataWarehouse Cloud20

Manage. Collaborate in business termsBUSINESS LAYERUsers work in businessterms“What were the key marginCUSTOMERSALESREVENUEPRICEPRODUCTdrivers for my product? What if Ireduce the price by 10%?”BUSINESSCATALOGUsers discover availableassets & work on commonKPIsDATA LAYER“How can I assure queries willIT models underlyingrelationshipsperform with data coming from“How is the margin of theheterogenous systems?”product calculated? Where doI find it?” Business entities and relationships withbusiness language 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC Model standardization andreuse for efficiency Independence for businessusers from IT21

Use. Choice and openness with prebuilt business contentSAP Analytics CloudBusiness Content3rd Party APIAPI 3rd-Party consumptionOne seamless user experience Direct consumption of models in SAPAnalytics Cloud (live connection) Any number of SAP Data WarehouseCloud systems can be connected toany number of SAP Analytics Cloudsystems3rd Party API for consumptionBusiness accelerators Freedom of choice Use consumption interface toconnect any 3rd-party front end toolto your exposed viewsContent packages ready to use andaccelerate your project Packages SAP and partners forvarious LOB and industry scenarios Separate packages for data modelsand visualizations Make your data models accessible forconsumption tools & applications* According to the SAP Data Warehouse Cloud Roadmap. 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC23

Use. Business ContentPartner Business ContentSAP Business ContentEnterprise Analyticsfor ProcurementSpend AnalyticsSAP AribaSAP AribaResponsive SupplyNetwork, Sales andInventoryRevenue GrowthManagementFinance forMarketing AnalyticsSAP S/4HANA CloudAdverityConsumer ProductsCustomer ServiceInsightsE-Commerce - CrossMarketplace InsightsProcurement CockpitSales DashboardCubeServBitechdatazeitIBSolutionAnalytics forEffective InventoryOptimizationSuccessFactors /Attendance TrackerProduct CostSimulationSales Insights (SAPBW & Salesforce)KPCmib:NDCPWCAutomotiveFinancial AnalyticsDashboard for SAPAnalytics CloudPOS AnalyticsRetailLife ScienceDashboardStatistical ProcessControlCustomer ValueManagementOptimizing OrderFulfillment with MLSAP SCMSPCTelecommunicationInspired IntellectSAP S/4HANAISRNewNewMeter to CashUtilitiesOutcome-basedbusiness Insights*OBBI*MOSAIC – MarginOptimized SalesIntelligenceLyra IntegratedCapacity Planning(EAM & HCM)ReplyRizingFinancial Reportingfor SAP Business OneEWM InsightsWesternachers-peersNewMore information about the Business Content the SAP Data Warehouse Cloud Community.Partner Content also listed on SAP Store. 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC* The content is based on the upcoming The SAP Outcome-Based Business Insights (OBBI) application, which is targeted for Q4 2021.24

DEMO 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC25

Learn about the SAP Data Warehouse Cloud success stories. 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC26

What’s New inSAP Data Warehouse Cloud One session per quarter Covering new features per release Latest session for Q2-2021 on July 14th watch now Additional Q2-2021 features covered in this blog Release News on SAP Help Watch previous recordings forQ2-2020, Q3-2020, Q4-2020, Q1-2021 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC27

August 5, 202110 – 11 am oud-road-mapLearn more about the current the SAP Data Warehouse Cloud Roadmap in the online SAP Road Map Explorer. 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC28

Get your30-Day free trial e-cloud-trial.htmlFind sample content on GitHubSAP Note on Trial restrictions 3007887 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC29

Check the Info & Guides section onwww.sapdatawarehouse.cloud with––– 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICBlogsGetting Started - Learning TrackQuick answers Sign up for upcoming webinars & PowerHourWorkshops Register for upcoming Talk Show Series Join the Community and check out the BestPractices Online Documentation on SAP Help Stay informed & join the LinkedIn group Provide your feedback30

Thank you and stay safe!Contact information:Klaus-Peter SauerProduct ManagementData WarehousingSAP SEklaus-peter.sauer@sap.com

Follow uswww.sap.com/contactsap 2021 SAP SE or an SAP affiliate company. All rights reserved.No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission ofSAP SE or an SAP affiliate company.The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and itsdistributors contain proprietary software components of other software vendors. National product specifications may vary.These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation orwarranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials.The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warrantystatements accompanying such products and services, if any. Nothing herein should be construed as constituting an additionalwarranty.In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document orany related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation,and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platforms, directions, andfunctionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reasonwithout notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, orfunctionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differmaterially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and theyshould not be relied upon in making purchasing decisions.SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registeredtrademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service namesmentioned are the trademarks of their respective companies.See www.sap.com/copyright for additional trademark information and notices.

SAP Data Warehouse Cloud and the SAP Business Technology Platform SAP Analytics Cloud Business Intelligence, planning and predictive analytics SAP Data Warehouse Cloud Self-service modeling, data democratization, end-to-end data warehouse SAP Data Intelligence Cloud SAP HANA Cloud Data Management (memory, disk, lake), federation and replication