Managing Test Data With Optim SASTMeeting 20 9

Managing Test Data With Optim SAST-Meeting 20. 9. 2007 Lauri Pietarinen Relational Consulting 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 1

Agenda • • • My Background and services Test material handling dilemma Optim (formerly Relational Tools) Overview of functions Sample scenarios 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 2

My Background • Tietokonepalvelu (Pension Insurance) 85 -97 – Mainframe development in PLI/DL/I environment – Support department 87 -95 • DB 2 -training etc. . . • At. Business Communications 97 -04 – Internet applications – Database design, DW-implementations, Java-programming, Project management etc. . . • Relational Consulting (own company) 04 – Independent database consultant – Specialising in test data management • Lauri. pietarinen (at) relational-consulting. com 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 3

3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy Te (d st at cy a) cl e a at ni ng st d Te ai Tr en t n em en t t en em ag an m an ag m se tu tin p g su l on C nm vi ro En la tio al In st Optim -consulting 4

Customers • Finland – Ilmarinen (Insurance) – Arek (Insurance) – Tieto. Enator – Area (Travel agency) – + many others… • Sweden – BGC – Alecta 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 5

Status of Test Data • When talking about testing the issues discussed are test cases and testing scenarios • Data and it's management is often conveniently "forgotten" – why? 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 6

Two Different Disciplines TESTING 3. 10. 2020 DATABASES Lauri Pietarinen/Relational Consulting Oy 7

Optim • Formerly Relational Tools • Built by Princeton Softech – www. princetonsoftech. com • DB 2 -version came out in early 90's • Oracle version came out in mid 90's – Additional DBMS support includes SQLServer, DB 2/UDB, Informix and Sybase • Represented in the Nordic by Mainsoft International A/S 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 8

Optim Users • Used by all z/OS sites in Finland – Ilmarinen, Pohjola, OKO, Nordea, Sampo, Iff, Kela, Comptel, Tapiola etc. . . • • Swedish users include BGC, Alecta, Nordea Other customers include BT, EBay, etc. . . In total over 2000 customers world wide Has been designed from the start with large volumes in mind 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 9

Scenario C 4 Production Test 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 10

Sample Database CUSTOMERS RCO ORDERS ROD RID ITEMS 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy DETAILS 11

Sample Values 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 12

Specifying the Tables 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 13

Controlling the Relationships 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 14

Specifying the Key List 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 15

Checking the Steps 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 16

Report Extract Process Report Request Name Server Name Extract File Access Definition File Attachments Client User ID Server User ID Time Started Time Finished Elapsed Time Process Status (Untitled) (Local) c: rtoolsdatamycompanies. xf LAURI. MYTEST Processed k 87376 2007 -09 -19 20: 37: 28 00: 00 no errors, no warnings Process Summary: Tables Processed 3 Rows Extracted 15 Rows with Errors 0 First Pass Table Rows 1 Row Details: Extracted 1 4 10 3. 10. 2020 Failed 0 0 0 Lauri Pietarinen/Relational Consulting Oy Table Name PSTALECTA. dbo. customers PSTALECTA. dbo. orders PSTALECTA. dbo. details 17

Extract File 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 18

Other Functions • INSERT – Insert data from extract file into target database • CONVERT – Convert data in extract file using functions and/or lookup tables • DELETE – Delete rows that were extracted • COMPARE – Compare two extract files 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 19

Subsetting Scenario Extract before 1 2 Run Program C 2 C 5 5 C 2 C 3 Compare C 4 PROGRAM Insert original 6 4 Delete C 7 C 9 3 Extract after Test database 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 20

Monday Regression Test Insert Tuesday Insert Prog V 1 Prog V 2 Compare Extract 3. 10. 2020 Extract Lauri Pietarinen/Relational Consulting Oy 21

Sample Compare 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 22

No Silver Bullet! 3. 10. 2020 Lauri Pietarinen/Relational Consulting Oy 23