76 Steps in a BW-to-HANA Migration Workplan Many organizations are planning to move BW to to HANA and is looking for information on how to do this. In this blog we take a look at some of the major tasks yo shold !onsider when moving BW to HANA. We also in!lde referen!es to notes and transa!tions so that yo !an get started on writing yor proje!t plan. Introduction "hese are some of the major tasks for a BW to HANA migration. #n!e yo have added all sb$ tasks% a typi!al workplan has &''$('' detailed items% in!lding stats reports% team meetings% isses% hardware validation% portal integration and tests of front$end tools. However% these first )( steps shold give yo enogh to get yo started on writing yor proje!t plan. Pre-Activity Steps for Each Environment (Dev, QA & Prod) *. +lean the ,ersistent -taging Area ,-A/ for data already loaded to 0-#s 1. 0elete the Aggregates aggregates smmary tables/. "hey will not be needed again. 2. +ompress the 3 and 4 tables in all Info+bes. "his will make Info+bes m!h smaller. &. 5emove data from the statisti!al !bes they start with the te!hni!al name of '+"+6777/. "hese !ontain performan!e information for the BW system rnning on the relational database. 8o 8o !an do this sing the transa!tion 5-00-"A" 5-00-"A" or the program pr ogram 5-00-"A 5-0 0-"A"60A" "60A"A60393"3 A60393"3 to help yo. :. 9ook at log files% bookmarks and nsed B37 ;eries and templates transa!tion 5-<0393"3/. (. 5emove as m!h as possible of the 0", temporary storage% 0", error logs% and temporary database obje!ts. Help and programs to do this are fond in -A, Notes **2=2=( and **'(2=2. ). 4or write$optimized 0-#s that psh data to reportable 0-#s 9-A approa!h/% remove data in the write$optimized 0-#s. It is already available in higher level obje!ts. >. Migrate old data to Near$9ine -torage N9-/ on a small server. "his will still provide a!!ess to the data for the few sers who infre;ently need to see this old data.8o will also be able to ;ery it when BW is on HANA% bt it does not need to be in$memory. =$*'. 5emove data in nsed 0-#s% Info+bes and files sed for staging in the BW system. "his in!ldes possible reorganization of masterdata te7t and attribtes sing pro!ess type in 5-,. **. 8o may also want to !lean p ba!kgrond information stored in the table 5-BA"+H0A"A. "his table !an get very big if not managed. *1. 8o shold also !onsider ar!hiving any I0o!s and !lean the t54+ ;ees. All of this will red!e size of the HANA system and help yo fit the system tables on the master node.
*2. -ize red!tion of Basis "ables. In -A, Note )'(&)>% -A, provides some ideas on how to keep the basis tables from growing too fast too fast in the ftre. *&. As of -ervi!e ,a!k 12 on BW ).'% we !an also delete nwanted master data dire!tly see -A, Note? *2)'>&>/. *:. @se the program 5-00+3560IM6@N@-30 to delete any nsed dimension entries in yor Info+bes to red!e the overall system size not a fa!tor if yo plan on sing the optimized HANA info!bes/ Pre-Vaidation Steps *(. 5n BW to HANA Migration 5eadiness +he!k v1.'/ in -A, Note *)1==>> and resolve all high priority isses in!lding !onne!tivity !he!ks% servi!e pa!ks% se!rity% basis% db notes and general !he!k in the tool for -B% 0ev% A and ,rod. *). 5n &)&2* *>$*=. 5n fll delta load and gather ben!hmark performan!e statisti!s for load and a!tivations. 1'. 5n key ;eries% reports and dashboards for !olle!tion of ben!hmark statisti!s and performan!e% in!lding any B37 broad!aster jobs% pre$!al!lations and workbooks. $ #ther? a/ +ond!t HANA development workshops b/ +omplete HANA Admin workshop and training !/ +reate an -9A and -pport plan for -A, HANA internally d/ +onfirm Ba!kp% 0isaster re!overy and HA plan Environment Sta!in! and "i!ration (Post-#ard$are Insta, Vaidation, and #andover) 1*. 5n ba!kp of database in -A, BW -andbo7 11. -spend jobs and -B development a!tivities. 12. Migrate 0atabase to -A, HANA e7port and import/. 1&. +onne!tivity validations and se!rity !he!ks roles% athenti!ation% and athorization/. 1:. 37ternal job s!hedling !he!ks openhb and otbond interfa!es/. 1(. 37e!te key ;eries identified in step 1' and re!on!ile data at smmary level and detailed as re;ired. 1). +olle!t new HANA performan!e statisti!s for dashboards% B3C broad!aster% reports% workbooks and WA0 templates and analyze performan!e gains. 1>. 5n fll 0elta 9oads from pro!ess !hains !reate a few re!ords in the sor!e environment if re;ired/ and !olle!t ben!hmark statisti!s from 3"9 pro!essing and a!tivation. Analyze these against those !olle!ted in step *>. 1=. 5ern the HANA Migration 5eadiness +he!k in -A, Note *)1==>> and resolve any isses 2'. Do E No$Do de!ision 2*. 5n ba!kp of database in -A, BW 0evelopment environment
21. -spend jobs and development a!tivities in the development environment 22. Migrate 0atabase to -A, HANA te!hni!al migration e7port and import/ 2&. +onne!tivity validations and se!rity !he!ks roles% athenti!ation and athorization/ 2:. 37ternal job s!hedling !he!ks openhb and otbond interfa!es/ 2(. 37e!te key ;eries identified in step 1' and re!on!ile data at smmary level and detailed as re;ired. 2). +olle!t new HANA performan!e statisti!s for dashboards% B3C broad!aster% reports% workbooks and WA0 templates and analyze performan!e gains. 2>. 5n fll 0elta 9oads from pro!ess !hains !reate a few re!ords in the sor!e environment if re;ired/ and !olle!t ben!hmark statisti!s from 3"9 pro!essing and a!tivation. Analyze these against those !olle!ted in step *>. 2=. 5ern the HANA Migration 5eadiness +he!k in -A, Note *)1==>> and resolve any isses &'. Do E No$Do de!ision &*. 5efresh A bo7 from ,rod if feasible &1. 5n ba!kp of database in -A, BW A environment &2. -spend jobs and transports in the A environment &&. Migrate 0atabase to -A, HANA te!hni!al migration e7port and import/ &:. +onne!tivity validations and se!rity !he!ks roles% athenti!ation and athorization/ &(. 37ternal job s!hedling !he!ks openhb and otbond interfa!es/ &). 37e!te key ;eries identified in step 1' and re!on!ile data at smmary level and detailed as re;ired. &>. +olle!t new HANA performan!e statisti!s for dashboards% B3C broad!aster% reports% workbooks and WA0 templates and analyze performan!e gains. &=. 5n fll 0elta 9oads from pro!ess !hains !reate a few re!ords in the sor!e environment if re;ired/ and !olle!t ben!hmark statisti!s from 3"9 pro!essing and a!tivation. Analyze these against those !olle!ted in step *>. :'. 5ern the HANA Migration 5eadiness +he!k in -A, Note *)1==>> and resolve any isses. Other: a) Test backup/restore capabilities b) Test and collect benchmarks for High Availability and/or Disaster Recovery :*. Do E No$Do de!ision $$$$$$$$$$ :1. 0evelop detailed ,rod!tion !tover plan with times steps for e7port and import of files. :2. 0evelop prod!tion validation test plan and assign resor!es. :&. 5n ba!kp of database in -A, BW A environment. ::. -spend jobs and transports in the A environment. :(. Migrate 0atabase to -A, HANA te!hni!al migration e7port and import/.
:). +onne!tivity validations and se!rity !he!ks roles% athenti!ation and athorization/. :>. 37ternal job s!hedling !he!ks openhb and otbond interfa!es/. :=. 37e!te key ;eries identified in step 1' and re!on!ile data at smmary level and detailed as re;ired. ('. +olle!t new HANA performan!e statisti!s for dashboards% B3C broad!aster% reports% workbooks and WA0 templates and analyze performan!e gains. (*. 5n fll 0elta 9oads from pro!ess !hains and !olle!t ben!hmark statisti!s from 3"9 pro!essing and a!tivation. Analyze these against those !olle!ted in step *>. (1. 5ern the HANA Migration 5eadiness +he!k in -A, Note *)1==>> and resolve any isses. (2. @ser migration and log$on validation. (&. -etp Alerts in -A, HANA -tdio. (:. Assign -ystem roles and privileges in all environments. ((. -etp basepaths for all ba!kps. (). alidate +,@ sage% memory footprint and system load dring test rn for reports and data loads. (>. +reate a standard operating pro!edre for -A, HANA spport staff. (=. -etp pdate site and pro!ess for HANA stdio -@M/% li!ense keys% and spport. )'. DoENo$Do 0e!ision restore/. )*. #ptional? #ptimize key 0-#s to new HANA optimized 0-#s. )1. #ptional? #ptimize key Info+bes to new HANA optimized Info+bes flattened dimensions/ )2. #ptional? remove partitions from 9-A and simplify data ar!hite!tre by red!ing layers )&. #ptional? +reate a New !apabilities assessment to take advantage of near$time data warehosing sing -9A ):. #ptional? setp e7ternal data movement into new 0ata -ervi!es 3"9 pro!essing !hains )(. #ptional? -tart removing Info+bes and bild HANA views on 0-#s where appropriate% thereby red!ing data repli!ation% size and data laten!y non$I,% B,+ and non$!mlative F4s/.