FDM: Handling BLOB/CLOB data

Document ID : KB000072365
Last Modified Date : 28/02/2018
Show Technical Document Details
Question:
Can Fast Data Masker and Datamaker mask data that is in BLOB/CLOB format?
Environment:
CA Test Data Manager (TDM)- Fast Data Masker (FDM) and Datamaker.
Answer:
For FDM:
Masking scripts for CLOB and BLOB with Oracle is supported as of FDM 4.6.200.22. Most customers use CLOB as a replacement for the Long data type since it is no longer supported by Oracle. So, it does look like FDM supports CLOB and BLOB format.

If you are looking for the ability to masking JSON data stored in Oracle CLOBs, this is not yet supported, but has been added to the product backlog.
RANDOMBLOB is the only function we currently support for masking BLOB data.

The RANDOMBLOB function randomly takes BLOB data from a file in the BLOBS sub-directory and loads into this BLOB column. This must contain files of type of data you want to mask for example .pdf or .gif.
See this documentation for more details: https://docops.ca.com/ca-test-data-manager/4-4/en/reference/masking-functions-and-parameters.

For Datamaker:
The CLOB data type is supported in Datamaker for creating test data marts and as a filter option in creating transformation maps.
See: https://docops.ca.com/ca-test-data-manager/4-4/en/provisioning-test-data/configure-test-data-reservation-service/configure-form-based-test-data-reservation-service/test-matching-and-re-matching/construct-test-data-mart and https://docops.ca.com/ca-test-data-manager/4-4/en/reference/filter-options-for-transformation-maps.

The BLOB variable is supported in transformation maps.
See 'DateTime expression function' in https://docops.ca.com/ca-test-data-manager/4-4/en/reference/filter-options-for-transformation-maps/custom-filter-functions-for-transformation-maps.

If you wish to see more capabilities in either product specific to CLOB or BLOB field masking, please submit an enhancement request using the steps detailed in this document: https://support.ca.com/us/knowledge-base-articles.TEC1107947.html.