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

Automate cognos schedule once informatica workflow finishes

Started by dadamdreams, 20 Jul 2016 07:18:25 AM

Previous topic - Next topic

dadamdreams

Hi,

Is there any way to automate cognos schedule, where the schedule should run when the dependent informatica workflow completes.
Please help me with this information, in case someone already implemented this.
I am currently using 10.1.1 version of cognos

Thanks

MFGF

Quote from: dadamdreams on 20 Jul 2016 07:18:25 AM
Hi,

Is there any way to automate cognos schedule, where the schedule should run when the dependent informatica workflow completes.
Please help me with this information, in case someone already implemented this.
I am currently using 10.1.1 version of cognos

Thanks

Hi,

You could perhaps look into Informatica firing a trigger to launch the schedule?

https://www-304.ibm.com/support/docview.wss?uid=swg21340069

MF.
Meep!

dadamdreams

Thanks MF
The whitepaper says to access trigger through the following command
trigger.bat http://localhost/Cognos_MRI_New/cgi-bin/cognos.cgi admin Password! "Local NT ID" trigger1

So, basically trigger1 would have a script which would connect to Informatica and get details if the workflow is succeeded or not and where this trigger1 is placed

correct me in case iam wrong.


MFGF

Quote from: dadamdreams on 20 Jul 2016 08:09:34 AM
Thanks MF
The whitepaper says to access trigger through the following command
trigger.bat http://localhost/Cognos_MRI_New/cgi-bin/cognos.cgi admin Password! "Local NT ID" trigger1

So, basically trigger1 would have a script which would connect to Informatica and get details if the workflow is succeeded or not and where this trigger1 is placed

correct me in case iam wrong.

Hi,

Trigger.bat is a script which triggers your Cognos schedule to run. You need to get Informatica to launch it as the last thing it does in the workflow.

The link I posted previously details where you can find trigger.bat.

Cheers!

MF.
Meep!

dadamdreams

yes the path is this : Navigate to cognos_root_folder/webapps/utilities/trigger

I am clear with this, but where do we have to place the trigger1 is it in the same folder, what i have mentioned above.

MFGF

Quote from: dadamdreams on 20 Jul 2016 09:18:01 AM
yes the path is this : Navigate to cognos_root_folder/webapps/utilities/trigger

I am clear with this, but where do we have to place the trigger1 is it in the same folder, what i have mentioned above.

Hi,

I don't understand your question. sorry. You know where trigger.bat is - you need to add a command to run this bat file from within your Informatica workflow to trigger your Cognos schedule.

MF.
Meep!