Can Fast Data Masker (FDM) and Datamaker mask data that is in BLOB/CLOB and LONG Datatype formats?
CA Test Data Manager (TDM)- Fast Data Masker (FDM) and Datamaker.
Masking scripts for CLOB and BLOB with Oracle is supported as of FDM 184.108.40.206. Most customers use CLOB as a replacement for the Long data type since it is no longer supported by Oracle.
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 the type of data you want to mask for example .pdf or .gif.
See this documentation for more details: https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/reference/masking-functions-and-parameters.html.
The CLOB data type is supported in Datamaker for creating test data marts and as a filter option in creating transformation maps.
The BLOB variable is supported in transformation maps.
See 'DateTime expression function' in:
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:
How to Submit an Enhancement Request for Test Data Manager (Knowledge Base Articles - 9611)
Currently, there is no support for the LONG datatype for oracle is this is provided by Oracle only for Backward compatibility.
The LONG datatype stores variable-length character strings containing up to two gigabytes, but with many restrictions.
This datatype is provided for backward compatibility with existing applications; in general, new applications should use CLOB and NCLOB datatypes to store large amounts of character data.
There is a video attached on doing masking on CLOB and BLOB using FDM on oracle.