netweaver data management process
DESCRIPTION
how to move data about your landscapeTRANSCRIPT
…I am doing some user demo’s.
How do I get a professional demo without releasing transports?
…I don’t have enough Master Data to unit test.
How do get clean Master data into Development?
…Not another System Copy!
How many more System copies can we afford?
Occasional users often lack the specialized knowledge needed to locate and act on data in enterprise applications
We need a sustainable and cost effective SAP Data Management strategy to improve productivity and return on software investments
Common But Difficult Data Management ChallengeMany people, same requirement
Current AusPost Data Management ToolboxSeveral tools, but no single effective solution
Tested Tools Manual data entry
Client copy
ALE distribution models
Test Data Migration Services (TDMS)
Flash Copy SE
Homogenous System Copies
Client transport
R3Trans
Untested Tools CATT and eCATT
RFC enabled custom built programs
Other third party tools
Mainstream tools used more than once at Australia Post…
Tools which have been untested or require additional licensing or programming effort…
Compatibility MatrixWhich data management tool for which requirement
Selective Copy
Large Volume
Disruptive Data Integrity
Effort In House Skill
Complete Stack
Technical Difficulty
TDMS Yes Possibly Yes Yes High Little ERP, BI, CRM
High
Client Copy No No Yes Yes Medium
Yes Yes Medium
Client Transport No No Yes Yes Medium
Yes Yes Medium
ABAP Program Yes No No Yes Medium
Yes Yes Medium
CATT & eCATT Yes No No Yes Low Little Yes Low
R3Trans Yes No Yes No Low Yes Yes Medium
Flash Copy SE No Yes No Yes High Yes Yes Low
Manual Data Entry Yes No No Yes High Yes Yes Low
Data Management Tool evaluationTDMS
Disadvantages Can be slow when working though large source systemsVery slow when taking transaction dataNo EP or PI supportSensitive data is copied (might need scrambling or complex authorization)Production systems are growing (storage costs will blow out)Specialized knowledge required (need to skill up)
Advantages Shell creation - Repository and client independent data onlyMaster and configuration data onlyMaster and configuration data in addition to time slice of transactional data TDMS for HCM (PA and OM data)Some BI and CRM copy functionalityNo Post copy tasks to be performedNo need to release open TransportsNo need to re-apply TransportsNo loss of Repository change historyPossibility of NetApp disk technology improvementsCould create a TDMS ‘lean’ client for jumping other systems
Data Management Tool evaluationClient Copy and Client Transport
Disadvantages Can be slow when working though large source systemsNot recommended for clients > 1gbNeed temporary workspace on disk for export filesNo EP or PI supportSensitive data is copied (might need scrambling or complex authorization)Production systems are growing (storage costs will blow out) Post copy tasks take time (users, interfaces, BDLS, BI connections etc)Open transports need to be releasedTransports need to be re-appliedRepository objects lose change history
Advantages Well known by Basis teamWill be fast for smaller source clientsWorks for all ABAP based systems
Data Management Tool evaluationCustom ABAP program
Disadvantages Development costs and timeProduction systems are growing (storage costs will blow out)Created maintenance and support overhead Need a highly skilled resourceNot recommended or supported by SAP
Advantages Most development staff are well skilled at AusPostCan take selective data regularly Can be coded for entire NetWeaver stackSensitive data can be scrambled on copyNo Post copy tasks to be performedNo need to release open TransportsNo need to re-apply TransportsNo loss of Repository change history
Data Management Tool evaluationCATT and eCATT
Disadvantages Can be slow when working though large transaction volumesNot recommended for large data requirementsNot widely used at AusPost
Advantages Can take selective transactions quicklyCan be re-used by testing teamWell established and free SAP toolFast and accurateCan be coded for entire NetWeaver stackNo Post copy tasks to be performedNo need to release open TransportsNo need to re-apply TransportsNo loss of Repository change historySensitive data can be scrambled on data entry
Data Management Tool evaluationR3Trans
Disadvantages Can be slow when working though large tablesNot recommended for tables > 1gbNeed temporary workspace on disk for export filesSensitive data is copied (might need scrambling or complex authorization)Production systems are growing (storage costs will blow out) Not “officially” supported by SAP
Advantages Can take selective tables quicklyWell known by Basis teamWill be fast for smaller source clientsCan be coded for entire NetWeaver stackNo Post copy tasks to be performedNo need to release open TransportsNo need to re-apply TransportsNo loss of Repository change historyGreat for “Z” tables
Data Management Tool evaluationFlash Copy SE (or full system copy)
Disadvantages Production systems are growing (storage costs may blow out)Post copy tasks take time (users, interfaces, BDLS, BI connections etc)Open transports need to be releasedTransports need to be re-appliedRepository objects lose change historySensitive data is copied (might need scrambling or complex authorization)Technology establishment takes some time
Advantages Easy to perform once technology is establishedProven track record for Finance deploymentEnough existing infrastructure for the entire Production landscapeSustainable approachApproved by Enterprise Architecture as a strategically sound approach
Data Management Tool evaluationManual Data entry
Disadvantages Can be slow when working though large transaction volumesNot recommended for large data requirements
Advantages Can take selective transactions quicklyCan be re-used by testing teamWell established process to get data into the SAP systemCan be performed for the entire NetWeaver stackNo Post copy tasks to be performedNo need to release open TransportsNo need to re-apply TransportsNo loss of Repository change historySensitive data is manually scrambled on data entry
Low volume Medium volume
Which Data Management tool should be used?Depends on data volume and copy frequency
High volume
High data volumes will make lower Tiered products unattractive Higher Tiered products can be overkill for low data volumes Data copy frequency will often determine the most appropriate Product All data management Products must be mastered by SAP Services
Tier 1 products
CATT and eCATT
Custom ABAP
Manual Data Entry
Tier 2 Products
R3Trans
Client Copy
Client Transport
Tier 3 Products
TDMS
Tier 4 Products
Flash Copy SE
Full System Copy
oft
ense
ldo
m