1 / 34

Ben Chernys

Data Migration ITSM 6 to 7 with Meta-Update. Software Tool House Inc. Meta-Update. Ben Chernys. Software Tool House Inc. Canada / Germany Tel.: +49 (0) 162 175 0956 Ben.Chernys@softwaretoolhouse.com. Agenda. Objectives. ITSM 6 -> 7 Migration Challenges Project Overview

lakia
Download Presentation

Ben Chernys

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Migration ITSM 6 to 7 with Meta-Update Software Tool House Inc. Meta-Update Ben Chernys Software Tool House Inc. Canada / Germany Tel.: +49 (0) 162 175 0956 Ben.Chernys@softwaretoolhouse.com

  2. Agenda Objectives • ITSM 6 -> 7 Migration Challenges • Project Overview • Meta-Update: an introduction to an ARS data scripting tool giving ARS developers the power of the API • Meta-Update Scripts: ITSM 6 -> 7 Migration

  3. Migration Challenges ITSM 6 to 7 Migrations • Completely different and more complex table layout. Many more tables and fields. • Much more validation of data fields: Many values acceptable in 6 cannot be used in 7. • Documentation sadly lacking.

  4. Migration Challenges ITSM 6 to 7 Migrations • Each customer will have different desires with respect to field value transformation and mapping, Source and Target classes may be different, Historical requesters may not exist, Categorisations will be different.

  5. Project Project

  6. Project Overview • Data migration responsibility for end customer’s production migration weekend. • BMC responsible for foundation data. • Fixed Price • Incidents, Changes, CMDB • Work with customer, implementation team.

  7. Project Milestones • Production Data Summary • Data Mapping Sessions • Mapping Document • Full Migration to Development • Production Migration • Migration Results Document

  8. Production Data Summary • Investigation of production server data. • Interviews with client’s data managers. • Human analysis using both ARS tools and scripted schema and query tools tailored for the client’s production dataset.

  9. Data Summary Data Summary

  10. Data Summary Data Summary

  11. Preparation Data Mapping Preparation • Client’s data managers select a set of “root request” records to be brought over. • Migration scripts are tailored and run taking over the selected “root request” records’ well formed trees.

  12. Sessions Data Mapping Sessions • Held with client’s data managers once selected records brought over. • Migrations of single, well formed trees take place during the session. • Changes are made and results are immediate with a press of the refresh button.

  13. Sessions

  14. Mapping Data Mapping Documents • “Human generated” from scripts • All records read and output identified and listed. • Field by field assignments listed.

  15. Mapping Data Mapping Documents

  16. Mapping Data Mapping Documents

  17. Mapping Data Mapping Documents

  18. Mapping Data Mapping Documents

  19. Scripts Scripts

  20. Scripts Introducing Meta-Update

  21. Meta-Update is a new way to harness the power of the ARS API: with no programming at all! Scripts Introducing Meta-Update • Meta-Update is a Remedy ARS Data Integration, Server sync, File Import, Export, Batch and Workflow tool. Meta-Update shortens API development by 90% Meta-Update’s ROI is typically its first use.

  22. Scripts Introducing Meta-Update • creates repeatable, reliableharnessing the power of the API, with queries and assignments in a language your ARS Administrator already speaks. An ARS Administrator Command scripts, Query = Src, HPD:HelpDesk, ‘Customer Name’ = “$Fle, Cust$” AND ‘Name’ = “$Fle, NmL$, $Fle, NmF$”

  23. Scripts References • ARS: $Field$ • Meta-Update: $Tag, Field$ A Tag is a reference to an ARS record, file record, SQL row, a named variable set, a diary entry, program arguments, the environment. A Field is an ARS field’s database name or id, a field defined from a file or SQL definition, a program argument, environment variable, assigned string variable name.

  24. Scripts What is Meta-Update?

  25. Meta-Update Scripting Assignment Sections • Status = Assigned • 7 = 2 • Status = @if(“$X, Sta$” == “yy”) 2 • Status = @if(“$X, Sta$” == “yy”, & “Assigned”, “New”) • Status = @LookUp, StaX, $X, Sta$

  26. Meta-Update Scripting Assignment Sections • Variable assignments • Load records • Perl compatible regular expressions • Server processes • Externalprocesses • If then else

  27. Scripts ITSM 6 – 7 Scripts

  28. Scripts Three Entry Points • One a single CI Root Asset, Help Desk Case, Change • File a CSV of CI Root Assets, HPD Cases, Changes • All All CI Root Assets, HPD Cases, Changes

  29. Scripts

  30. Scripts What is Meta-Update?

  31. Scripts

  32. Scripts What is Meta-Update?

  33. Scripts What is Meta-Update? CI Pre Assignments

  34. Data Migration ITSM 6 to 7 with Meta-Update Software Tool House Inc. Meta-Update Ben Chernys Software Tool House Inc. Canada / Germany Tel.: +49 (0) 162 175 0956 Ben.Chernys@softwaretoolhouse.com

More Related