If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to setup and run a trigger based event from a non-Cognos server

Started by Cape Cod Gunny, 15 Aug 2019 12:04:29 PM

Previous topic - Next topic

Cape Cod Gunny

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

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
Michael Riley
Marine Corps Gunnery Sergeant (Retired)

"We may never pass this way again!"

Cape Cod Gunny

Michael Riley
Marine Corps Gunnery Sergeant (Retired)

"We may never pass this way again!"

dougp

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.