FDM: Handling BLOB/CLOB data
Document ID :
Last Modified Date :
Show Technical Document Details
CA Test Data Manager
Can Fast Data Masker and Datamaker mask data that is in BLOB/CLOB format?
CA Test Data Manager (TDM)- Fast Data Masker (FDM) and Datamaker.
Masking scripts for CLOB and BLOB with Oracle is supported as of FDM 18.104.22.168. 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:
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:
Was this information helpful?