IT Application Decommissioning - Application Retirement Services

1
(No Transcript)
2
What can you expect from today's presentation?
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?
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?
MAIL SERVER Lotus Notes, Microsoft Exchange...
ERP-SYSTEMS ASP, JD Edwards, Oracle, Navision,
AS400
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
A000 0 a000 0
A001 0 a001 0
A002 20 a002 20
A003 525 a003 525
A004 504066 a004 504066
A005 2982 a005 2982
A006 0 a006 0
A007 66 a007 66
A008 0 a008 0
A009 0 a009 0
A010 0 a010 0
A011 33 a011 33
A012 0 a012 0
A013 8 a013 8
A014 16 a014 16
A015 0 a015 0
A016 0 a016 0
A017 1507454 a017 1507454
A018 1990 a018 1990
A019 0 a019 0
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?
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
20
How does AvenDATA map internal processes in
archiving?
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)

On Premise solution as in-house operation with
the following technical Requirements
A
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?
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
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.
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.
Together with AvenDATA our SAP system is
archived.
The archiving solution ViewBox we could use
different Shut down legacy systems - without the
Access to those subject to retention Losing
legacy data.
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?
System
Nr.
System
Nr.
System
Nr.
System
Nr.
1 4PM
2 Abacus
3 ADABAS
4 Addison
5 Agresso
6 APKF
7 Argon
8 Arriba
9 AS400
10 Avaloq
11 Axapta
12 Baan
13 Basis
14 Brain
15 Branchware
16 BS-2000
17 CARAT
18 Clinicom
19 ConCord
20 CorbasHyp
21 CSS
22 D3
23 Datev
24 DCW
25 Diamant
26 Diaprod
27 DKS
28 Documentum
29 Dogas
30 Easy Archiv
31 EDI Invoice
32 Eigenentwicklungen
33 ERP
34 Exact
35 Exchange Mailarchiv
36 FileNET
37 Fileserver
38 Fischer Software
39 FliegelData
40 Foss
41 Frontarena
42 Hamburger Software
43 HP/Unix Applikatione
44 Hyperion
45 IAS
46 IBM Content Manager
47 IBM on Demand
48 IBS
49 IFS
50 IGS
51 Infor
52 INTEGRA
53 ISF
54 IWS 400
55 IXOS
56 JD Edwards
57 JDE One World
58 KIS
59 Klinika
60 Klopotek
45
For example, which systems has AvenDATA already
archived?
System
Nr.
System
Nr.
System
Nr.
System
Nr.
61 Kondor
62 Kordoba
63 kVASy
64 L5000
65 Lexware
66 Loga
67 Lotus Notes
68 M3
69 Mainframe-System
70 MAS90
71 medico
72 MegaPlus
73 MESONIC
74 MFG/Pro
75 MHDS
76 Microsoft Dynamics
77 Movex
78 Navision
79 Oracle
80 Orgasoft
81 Oxaion
82 PI Loga
83 Paba/Q
84 Paisy
85 Peoplesoft
86 Portolan
87 Pro Alpha
88 PSI Penta
89 QAD
90 Ratioplan
91 RenCS
92 Sage
93 Sage KHK
94 SAP
95 SAP Bank Analyzer
96 SAP CRM
97 SAP HR / HCM
98 SAP IS-U
99 Schilling
100 SDV
101 SER
102 ShopFloor
103 Siemens TeamCenter
104 SIMBA
105 SISPRO
106 Soft M
107 STEEB
108 Sun
109 Trema
110 U10
111 V10
112 V3
113 Vamos
114 Varial
115 Vega
116 Vegas
117 Wohndata
118 Wilken
119 Xentis
120 Xpert
46
What features does the ViewBox offer from an IT
perspective?
Active Directory connection
IT security features
Audit trail / logging
Data encryption
Role and user management
Advanced password settings
Single Sign On (SSO)
2-phase authentication via email
47
What features does the ViewBox offer from a
business perspective?
Document integration
User features
Drill-down functions
Export Center
Sum function
Complex filter
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

51
What distinguishes AvenDATA from other archive
providers?

• AvenDATA as an IT service provider that
  exclusively focuses on archiving legacy systems
  is specialized
• Archiving project from a single source as a
  software manufacturer and service provider for
  migration
• Operational operation on premise and as cloud
  possible

52
What distinguishes AvenDATA from other archive
providers?

• Various certifications for both the archive
  software (IDW PS880) and the Hosting environment
  (ISO 27001, ISO 9001, ISO 50001)
• Large team of software developers to quickly
  respond to legal innovations or to be able to
  respond to customer requests

53
What distinguishes AvenDATA from other archive
providers?

• No license costs
• Fixed price work
• Worldwide reference projects
• Experience with over 160 different business
  applications
• Solution for structured and unstructured data
• Knowledge of the global retention periods
• Experience in various tax audits and audits

54
Conclusion

Invest Prefer your budget into that productive
applications and not in maintaining Legacy
applications.

55
Presentation ViewBox
Live Presentation of ViewBox
56
Next steps from our project experience

• Internal coordination of all responsible persons
• Inventory of existing legacy systems and possible
  ones Use cases or replacement candidates
• Determination of a project manager

57
Next steps from our project experience

• Implementation of system analysis
• Evaluation of the results and receipt of an
  archiving offer on a fixed price basis for the
  purpose of decision-making
• Archiving realization and compilation of a
  project team

58
Let's move on to the next step, do a system check
Speak Me directly at Tanja Koenig Mobile 49 (0)
160 - 890 50 60 Telephone 49 (0) 30 - 700
157 500 E-Mail t.koenig_at_avendata.com
Salzufer 8, 10587 Berlin Telefon [phone]
157 500 Telefax 49-(0)30/700 157 - 599 AG
Charlottenburg, HRB 89998 www.avendata.com