IT Application Decommissioning - Application Retirement Services

1. Archive your legacy systems with us! – Tanja Koenig –

2. What can you expect from today's presentation? 01 06 Company profile Use cases Archiving procedure in detail Project experience System experience Your advantages of a project with AvenDATA GmbH Differences to other providers Live presentation archive software ViewBox Next Steps 02 07 03 08 04 09 05

3. Who is AvenDATA GmbH? Berlin, headquarters (Germany) Budapest(Ungarn) New York (USA) Mumbai(Indien) AvenDATA spans over the globe We work 100% remote all over the world.

4. Who is AvenDATA GmbH? AvenDATA GmbH founded in 2003 as a spin-off of the renowned auditing and tax consultancy company Mazars GmbH & Co. KG (www.mazars.de) The core competence of AvenDATA lies in the archiving of legacy IT systems ViewBox software solution for legally compliant and audit-proof reproduction the database and business logic of your legacy system

5. What experience has AvenDATA been able to gain in 17 years? 3,100 04 3,100 180 Customers worldwide Locations worldwide Global Archiving projects Employees

6. When is the ViewBox used? IT-Application - Decommissioning Switch off all legacy systems in compliance with legal requirements. Liquidation / Insolvency Due to liquidation it can be required that applications needs to be archived. Carve-out Client related extraction and archiving becoming relevant.

7. When is the ViewBox used? Mergers and Acquisitions Also IT applications needs to be considered within mergers and acquisitions. SAP HANA S/4 HANA requires companies to archive legacy SAP instances which were not migrated to the new environment. Result: ViewBox as a solution for structured and unstructured data

8. What kind of legacy IT systems can the solution be used for? ERP-SYSTEMS ASP, JD Edwards, Oracle, Navision, AS400 MAIL SERVER Lotus Notes, Microsoft Exchange... TICKET-SYSTEMS JIRA, OTRS, etc... OPTICAL ARCHIVES Content Manager, IXOS, Easy, SER CRM-SYSTEMS ASP, JD Edwards, Oracle, Navision, AS400 FILESERVER SYSTEMS

9. What does a sample project plan look like?

10. Wo kann AvenDATA ihre Erfahrungen weitergeben? Test concepts for users Based on 18 years of experience became archiving standards developed and perfected Jour fixes on project statuses Kick off meeting Documentation templates Training documents Checklists

11. How are the requirements for the project taken up? Technical legacy system analysis using a checklist database System version | Database size | Access options | Archive connection etc. Technical legacy system analysis using View catalog Record the required | Queries in the archive system | Selection criteria

12. What does the system check mean for you? Free system check Takes about an hour or two Implementation is carried out by an experienced project manager Do a check on that, The effort is manageable for you!

13. Do a check on that, The effort is manageable for you! Fixed price offer to minimize the monetary risk Consideration of legal and internal requirements Basis for planning and decision-making for an archiving project

14. How does AvenDATA work in archiving - data extraction? Extraction of all system tables including a completeness check using Data extraction logs as part of the procedural documentation Hashing of the extracted tables Exception: Carve Outs - a filtered data is extracted here Client / company code level

15. How does AvenDATA work in archiving - data extraction? Result Ensuring the Data completeness | Audit security as well as the flexibility to be able to create views even after switching off

16. How is the data completeness verified? Old system table Number of records Table ViewBox Number of records

17. How does AvenDATA proceed with archiving - data import? Data import of the extracted databases taking into account society-specific structures such as Client Fiscal year Accounting area Result Data can be selected again and given authorizations

18. How does AvenDATA proceed in archiving - view creation? Creation of views by means of macro export, extraction of structural information, Data dictionary analysis Documentation and storage of all views scripts for traceability in JIRA

19. How does AvenDATA proceed in archiving - view creation? Generation of trial views in the form of test cases from the old system and the archive system ViewBox Possibility of mapping DrillDown / DrillUp functionality, input help and Selection parameters

20. How does AvenDATA map internal processes in archiving? Open Question New Building Development Quality Checking Cross Checking Reopened Ready Wrong SAP Expert

21. How does AvenDATA prove data integrity? Selection of the view Bank master data on the fields Bankland and Bank key

22. How does AvenDATA prove data integrity? Value check in Results mask of the view Bank master data

23. How does AvenDATA prove data integrity? Selection of the view Accounting documents on the fields Document number, Fiscal year and accounting area

24. How does AvenDATA prove data integrity? Value check in Results mask of the view Accounting documents

25. How does AvenDATA prove data integrity? Selection of the view Material master on the field Material number

26. How does AvenDATA prove data integrity? Value check in Results mask of the view Material master

27. Which export functions does the ViewBox offer to meet the Z3 requirements, among others? The export function DART Ensuring the Query options for department and external Examiner (export center for Data carrier transfer) Any DART segments FI, CO, SD etc. can ad hoc filtered on fiscal year, Client and company code, to provide Predefined column selection to operate the manufacturer-specific interface for IDEA

28. How can documents be integrated? Option-1 Complete extraction for archiving shutdown or relief • Extraction of the documents • Hashing of the receipts • Migration of receipts in ViewBox • Keywording and drill-down functionality

29. How can documents be integrated? Option-2 Link to the optical archive Result Ensuring access to the documents using the ViewBox

30. How can documents be called up again in the ViewBox? Entry via Document number in the view Accounting documents

31. How can documents be called up again in the ViewBox? Document preview in the document archive

32. How can documents be called up again in the ViewBox? Receipt view in the area Document archive

33. How are the legal requirements met? • Description of the procedure including all work steps in the context of archiving • Proof of data completeness, data integrity and revision security • Description of the hardware and software used • Process documentation can be called up directly within the ViewBox Result Fulfilment of the requirements according to GoBD for submission for auditors or auditors

34. How are the basics of dealing with the archive conveyed? • Training of the department in handling ViewBox and administration of user management • Takeover in subsequent operation

35. What are the minimum requirements for on premise use of the archive? 2 Possible Operational Concepts • Delivery as a virtual machine • 8 GB of RAM • Processor: 4-core processor • Storage space: depending on the amount of storage on the • Database (SSD is recommended for optimal performance) • Operating system: from Windows Server 2012 • Software: IIS Server 8.0, MVC4 Framework, .Net Framework 4.5, • Database server: MySQL 5.7 (recommended) A On Premise solution as in-house operation with the following technical Requirements: These are minimum requirements and higher

36. How can the ViewBox be accessed in hosting? Hosting in the data centre of AvenDATA GmbH (e-shelter), Berlin with the following access options: B • Static Lan2Lan VPN connection or a • VPN connection using the Cisco client • Note: The data center is certified according to ISO 27001, ISO 50001 and ISO 9001 • There is also the option of using a dedicated server

37. How does AvenDATA deal with data security? In addition to the certification of the data center, AvenDATA audited several times Result • Compliance with security standards (Patch management, vulnerability scans, Malware scanner...) • Documentation of the internal IT processes in JIRA and Confluence • Daily, weekly and monthly checklist the IT administration • Continuous training and further development of all business areas • Policies and many more …

38. How are the requirements of the General Data Protection Regulation met? Module for Data erasure within the ViewBox The ViewBox offers - in addition to a locking concept at data record level - a comprehensive deletion concept at system and annual level

39. What do customers say about AvenDATA? “ In the past few years we different legacy systems, resulting from acquisitions and system consolidations archive together with AvenDATA, then switch off and IT costs for the continued operation of legacy systems save on.” “As part of a merger and a We have the resulting IT system consolidation Archiving solution from the house AvenDATA used to create a wide variety of Decommission legacy systems. It acted it is both structured and unstructured data generated using the ViewBox software successfully archived could become.” “We keep coming back to the in the last few years Legacy systems through the use of the Archiving the ViewBox archive software and then switch off. The solution could be for both structured as well as unstructured Data are used.”

40. What do customers say about AvenDATA? “ Due to system integration With AvenDATA, we were able to successfully build an old system for one of our Archive subsidiaries and then switch off.” “ In cooperation with the company We were able to successfully use AvenDATA and resource-saving data archive a SAP legacy system.” “With the help of AvenDATA, Alpiq already has carried out several projects for archiving legacy SAP data. the The motivation was different in each case: sometimes it was subsets of a SAP system, which in the case of a sold part of the company in its SAP System, which is now safely stored with AvenDATA for revision purposes, another time it was about a dissolve entire old SAP system, in order to drastically reduce the operating costs to reduce”

41. What do customers say about AvenDATA? “With the archiving solution ViewBox We could use AvenDATA in last year compliant with the regulatory requirements successful and efficient our SAP Archive old data.” “The archiving solution ViewBox we could use different Shut down legacy systems - without the Access to those subject to retention Losing legacy data.” “Together with AvenDATA our SAP system is archived.” “To get the most out of a digital To be prepared for external audits, has Atos Origin, AvenDATA GmbH with the configuration of your SAP DART Module. Atos Origin is through this uncomplicated and safe solution ideally for a digital tax audit prepared.” “With the ViewBox from AvenDATA we were able to successfully build an old one Archive financial accounting system and then the old system switch off.”

42. Who are other customers? • Allianz Global Invest Kapitalanlagegesellschaft GmbH • ARAG SE • ALSO Germany GmbH • Axalta Coating Systems • Baloise Group • BlackRock Asset Management Deutschland AG • Company de Saint-Gobain • DuPont de Nemours (Germany) GmbH • Electrolux Group • GEHE Pharma Handel GmbH

43. Who are other customers? • Joey's Pizza Service (Germany) GmbH • JCI Beteiligungs GmbH • Magna International Inc. • Moben GmbH & Co. KG • Müller Wholesale Ltd. & Co. KG • Nestlé Germany AG • Otto (GmbH & Co KG) • SEB Asset Management AG • Solarworld AG and many other well-known companies...

44. For example, which systems has AvenDATA already archived? Nr. System Nr. System Nr. System Nr. System

45. For example, which systems has AvenDATA already archived? Nr. System Nr. System Nr. System Nr. System

46. What features does the ViewBox offer from an IT perspective? IT security features Active Directory connection Audit trail / logging Data encryption Advanced password settings Role and user management Single Sign On (SSO) 2-phase authentication via email

47. What features does the ViewBox offer from a business perspective? User features Document integration Drill-down functions Export Center Complex filter Sum function Validation function Input help function

48. What savings potential does the ViewBox offer? The shutdown of legacy systems after previous archiving means significant cost reductions for our customers on the IT budget

49. What savings potential does the ViewBox offer? • Termination of the licenses for the application of the legacy system • Termination of the database licenses for the legacy system • Shutting down the infrastructure (server licenses, electricity, etc.) • Termination of support contracts • Relief of internal IT resources to maintain the • Legacy systems (patches, update operating systems, etc.)

50. What advantages does a project with AvenDATA offer you? • Unique investment • Shutdown of the legacy system • Legally compliant Archiving • Worldwide Reference projects • No License costs • No technical Know-how required • Enormous Cost efficiency • Fixed price solution