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?
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