topic Running Program after SQL Change in Application Development and Automation Discussions

Running Program after SQL Change

Former Member — Tue, 26 Jul 2011 07:37:34 GMT

Hello Everybody,

I'm looking for a bit of advice on how to handle a situation.

I've currently written a program that takes information from a SQL database and exports it out of SAP. The information is then run through an encryption and stored somewhere else remotely. The program right now runs every 48 hours. Though the question now is that the customer wants the information up-to-date at all times. When a user makes a change to the database, he wants the information to be exported and encrypted afterwards.

Can you with SAP automatically launch a program after a change to a database? Or create a sort of listener? If so, how would you approach the situation?

Re: Running Program after SQL Change

Former Member — Tue, 26 Jul 2011 07:57:27 GMT

I have two ideas on how to handle this situation.

the 1st is easy to implement, but is the worse one from point of system quality. Run a program in batch every minute, checking wheather there are new oder modified entries by reading the date of modification of the datasets, e.g. select all datasets being edited or created within the last minute.

The better way is to find a user exit before saving the dataset. Start your function module to sent the data to the external database in this user exit.

Re: Running Program after SQL Change

Former Member — Tue, 26 Jul 2011 11:07:17 GMT

Hi,

Running the Job every half an hour may help.

Thanks,

Venkatesh.

Re: Running Program after SQL Change

former_member201275 — Tue, 26 Jul 2011 11:37:20 GMT

Not sure exactly your requirement but if it is a bespoke table you can create event management for this i.e.:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc?quicklink=index&overridelayout=true