COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Event Studio => Topic started by: Avik Dasgupta on 27 Aug 2009 04:44:58 AM

Title: how to trigger a SDK code when some data changes in D/B table
Post by: Avik Dasgupta on 27 Aug 2009 04:44:58 AM
Hi,     
                                                               
I have developed a java code which is responsible to maintain cognos   
namespace entries(insert, update ,delete of users for any user group in
namespace).The code is working fine.The input of this SDK code is a D/B
table.Depending upon this table information Cognos Namespace will be   
updated by SDK code.My requirement is, when a new entry comes to the   
D/B table I need to trigger the SDK code.I have also created a windows batch   
file for the SDK code which works properly.The above mentioned D/B     
table is generated by informatica,and we cant trigger SDK code from     
there.Is there any way to trigger this code from event studio when some
data changes into the D/B table or some other way....?    PLZ help.             

Thanks & Regards,                                                       
Avik Dasgupta   
Title: Re: how to trigger a SDK code when some data changes in D/B table
Post by: Avik Dasgupta on 31 Aug 2009 01:19:16 AM
Hi,

It is not necessary to trigger the SDK code by event studio.Can I run the windows batch file wich runs the SDK code,when data changes in the input table using some other technique?

Our database server and cognos application servers are different servers.So when I try to run the windows batch file located in cognos server from database server(unix) I think I need to login and then follow the other steps.I have no experience on this.Can any tell me how to run a windows batch file from database server when some record updated.

Thanks in advance,

Avik Dasgupta