COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Cape Cod Gunny on 15 Aug 2019 12:04:29 PM

Title: How to setup and run a trigger based event from a non-Cognos server
Post by: Cape Cod Gunny on 15 Aug 2019 12:04:29 PM
Good afternoon,

I have an ETL process that runs as part of a script. I want to fire off a report based on when the ETL process finishes. I was able to get this working using a trigger by following the example below:

https://www-01.ibm.com/support/docview.wss?uid=swg21370591 (https://www-01.ibm.com/support/docview.wss?uid=swg21370591)

However, I am unable to put this into practice in my environment because the "Username" and "Password" are exposed as part of the command line.

Is there a way to accomplish this same thing without exposing the "Username" and "Password"?

Thank you,
Mike
Title: Re: How to setup and run a trigger based event from a non-Cognos server
Post by: Cape Cod Gunny on 27 Aug 2019 03:46:39 PM
Anybody?
Title: Re: How to setup and run a trigger based event from a non-Cognos server
Post by: dougp on 28 Aug 2019 10:19:27 AM
I created a .bat file that hard-codes the URL, user name, password and directory namespace.

All the ETL process calls is
MyTrigger.bat <triggername>

So the user name and password are in the .bat file, but not exposed in the ETL code.

Only about 3 people (plus the service account that runs the ETL) have access to read the contents of the EventTrigger folder.