Test Data Manager

  • 1.  Subset extract via Self Service Catalog of TDM Portal

    Posted 08-22-2017 09:27 AM

    Hi all!

    Is it possibly request subset from Source using Self Service Catalog of TDM Portal. And using variables for user input. For example, user need to get all records from Source DB from table "People" where field first_name is 'Jon' and publish this record to the Target DB.  

     

    Thanks in advance.



  • 2.  Re: Subset extract via Self Service Catalog of TDM Portal
    Best Answer

    Broadcom Employee
    Posted 08-22-2017 02:13 PM

    Elka,

     

    I don't believe this is something you can do directly. A subset is not something that is directly callable. However, there are a number of other ways to accomplish this, depending on the volume of the data that is involved. If you were expecting a result set of 5k or less, you could probably create a clone data pool. To do this, you would create a subset extract definition with the tables you wanted included. In the extract definition, include the variable you want to use for the name field where you want to match 'Jon' or whatever other name interests you. Then, create a cloning data pool. When you set up the data pool, don't use any transformations. It will pull all rows that match the extract definition.

     

    If you have a larger data set, you may be better off using a post-publish action and having Javelin orchestrate the subset for you.

     

    Thanks,

    Brian



  • 3.  Re: Subset extract via Self Service Catalog of TDM Portal

    Posted 08-23-2017 06:20 AM

    Brian_Weissman,

    thank you very mach for you explanation. It's exatly what i need.