从 SAP BUSINESS WAREHOUSE 迁移到 DATABRICKS.pdf

1、2024 Databricks Inc.All rights reservedPax Journey Pax Journey from SAP to from SAP to DatabricksDatabricksClemens Nickel&Jan ScharnetzkyClemens Nickel&Jan Scharnetzky11.06.202411.06.2024BackgroundSAP BW,SAP ERP&many SAP custom solutionsFounded 1876Life insuranceCHF 8.6 billion assetsCooperative soc

2、ietyoldest active policy January 1956Life Insurance Contextmany different data sourceshigh degree of customizationdifferent data perspectivesstringent regulationschallenging data qualityretrospective mutationsChallenging business with very complex dataThe Analytics StackSAP BW on HANASAP BW/4HANAEnd

3、 of life 2028End of life 2028(extended 2030)Complex Business LogicHigh costs&Performance limitsIntegrated in SAP Solution(ERP System)Simple Migration of Business Logic Strong Developers in houseCloud Strategy AzureCosts&PerformanceNew business casesIs there a better alternative?The logical candidate

4、Status QuoOur ApproachData BusinessValueTechnologyOrganisation&CultureFramework for the Journey1616Best PracticesLearningsTT+1T+2T+31 12 23 34 45 56 6Best practices from D One7 78 89 9101011111212Project Team SetupCo-Creation&Training on the jobBusiness ValueOrganisation&CultureDataTechnologyDefinit

5、ion of success PoVPoV Use Case Initiale Requirements (Skills and Usage)Setup ArchitectureRequirements data governanceEvaluation of Business requirements Stakeholder interviews to gather business requirements and current pain pointsData Visualization&First Data ModelBoard member presentationFirst Pro

6、totype RefinementSecond PrototypeInvolvement of future stakeholders in the development of the prototypes 131314141515Evaluate and finalizeProductionalization T+4Design PoVArchitectureAccess Management and Data Layer OrganisationUse Case driven developmentChange ManagementData Vault ModellingBacklog&