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 trigger a SDK code when some data changes in D/B table

Started by Avik Dasgupta, 27 Aug 2009 04:44:58 AM

Previous topic - Next topic

Avik Dasgupta

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   

Avik Dasgupta

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