attunity gold client enables global consolidation at … · attunity gold client • attunity gold...
TRANSCRIPT
Who are BAT?• World’s second largest tobacco company founded over
100 years ago.
• Operates in approximately 186 countries.
– A number of them being emerging markets
– Has 250 brands.
• Approximately 95,000 employees (45,000 ‘knowledge workers’)
• Gross turn over £40bn per year – (£26bn taxes).
• Currently undertaking a major re-alignment of business
practices from a federated model to a centralised
business model.
Looking for consolidation of business practices and supporting IT systems.
Whilst the underlying business is the same, there is a drive for more shared services.
A heavy focus on consolidation to leverage capabilities and reduce costs through -
- Standardisation
- Enterprise class solutions
History
• SAP Estate
– 5 BW’s, 8 ERP’s, 5 HR’s, 5 > BO’s, SRM, 5 APO’s, 2
Portals and they are the ones we knew about
– Old versions with poor lifecycle management
• If not broken why upgrade? Arrrrrrr !
Transformation Project
Transformation Project in BAT
Key Facts
• Single largest SAP Project within BAT
• 6 year journey to consolidate and prepare global processes for roll-out
• 79 Instances of SAP (sandboxes, development, test, regression, and production systems.)– Single ECC >20Tb, 225,000 SAPS
– Single BW >50Tb, 220,00 SAPS
– Single APO
– 30,000+ users
Attunity Gold Client
• Attunity Gold Client is an SAP application specific
software that allows you to manage data across the
landscape
– Data copy functionality allows you to copy full master data and
subset of master/transactional data from Productive to Non-
Productive and Non-Productive to Non-Productive environments
– Data transformation functionality allows you to scramble/mask
sensitive data
– Data deletion functionality allows you to delete specific set of
records.
Background• An SAP system refresh is required when one wishes to copy one SAP
system to another
– Such as copying the current SAP Production System to a Test System
• This system copy is performed to ensure that the test system has the latest copy of production data
• Once the system refresh is complete, some post processing must take place to ensure that the test system does not behave as a production system
• System copies such as this take
– Time to plan and execute
– Large teams of specialist resources to undertake the work
– Reduce system availability – up to eight days’ down time.
Attunity Gold Client for SAP
• Attunity Gold Client for SAP is a certified SAP add-on
that allows user selectable data transfer from System A
to System B (usually Production to Non Production)
• The transfer of data can be either
– A copy of the production system with reduced transaction data
(refresh alternative)
– Intelligent Data Transfer: Allows project teams to quickly and
dynamically select and replicate user-defined subsets of SAP
application data from production and non-production sources to
non-production targets within the SAP landscape.
Two Options
Option System Copy Attunity Gold Client
DescriptionCopy the entire production system into the test system. No data selection.
Use Attunity Gold Client SAP tool to copy specific data from production system into test system, scrambling the data where needed
Pros • Proven to work
• Tool already used in BAT• Can be part of the industrial delivery model • Lower legal/audit risk• Option to automate data scrambling• Faster deployment, less system down time • Lower hardware costs.
Cons
• High risk of production data being mishandled • Effort needed to manage system copy • Remove effort to remediate data copied • T-System costs• System Downtime – up to 8 days for system copy • Cost of storage for the Transformation Project
Test systems• Unsustainable – not an industrialised solution.
• Need to develop Attunity Gold Client capability
Why Attunity Gold Client?
• Attunity Gold Client has the potential of solving two
significant issues for the Transformation Project
programs
1. The notable project risk associated with having an unsupported
production system
2. Unsustainably large test systems.
Around Technical Go-Live• As the project nears any technical go-live stages the “D” Development
system will be made ready for BAU support
• For the system to be provide effective support it must contain some test
data – to allow unit testing
• System Copy is not possible as this will make the development system
unavailable for up to 8 days – leaving production system unsupported.
Development
DTest
T
Development
D2Test
T2Regression
R
Production
P
Around Technical Go-Live• Faced with a choice of:
– Temporarily making the Development System unavailable to perform a system copy
– Or, having no test data to support unit testing
• There is a notable risk to the Production System
• Attunity Gold Client can mitigate the risk by quickly copying test data
from the Regression System R04.
Development
DTest
T
Development
D2Test
T2Regression
R
Production
P
Using Production Data
Transformation Project• All future Transformation Project go-live data loads will be made into a live
system which contains active data
• Migrating markets will often append master data already in use by the live
markets
• To ensure that the data and business functionality is deployed correctly, the
test systems need to be pre-populated with a copy of the live data
• Training systems are to be populated with test data.
Production data used to support
testing
Test data used to support training
Test
Client
Transformatio
n Project
Production
Training
Client
Test
Client
Example Using Client Copy Process
Deployment Group 1
0.5 Tb Storage 2 Tb Storage
Deployment Group 2
1 Tb Storage 4 Tb Storage
Deployment Group 3
2 Tb Storage 8 Tb Storage
Unsustainable storage
requirements
Copy everything from the
production client –four times
Transformation
Project
Production
Training
Client
Test
Client
Transformation
Project
Production
Training
Client
Test
ClientTransformation
Project
Production
Training
Client
Z
Test
Client
Example Using Attunity Gold Client
Deployment Group 1
0.5 Tb Storage 2 Tb Storage
Deployment Group 2
1 Tb Storage 2 Tb Storage
Deployment Group 3
2 Tb Storage 2 Tb Storage
More Industrialised approach - can be
repeated
Copy just what is needed
Transformation
Project
Production
Training
Client
Test
Client
Transformation
Project
ProductionTraining
Client
Test
Client
Transformation
Project
Production
Training
Client
Attunity Gold Client Service
• Since April 2013 a Gold Client service has been operational in
the Transformation Project
• Currently in place are:– Capabilities to selectively copy or scramble certain data objects
– Country and language sensitive scrambling capability to allow
anonymised data to remain in context during user testing
• The service has been used 95 times since being established
– more than once per week
• A full master data copy to support testing requirement can be
executed in under 2 days.
Attunity Gold Client Scenarios
ScenarioSource Client
Target Client Type of data
Data/Test Support Production Test/Data ClientSelected Master Data with scrambling
Training Support Test Client Training ClientAll Master Data, some transactional with scrambling
BAU SupportRegressionTest Client
RegressionTest Client
Scrambling of test data
Data Migration change of client
Data Client Test/Data ClientSelected Master Datawith scrambling
1
2
3
4
Four support scenarios have been added into the proposal:
Attunity Gold Client Success• The Gold Client service has proved to be:
– Reliable and effective
– An essential tool for moving data
– The only way to anonymise sensitive data in the Transformation Project Landscape
• Gold Client has allowed the Data Migration team to switch clients at will – removing the restrictions placed by System availability
This facility allowed the Transformation Project to maintain its aggressive delivery timelines