Execute Windows Batch file from Cognos

[eballinger75]

Hi Guys,

I would like to be able to execute a windows batch file from within Cognos. Does anyone know a way to do this with any of the Cognos applications. I know this can be done with Data Manager but we are losing this tool with our move to 10.2.2. So I would like to be able to call a system command from report studio or event studio perhaps. If anyone knows a way please post.

Thanks,

[BigChris]

I've never tried it, but if you can get the batch file into a stored procedure you should be able to bring that into Cognos via Framework Manager.

[dougp]

Create a web page with server-side stuff (aspx, jsp, etc.) that runs the bat file.  Add an HTML item (or drill-through definition?) to the report page and craft it in such a way that the hyperlink includes all of the required parameters for the querystring.

[bdbits]

Executing a batch file from a stored procedure is possible, but most DBAs will not open security to enable that due to some serious security implications.

What is your batch file doing? Perhaps there is another way to accomplish what is needed.