Test Data Manager

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

    Posted Mar 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 Mar 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 Apr 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 Apr 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 Apr 13, 2021 08:58 AM
    Hi Scott,

    Any update on this.

    Thanks,
    Aadhavan


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

    Broadcom Employee
    Posted Apr 13, 2021 12:54 PM
    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 Apr 15, 2021 06:01 AM
    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 Apr 16, 2021 03:47 PM
    @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 May 07, 2021 09:12 AM
    Thanks Scott. Will try that .