SAP Test Data Migration Server (TDMS): Data Scrambling
Many of us are aware of SAP TDMS i.e. Test Data Migration server. It is very vast and could be treated as a small world in SAP universe. I would like to share a little overview about DATA Scrambling in SAP TDMS in my very first blog in SCN forum.
What is TDMS?
SAP Test Data Migration Server is a high speed data extraction tool using which one can transfer relevant business data from sender (production) to nonproductive system.
Data Scrambling in TDMS
What is Data Scrambling?
Data scrambling is a security measure designed to protect confidential and sensitive data from both internal and external threats by masking sensitive data to prevent the risk of exposing it to unauthorized users.
In general term we can say, the data is encoded to prevent unauthorized access and which can be decoded by authorized personnel only.
There are two scenarios to perform Data Scrambling:
- Stand-Alone Scrambling: In this scenario the data is scrambled in the system but not transfer in any another system.
- Scrambling During Data Transfer: In this scenario SAP TDMS transfer the selected data from the source system to data cluster in source system and scramble the data, once the data get scrambled SAP TDMS transfer it to the receiver system.
SAP provides a GUI to design & develop objects to scramble data. This platform is used across all the applications running SAP TDMS and can be accessed through TDMS work center using transaction code TDMS.
Customizing scrambling needs the following scrambling object to be created:
- Solution Category
- Super Group
- Scrambling Rule
- Global Mapping
TDMS Work Center
Solution categories are used to differentiate scrambling objects. As we have single scrambling platform (TDMS work center), the solution categories identify the scrambling objects to be used in particular TDMS packages. For example, any object created with the solution category for HCM (SAP_HCM) can only be used by HCM packages.
Solution Category available with SAP TDMS
Manually new solution category could be also defined.
Scrambling Supergroup and Groups: Scrambling supergroups and groups facilitate the grouping of related rules for easy execution of actions such as activating or deactivating a group of rules together. Supergroups are the root (top) elements of the tree and can contain both groups and rules. A multi-level nesting of groups is possible, where groups can contain groups that in turn contain further groups.
Entering Supergroup Parameters
Scrambling Rules: All technical information required to scramble the data is contained in Scrambling Rules.
The Scrambling Rule contains following Basic and Expert technical information:-
Basic Technical Information:-
- Scrambling Type
- Table Name/Field Name
- Primary Table Field
- Key sets
Expert Technical Information:-
- Routine Names
- Include Names
- Condition sets
- Technical Identifier
- Scrambling Function Modules
The Scrambling platform makes available various scrambling types that can be used to scramble data.
- Delete Value:
- Fixed Value:
- Manual 1:1 Mapping:
- No mapping:
- Number Conversion:
- Random Selection Table with 1 Column:
- Value Range Table:
- Random Table for Time Periods:
Global Mapping: – One can assign a global mapping to several scrambling rules. Global mapping is typically used for the scrambling of a random selection table with multiple columns, where multiple rules can use the same mapping to scramble data consistently.
Use this scrambling type to assign random, meaningful values to more than one related field.
You could have a random table with any number of columns columns. You can choose any of them based on the number of columns you want to maintain in the lookup table.
The Lookup Table:
The term lookup table refers to the table where you enter the mapping values for a scrambling type.
The lookup table appears for the following scrambling types:
- Random Table with N Columns
- Manual 1 To 1 Mapping
- Random Table for Time Periods
- Value Range Table