I am looking to run a powershell to extract data in a stored procedure then use DMT to put it into an UD field. How do I run a stored procedure through Powershell and extract that data?
You can now run a BAQ through DMT and pipe that back through DMT. This means that you can create an external BAQ that calls the stored procedure and use that from DMT with the -Export flag. You can then run DMT to import the file that was created.
There are some examples on the Home tab when you launch DMT.
2 Likes