sap test data including data scrambling
TRANSCRIPT
Copyright 2015 by EPI-USE Systems Limited
Confidential and proprietary
SAP Test Data including data scrambling
Isa Beck – Technical Consultant 23rd March 2015
Copyright 2015 by EPI-USE Systems Limited
Introduction to EPI-USE Labs
▪ Part of the EPI-USE Group
(1000+ employees)
135+ employees 35% = R&D
▪ SAP data-solution experts developing third-party products
▪ Our team: of which
Copyright 2015 by EPI-USE Systems Limited
Landscape Optimisation
▪ Data Sync Manager (DSM)
▪ System Builder
▪ Client Sync
▪ Object Sync
▪ Data Secure
ERP, CRM, SRM, GTS, BW, SCM,
NW
(including HANA)
Human Capital Management
▪ Query Manager
▪ Variance Monitor
Our Products
Copyright 2013 by EPI-USE Systems Limited
Visualising the problem
New Data
Older/Used Data
Oldest/Used Data
DEV
PROD QA QA Refresh
Footprint increases
Old data in Dev
DEV QA PROD Go-live
DEV
PROD
QA Production continues to grow
Data quality disparity across systems
‘Can someone create data for my project?’
DEV QA
PROD Production grows
Users need good data in QA
Tim
e
And this cycle continues!
Copyright 2013 by EPI-USE Systems Limited
Visualising the problem 2
DEV
PROD
ECC
QA
DEV
PR
OD
SRM
QA
DEV
PR
OD
CR
M
QA
DEV
PROD
BW
QA
P
I
Not 1 but MANY landscapes
- Magnifies problem
- Some landscapes far more
complex than simple 3
system
And .. They are integrated
- Increases refresh times
- Complicates data creation
Copyright 2013 by EPI-USE Systems Limited
Summary - Business Challenges
Old/Inconsistent Data in Testing (QA), Training
and Dev Environments
Long downtimes for system copy, rebuild &
refresh
Non-optimized data storage (too much storage)
Data Security and Compliance risks
Users don’t have good data when
and where they need it!
Copyright 2013 by EPI-USE Systems Limited
Core Concepts
Planned data copies
Well defined data profiles
Dev Prod QA
On-demand data copy
Executed by user community
Switch from FULL SYSTEM COPY refresh approach to DATA LEVEL refresh
Create and maintain calendar of Client Level Data Level Refreshes (aligned
with infrastructure maintenance and upgrade projects)
Provide mechanism for ‘On-demand’ data synchronization in between Data
Refreshes executed by the user community
Embed data level scrambling/masking as part of data copies into non-production
systems
Dev Prod QA
Copyright 2013 by EPI-USE Systems Limited
Data for Users
Predictable
What: Which data will be available?
Where: In which systems?
When: On what schedule?
On-Demand
Move specific SAP data as needed
This allows users to plan their projects, testing,
training and support in a reliable and consistent way
Copyright 2013 by EPI-USE Systems Limited
Test Data Landscape
Must be continuous
Data always changing in production and being
consumed in QA, Training and Dev
Data needs to move from Production downstream the
landscape periodically
Footprint reduction
Data volumes in production always increasing
1. Continuous archiving
2. Refresh clients only in Pre-Prod, QA, Dev with sliced
production (not full copy)
Copyright 2013 by EPI-USE Systems Limited
Data consistency across systems
Many SAP customers have multiple SAP
solutions in their landscape in addition to ERP
such as SRM, CRM, SCM, BW.
These systems are integrated, and copying data
from a single system may cause data
inconsistencies.
1. Data extracts and loads must be done in temporal
synchronicity
2. Interfaces between systems must be understood and
typically paused during extracts and loads
Copyright 2013 by EPI-USE Systems Limited
DSM and your SAP Data Strategy
DSM (Data Sync Manager)
brings together the tools
needed to implement an
optimal SAP Test Data
strategy
EPI USE Labs Services team
will assist you in creating a
tailored Strategy and
associated execution plan
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Data Sync Manager
System Builder
Client Sync
Object Sync
Data Secure
Data Sync Manager
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Key points of DSM
SAP Certified solution
One single transport
No server or middleware required
Simple implementation
Easy to use via an intuitive interface
Complete SAP solution (for ERP, BW, SRM, CRM, SCM, GTS, NW; including HANA)
Industry Solutions (standard in ERP)
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
How Data Sync Manager works
Client-dependent Customization
Ap
plic
ation D
ata
Transaction Data
Master Data
Use
r M
aste
rs
Repository
Client-independent
Customization System Builder
Client Sync Object Sync
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
How Data Sync Manager works
Client-dependent Customization
Ap
plic
ation D
ata
Transaction Data
Master Data
Use
r M
aste
rs
Repository
Client-independent
Customization
Data Secure
Client Sync
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Client Sync
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Business benefits of Client Sync
Save storage space
Instead of a system copy, copy over the last 3 months of data, for example, to create lean non-production clients
Reduce Basis workload
Create new systems in up to 90% less time
Less downtime enables developers and support teams to do better testing with fewer transports to process
Reduce copy time and downtime
Downtime is eliminated, so production interruptions are minimal
No freezes of the DEV system are needed while test data is refreshed
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
How does Client Sync reduce
space?
Time slice (copy a period of transactional data) -
reduce space needed by over 70%
Enterprise slice (copy only the company codes you
want)
Master data/Customising only (sandbox / training /
dev)
Data exclusions (e.g. DMS, HCM)
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
consistent client
Document flows in Client Sync
Time slice
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
consistent client
Document flows in Client Sync
Time slice
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
consistent
client
Document flows in Client Sync
Enterprise slice
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
consistent
client
Document flows in Client Sync
Enterprise slice
Data Sync Manager
Client Sync Demonstration
© 2010 EPI-USE Systems Limited. All rights reserved.
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Object Sync Component
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
26
Production support issues Accurately and quickly recreate the issue in a QA environment
Test the issue and find a solution (make multiple copies!)
Testing Developments and Configuration Copy real business data to Development
Correct configuration before transporting to QAS system
Training Environments Use cloning to create multiple copies of objects
Create a file of data for re-import
Support pack and Upgrade testing Test support pack changes with real data (SAP HCM)
Copies data from a lower to higher release of SAP (e.g. 4.6c to ECC6.0 EHP7)
Business Benefits - Object Sync
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Masking with Data Secure
Scrambles data in non-production systems
Standalone - used on any client
Integrated - used with Client Sync
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Masking with Data Secure
Scrambles data in non-production systems
Standalone - used on any client
Integrated - used with Client Sync
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Masking with Data Secure
Scrambles data in non-production systems
Standalone - used on any client
Integrated - used with Client Sync
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Data Secure
Profiles determine the scrambling rules to be executed
(combination of objects/fields)
Rules are provided by EPI-USE Labs for
Employee
Customer
Vendor
Business Partner
Addresses
Completely customisable - add the rules and/or fields you want
to scramble
Copyright 2014 by EPI-USE Systems
Limited
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
DSM System Builder Creates a fully functioning system shell!
Save time creating non-
production systems for
development, training or quality
control.
Make a complete export of:
all repository objects
client-independent data
with the following clients:
Client 000
Client 001 (optional)
Client 066
Copyright 2015 by EPI-USE Systems Limited. Confidential and proprietary
Website:
www.epiuselabs.com
Support site:
http://support.epiuse.com
Sales team:
Questions