Test Data Manager

  • 1.  Create a custom function for use in the data painter

    Posted Feb 13, 2018 09:58 AM

    We have built a custom function that can be called as a stored procedure in SQL Server.  We want to be able to utilize this within data painter as a function during the data generation process.  Is there a best practice for where to store this (as a dll) on the repo server and/or how to save this as a function?



  • 2.  Re: Create a custom function for use in the data painter
    Best Answer

    Posted Feb 21, 2018 09:05 AM

    Hello Adam,

    Actually We can't store/create custom build functions for Datamaker.

     

    At the moment, We can only do that at Fast Data Masker:

    Create Custom Masking Functions - CA Test Data Manager - 4.4 - CA Technologies Documentation 

     

    You can still use your procedure with the built in EXECSQLPROC function:

    Data Generation Functions and Parameters - CA Test Data Manager - 4.4 - CA Technologies Documentation 

     

    Regards,

    Artur