ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

FDM: Handling BLOB/CLOB/LONG data Type

book

Article ID: 72365

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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

Environment

CA Test Data Manager (TDM)- Fast Data Masker (FDM) and Datamaker.
FDRM 4.9X
TDM 4.9.x

Resolution

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. 

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

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://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/provisioning-test-data/configure-test-data-reservation-service/configure-form-based-test-data-reservation-service/test-matching-and-re-matching/construct-test-data-mart.html
and
https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/reference/filter-options-for-transformation-maps.html

The BLOB variable is supported in transformation maps.
See 'DateTime expression function' in:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/reference/filter-options-for-transformation-maps.html

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)
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=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.

https://docs.oracle.com/cd/A58617_01/server.804/a58241/ch5.htm#:~:text=The%20LONG%20datatype%20stores%20variable,gigabytes%2C%20but%20with%20many%20restrictions.&text=This%20datatype%20is%20provided%20for,large%20amounts%20of%20character%20data.

 

Additional Information

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

Attachments

Broadcom CA TDM Oracle CLOB and BLOB masking_1605542894750.mp4 get_app