We are struggling with triggers. We believe that the trigger bat file needs the administrator account username & password which is against the Sarbanes Oxley act.

If anyone has any information or ideas please let me know.

Thanks

You could put the trigger stuff onto a Unix/Linux system and therefore run outside of Cognos, see here https://www.ibm.com/support/pages/how-setup-and-run-trigger-based-event-non-cognos-server

Then have a file with username and password, create a script (batch, perl etc) that read username and password from that file to use it in the trigger command. And finally secure the file so that only this user has access to it (probably root). Just an idea.

Thanks, but we don't have that available in our environment.

OK, on Linux it is a bit easier with such permissions. But it is possible on Windows as well. Secure a file for just one or two super admins who run the trigger. But for example "perl" exist for Windows. Or use any other script language that parse such user/pwd from a file and use it in a command. Hope this info helps a bit, unfortunately I do not have a perl script that I can share. Fingers crossed someone else has other good ideas and probably sample scripts in terms they prefer that way too. Good luck.

Thanks for the help, It would be helpful if Analytics Users could execute the trigger, don't understand why it has to be a administrator.....