Last post Dec 11, 2012 04:53 AM by mcinnes01
Dec 11, 2012 04:53 AM|mcinnes01|LINK
I have been reading up on SQL Server Service broker, SOA, SODA, CLR, WCF, Web API etc etc and really don't know the best way to go...
There are a few different scenarios I need to work on but the first one is to perform application events triggered by database events.
The application I am writting will perform 3 main tasks:
To achieve the above I wanted a realtime messaging system rather than polling data on a scheduled basis, to do this I need to identify 2 technologies that would best suit the scenario.
I need one technology that will trigger events in my application when changes occur on the oracle tables.
I need another technology to send and queue these events to the relevant functions within the application keeping the sequence of messages where necessary.
The only thing I have ever done with database in terms of database events are triggers on the database, but I am unsure if these can directly cause an application to do something?
A little background on the situation, we have just implemented identity manager (IDM) to sync various systems and automate several network activities, such as account creation. The way this works is that once certain fields are all populated in the HR system
(e.g. as a new starter is keyed) these cause triggers which write to an oracle table called the EventLog. IDM then picks up these events and processes them, finally writing back to staging tables for each system it is syncronising with. So in terms of the
HR system, IDM creates the network and email accounts and then writes this data back to a staging table. One of the things I need my application to do is, when an item is written the staging table to go back in to the HR system, I need to pick it up and process
it. I want this to occur instantly i.e. the creation of a line on the staging table will cause the application to do something.
I really appreciate your suggestions.