Test Data Manager

We have 2 db2 databases - production and test database (on Unix). Our requirement is to extract production data and mask it before loading it to the test db2 instance. Its a direct one-to-one mapping. 

We are able to create masking algorithm in FDM and also mask existing data in test db2 database. However, in the new scenario, masking has be to carried out before the data is loaded into the test environment. The process of extraction and masking should happen simultaneously from production db2.

In GT Subset, on selecting db2 as the system, the option to specify masking logic is not displayed. 

Kindly let us know how this action can be performed.

Hi Abhinav,

We currently do not support masking and sub-setting in a single script for the DB2 platform.

The only databases we support for both masking and sub-setting are Teradata, Oracle and MS SQL Server.

If you wish to raise this as an enhancement request, please post an "Idea" on the DevTest Community ("CA Test Data Manager" category).

Thanks,

Sameer

thank you Sameer_Chandragiri