A Ustomer's Massive Database Migration Journey At Siemens

Transcription

A Customer’sMassive Database Migration Journey at SiemensWade Price SAP Solution Architect, AtosSession ID: ASUG84594May 7 – 9, 2019

About the SpeakersWade Price SAP Solution Architect, Atos With Atos since 1998. SAP HANA SME for Atos NAM, Project Manager, SAP Functional Consultant. Passionate about leveraging technology to achieve realbusiness value.At the risk of revealing my age - Oracle 5 & 6 DBA

Key Outcomes/Objectives1. Benefit of a SAP partner on HANA migration2. Technical roadblocks on the way to S/43. Best practice on migration planning

Agenda SAP Migration strategy and partner ecosystemThe Siemens objectiveAtos Global Transformation Methodology (GTM)Technical Blueprint and Migration StrategyTakeaways and business benefits for SiemensQ&A

Siemens and Atos at a glanceSiemens (www.siemens.com) is a globalAtos (www.atos.net) is a global leader in digitalpowerhouse focusing on the areas of electrification,automation and digitalization with the HQ in Munich,Germany.transformation with 120,000 employees in 73 countries.Siemens is one of the world’s largest producers ofenergy-efficient, resource-saving technologies, Siemens isa leading supplier of systems for power generation andtransmission as well as automation solutions.Siemens operates in more than 200 countries withapprox. 377.000 employees.European number one in Cloud, Cybersecurity and HighPerformance Computing, the Group provides end-to-endOrchestrated Hybrid Cloud, Big Data, BusinessApplications and Digital Workplace solutions through itsDigital Transformation Factory.With its cutting-edge technologies and industryknowledge, Atos supports the digital transformation of itsclients across all business sectors.The Group is the Worldwide Information TechnologyPartner for the Olympic & Paralympic Games.

Atos is a global leading SAP partnerManaged, Full Stack, SAP HANA Cloud service3 million SAP End-Userssupported40 local SAP teams13,000 skilled SAPprofessionals5,000 SID’s operatedIntroduction of new business models andvalue add services in 15 projects withSAP SCP and IoT/Leonardo 90% of our TOP 200 customers havestarted the SAP digitaltransformation journeyCost savings and optimized businessprocesses on 30 projects leveraging SAPcloud based solutions (Ariba, Hybris,SAP Partner for 33 years & SAP VARPartner, well recognizedwith yearly awardsSuccessFactors, )Global SAP-certified in Hosting, HANAOperations, Cloud Services and AppManagementGlobal SAP-certified InfrastructureEnhanced operational efficiency on6,200 SAP projects50 S/4HANA customers6

SAP HANA@SiemensScope and objectiveProject ScopeProject ObjectiveMigration and consolidation of more than 50 SAPlandscapes to latest and standardized SAP release(e.g. ERP ECC 6 EHP7/Unicode) and SAP HANA forusers in more than 50 countries. Reduction of hardware and data center operationscosts with cost effective state of the art infrastructureThe project covered ERP, BW, SRM, HR and APOprocesses. Huge acceleration of transactions and reports,productivity increase for usersImplementation Partner is Atos IT Solutions and ServicesGmbH.PM@Siemens the Siemens standard projectmanagement methodology with standardized projectplans and milestones for all projects was used integratingAtos Standard MSP/PMP methodology. Be prepared for future innovations (e.g. S/4 HANA,Fiori) opening new business opportunities Basis to replace former custom built solutions bySAP standard (e.g. new SAP business functions in EHP7)and insert of new SAP standard functionality intoexisting processes

SAP HANA@Siemens ProjectThe HANA projectAtos Scope: 49 landscapes including10 ultra complex landscapes In total 219 SID’sTimeline: All systems migrated within18 monthHighlights: 100% success rate Majority of migration via DMO process In total 460TB HANA memory HANA DB sizes up to 8 TB8GER188 SID’s1)AUT20 SID’s1)CAN/US15 SID’s2)APAC10 SID’sSpain7 SID’s2)China1 SID’s

Atos Transition Vision and MethodologyBalancing across all dimensions Vision - Delivering a mature, credible and sustainable transition 9A balanced change approach across all dimensionsStep-by-step implementation leading to an agile and robust service organizationValue infusion from the very beginningMethodology - Customized roadmap based on Global Outsourcing Transition Management MethodologyCritical Success Factors – limited business downtime

Migration Blueprint of a 3 system landscapeAtos Best Practice approachAdditional Systems may berequired for e.g. dualmaintenance, ABAP PRD-TST is a sandbox ortemporary system needed formigration downtime optimizationR3loadQA 1VDE Migration Approach toSAP HANA for a completeLandscape consisting ofDevelopment, Quality andProduction systemT-TS DPRDEVPRDcopy

Timeline Blueprint of a 3 system landscapeIncluding customer testing2step 1Inititation34step 2Design5step 3BuildInfra6step 4InstallSAPstep 5ProdTest11Test periodCustomersupported byAtosstep 6Re-platforming steps:Step 5 - Test re-platforming production systemStep 6 - Re-platforming Development systemsStep 7 - Re-platforming Production systemsStep 8 - Re-platforming QA systemsAfter-Care period of 2 weeks after each transition1112DEV13After Carestep 7Prodfinal eekend1Transition Week789 10freeze developmentduring re-platformingDev systemsstep 8QAAfterCareAfter Care15

Atos HANA TDIEnterprise Private Cloud ArchitectureSAP HANA Server FarmSAP Application Server FarmHANA Server FarmVMWare Server FarmVMWare Server FarmHANA OrchestrationCustomer 2SAPServerSAPServerCustomer 1Customer 2VMWare OrchestrationCustomer 1Customer 1Customer 2Customer 2Customer 1Customer APServerSAP rverSAPServerSAPServerSAP ServerSAP Server10 Gbit/s LANSwitches10 GbitsLAN rage16 Gbit/s SANSwitches8 Gbit/sSAN SwitchesFirewallShared usage for SAP HANA FarmHANA node interconnect12Customer 1Dialog/Batch LANFor Application Server FarmFCP

SAP HANA Infrastructurescaling from small to enterpriseSAP HANAVirtual CloudESX Resource PoolSAP SAP SAPVM VM VMSAP SAP SAPVM VM VMSAP SAP SAPVM VM VMSAP SAP SAPVM VM VMSAP SAP SAPVM VM VMESXiESXiESXiESXiESXiS43TB RAMS4S43TB RAM3TB RAM13S43TB RAMdynamic storage poolS2HANASizeS43TB RAME7-8880v432GBE7-8890v464GB128GB -1,5TB2TBS4S6S8S10S12S14S161TB - 3TB4.5TB3TB - 6TB7.5TB9TB10.5TB12TB4TB6TB8TB10TB12TB14TB16TB

SAP HANA infrastructureavailability scenarios to avoid business transaction loss (RPO 0)Standard Service ClassSpare nodePremium Service ClassNode in DC1Node in DC1Spare nodeLinux Cluster OperationsPremium DR Service ClassNode in DC1Node in DC2Spare nodeLinux Cluster OperationsDC114DC1DC2sync. Replication with HANAHANA serverDC2Storage

SAP Database migrationComparison of standard migration options (DMO)2Install Target SystemUpgrade Uptime3Switch DB Connection4Migrate application dataSAP NetWeaver15anyDBFinish Upgrade6Customer testand approvalUptimeDMO of SUM as standard solution tomigrate system to HANA database one “small” downtime needed Included in SAP Standard with low latency / high bandwidth connectivityneeded best suited for In-DC migrationsMemoryPipe5DowntimeDMO SAP AGUptime1SAP HANA

SAP database migration with DMOTakeaways for throughput optimizationSAP NW parameteroptimizationSAP DB HousekeepingSAP NW(A)SCS PASDMO Server- temporary -10 Gb10 GbMajor CPU resources onDMO server10 Gbit/s10 GbSourceOracle Server8 Gb10 GBits/snetworkDatabase parameteroptimization10 GbSAP HANAServer8 GbAdequate storageperformance16Takeaway

SAP HANA@SiemensQuality Approach and TCOQuality ApproachRapid Time to Value and TCI/TCO Strict Program Governance: Siemens CIO, Heads of ITGovernance and Centers of Expertise for Divisions,Regions and Infrastructure were involved throughregular steering committees once per month.Program organization wasn't changed duringprogram timeline More than 50 projects running in one program withsame methodology in predefined timeframe Provider created reference architecture for onesystem which was adapted to all other systems Industrialized approach for system migration andcode remediation saved time and costs DMO as standard software was used for best practicedelivery Nearshoring of data center migrations helped toreduce costs at provider To ensure timely completion of code remediation anAtos program was developed and used for legacyABAP-code to identify all potential select statementsfor sorting issues as early as possible. Cost avoidance by combining other data centerchanges with the SAP HANA program Siemens specific HANA trainings for key expertsbefore project starts. Trainings have been organizedcentrally by Siemens training provider. Bundling for optimized infrastructure Bundling for cost effective ABAP remediationcontracts Consolidation of hosting locations to reduceoperations costs

SAP HANA@SiemensChallenges, Lessons learned and Key contributorsKey Challenges faced, Key lessons learnedKey contributors to the success To run migration in one weekend (especiallythe larger systems) Several test migrations of DMO and SNPtook place with learning curve and improvedmigration times on each test migration Code remediation for 28 projectsconducted with successfulindustrialized Offshore approach Tight program schedule: More than 50migrations in 18 months within midmonthtime slots Put enough migration resources intoprojects. Implement the rule of not morethan 5 migrations in one weekend throughsynchronizing of project plans andrescheduling if necessary. Adherence to data privacy and ISEC rules andregulations in the Offshore approach Involvement of legal and ISEC department Bundling of more than 50 singleprojects to one program withcentral program organization andstandardized industrialized approachincluding milestones and qualitygates for all projects. Identify similartasks for the whole program whichwere used as basis for a Request forProposal process to externalsuppliers Strong management support inconflict resolution and decisionmaking

SAP HANA@SiemensSummaryProject DetailsBusiness Objectives 18 month project duration Reduction of hardware and data center operationscosts with cost effective state of the art infrastructure 50 Go-lives Be prepared for future innovations (e.g. S/4 HANA,Fiori) opening new business opportunities. Huge acceleration of transactions and reports,productivity increase for users. appr. 100.000 Users wereseamless migrated appr. 62.000 days of projecteffort Basis to replace former custom built solutions by SAPstandard (e.g. new SAP business functions in EHP7)and insert of new SAP standard functionality intoexisting processes. achievedachieved achieved achieved

We deployed the largest HANA project in the world20

Want to know more about Atosand SAP offerings?Visit us at booth 1908

Take the Session Survey.We want to hear fromyou! Be sure to completethe session evaluation onthe SAPPHIRE NOW andASUG Annual Conferencemobile app.

Presentation MaterialsAccess the slides from 2019 ASUG Annual Conference here:http://info.asug.com/2019-ac-slides

Q&AFor questions after this session, contact us atmartin.pfeil@atos.net and stefanie.wessely@atos.net .

Let’s Be Social.Stay connected. Share your SAP experiences anytime, anywhere.Join the ASUG conversation on social media: @ASUG365 #ASUG

SAP Server SAP Server ed age Data Volume Log Volume Customer Data Volume Log Volume Customer Data Volume Log Volume Customer Data Log Volume Data Volume Log Volume ed age ed p . migration times on each test migration Tight program schedule: More than 50 migrations in 18 months within midmonth time slots Put enough migration resources into