FDM: Handling BLOB/CLOB/LONG data Type
search cancel

FDM: Handling BLOB/CLOB/LONG data Type


Article ID: 72365


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Can Fast Data Masker (FDM) and Datamaker mask data that is in BLOB/CLOB and LONG Datatype formats?


CA Test Data Manager (TDM) 4.9 and greater
Fast Data Masker (FDM) 4.9 and greater


For FDM:
Masking scripts for CLOB and BLOB with Oracle is supported as of FDM 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: 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.
For more information see:


The BLOB variable is supported in transformation maps.
For more information, see:

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


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.
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.



Additional Information

There is a video attached on doing masking on CLOB and BLOB using FDM on oracle.


Broadcom CA TDM Oracle CLOB and BLOB masking_1605542894750.mp4 get_app