Skip to Content

TDMS (Testing Data Migration Server) – Data Scrambling Made Easy

Many people may heard of TDMS as a tool for copy data from production system to testing system. However, they may not aware that one of the significant features in TDMS is that it can help to scramble or convert sensitive data before copy into to the testing system so that any important or sensitive information will not fall into wrong hands in case someone decided to steal the data from testing system and sell it to your company’s competitors.  In order to use this important feature, all you have to do is to define the import/export parameter, enter some simple abap coding and define which field name and data type to be scramble.

The demonstration in this document will show how simple it is to scramble the sensitive data with simple coding and little knowledge of abap with a few mouse click.

Transaction: CNV_MBT_TDMS

1. Create Project

2. Create Sub-Project

3. Create Package (Time Reduction or Time & Company Reduction)

4. Change view to extended view

5. Follow the TDMS Steps until you reach the point to data scramble

https://docs.google.com/document/d/1rntPfg8iSF1-6vA3ZuGhZrmbCmKZG50dTGRNuWfWJlk/edit?usp=sharing

Define Scramble & Conversion Rule

Source System –> Transaction: SE11

Check for Field name and data domain before configured scramble rule

https://docs.google.com/document/d/1NIHuXnxVxAi-ItUrlZY84Arjj_MQgOxJ-DOudY_VtaY/edit?usp=sharing

Example:

Field name: IDNUM

Domain: CHAR30

Note: These information will be required for define data scrambling rule

TDMS Server –> Transaction: CNV_MBT_TDMS

Select Maintain Conversion and Scrambling rules (option), click Execute

http://docs.google.com/File?id=dfjvgvkk_61ckdfd2f5_bhttps://docs.google.com/document/d/1vFdTzbLkdKzMA5GR_WK1kFF3xJmWxyufHx-xkogWZcs/edit?usp=sharing

Tab 1: Check Option maintain consistency scrambling

https://docs.google.com/document/d/1vFdTzbLkdKzMA5GR_WK1kFF3xJmWxyufHx-xkogWZcs/edit?usp=sharing

Tab 2: Define Import & Export Parameter for Scramble rule base on Data Domain for the field to be scrambled

https://docs.google.com/document/d/1fGW1aE3XWOlzUnwQxgTGWvFwSuxTbYCxtiBTvq8nXiM/edit?usp=sharing

Tab 3: Click Source Code Tab – System automatically generated the required code for maintain consistency scrambling.

https://docs.google.com/document/d/1zEWNxIrRzuvONlXtD9fP0zF1CpfWQR2PETF8KfeTtJ4/edit?usp=sharing

Add your own code for data scrambling

https://docs.google.com/document/d/1XFG1YLL1cyS3Qqg0ZZXhaSEGKHqXqmjRo1GsoMqniWg/edit?usp=sharing

Tab 4: Enter Field Name and Domain type

Click Save. and continue TDMS Steps.

https://docs.google.com/document/d/1eauVS_elDfOVMpGOhdGjOd1DgsAdv97PE2xsP2zIQDs/edit?usp=sharing

You just defined the scramble rules with domain type.

Since this rule is defined in domain type, TDMS will also scramble other tables with same field name and using the same data domain. Therefore, you don’t have to worry that the sensitive data are missed for scrambling in case this fieldname’s data may be updated in multiple tables.

Refer to Screen Capture in the Attached Link: https://drive.google.com/file/d/0B6cH-wDUSTL0NWs5RkI1eGRUYzQ/edit?usp=sharing

To Learn about the benefits of using TDMS, you may refer to my Presentation in SAP Info Day:

TDMS Presentation.2009.09.24.rev.1.pdf – Google Drive

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply