Test Data Manager

Expand all | Collapse all

Handling user defined types in Oracle while generating data and masking

  • 1.  Handling user defined types in Oracle while generating data and masking

    Posted 03-25-2021 08:30 AM
    Hi Team,

    How to handle user defined data types in oracle database tables when generating data or masking using CA TDM? Is there any documentation/KB articles available for that?

    Thanks,
    Aadhavan


  • 2.  RE: Handling user defined types in Oracle while generating data and masking

    Posted 03-31-2021 08:40 AM
    Hi Team,

    Your inputs on this please.

    Thanks,
    Aadhavan


  • 3.  RE: Handling user defined types in Oracle while generating data and masking

    Broadcom Employee
    Posted 04-05-2021 08:55 AM
    Hi @Aadhavan Diaz   Can you provide an example of a user defined data type you are seeing (DDL or description)?   Have you tried datagen & mask and what has happened?​


  • 4.  RE: Handling user defined types in Oracle while generating data and masking

    Posted 04-05-2021 12:02 PM
    HI Scott,

    We have a User defined type as blow

    create or replace TYPE D_Type AS OBJECT (
    A INTEGER,
    B INTEGER,
    C VARCHAR2(35)
    )

    This D_Type (UDT) is used in few columns of the table as Data type. We are not able to generate data for this column in CA TDM portal, we did inflight masking where we are not able to mask the column that has the user defined types.

    Thanks,
    Aadhavan


  • 5.  RE: Handling user defined types in Oracle while generating data and masking

    Posted 25 days ago
    Hi Scott,

    Any update on this.

    Thanks,
    Aadhavan


  • 6.  RE: Handling user defined types in Oracle while generating data and masking

    Broadcom Employee
    Posted 25 days ago
    Hi @Aadhavan Diaz   As you've seen, UDTs are not natively supported in TDM;     I have a thought that you may be able to use a Stored Procedure to insert/overwrite (using EXECSQLPROC in a Generator and SQLFunction in FDM).    Have you tried those methods?​


  • 7.  RE: Handling user defined types in Oracle while generating data and masking

    Posted 23 days ago
    HI Scott,

    We have not tried that. First a stored procedure has to be created in the database for inserting data and then call that stored procedure in CA TDM by configuring the field with execsqlproc. Is that it?

    Are there any documentation or poc available for this?

    Thanks,
    Aadhavan


  • 8.  RE: Handling user defined types in Oracle while generating data and masking

    Broadcom Employee
    Posted 22 days ago
    @Aadhavan Diaz   I tried this today without success within the Generator framework.   I'd recommend you execute SQL INSERTS to populate the UDT columns within a Post-publish Action.

    FDM cannot handle the UDT, so you'll need to create your own scripting to mask.​


  • 9.  RE: Handling user defined types in Oracle while generating data and masking

    Posted yesterday
    Thanks Scott. Will try that .