Test Data Manager

 View Only

CA TDM & PowerDesigner Integration

  • 1.  CA TDM & PowerDesigner Integration

    Posted Jul 30, 2019 06:36 AM
    Hi All,

    We integrated CA TDM with SAP PowerDesigner to get Masking Rules, Syntethic Data Generation Rules and Syncronize Relationships.

    Basically, It lets you to get information for a project in TDM which includes, Columns and Tables to be Masked, Masking Description, Data Generation Description and Data Model Definitions (Logical Relationships).

    All the above information resides in SAP PowerDesigner. 

    Integration set "Transformation" as "CheckedbyPowerDesigner" and put rule definition in "Notes" for columns in Project Transformation Maps to let TDM Admins to decide best masking function for desired columns.

    It also set "Remarks" with Data Generation Rule Definition to let TDM Admins to set best generation rule for desired columns. 

    By execution SyncRelationships Job, It gets the relationship information from PowerDesigner and add those relationships into Datamaker. So, TDM Admins, now, ready to use that data model for data provisioning. 

    Below you may find some screenshots about the process.

    1. Service Offering to get Masking and Data Generation rules



    2. Transformation Map (Datamaker) after Execution


    3. Data Generation Rules Description




    4. Service Offering to Sync Relationships



    5. SyncRelationship Job - Pre-Execution vs Post-Execution



    ------------------------------
    Managing Consultant
    GUNITTECH
    ------------------------------