Fast Data Masker and Transformation Maps

In addition to Fast Data Masker, you can also use Datamaker transformation maps to mask the data. The approach that you select depends on your business requirements and feasibility. You can adopt one of the following approaches to masking with regards to which stage the data is masked at:
tdm44
In addition to Fast Data Masker, you can also use Datamaker transformation maps to mask the data. The approach that you select depends on your business requirements and feasibility. You can adopt one of the following approaches to masking with regards to which stage the data is masked at:
  • Using Fast Data Masker (In-place Masking)
    In this case, a typical scenario is that the production data is copied over to a staging area. Fast Data Masker points to this staging database and masks the data that resides there. This
    masked
    data is then copied over to different testing environments as required.
  • Using Transformation Maps (In-flight Masking)
    In this case, you use Datamaker transformation maps and Subset scripts. You first define a transformation map (Oracle or MSSQL) in Datamaker, create masking functions for the columns you want to mask. You use the Subset interface to create the
    masked 
    export scripts. These scripts perform masking as they export the source data to a dump file. The dump file (which contains masked data) is then imported into the target database. Testers can use the same database, which now includes masked data, for testing.
    Note:
    For mainframes, use transformation maps to mask the data.
To use HASHLOV consistent masking with MS SQL Server, download the CA TDM 4.4 scramble database for MS SQL Server from the repository installation kit. Drop the existing scramble database for MS SQL Server. For more information about data scrambling, see Data Scrambling.
Additionally, you can follow another approach where you convert your transformation map into a CSV file and use that CSV file in Fast Data Masker to do the masking. For more information, see Use Transformation Map Files.