All,
In our current Project, we need to need to carry out the following steps.
i) On update of a record in Table, we need to notify a Dot net Listener process( which uses Tibco API's ) to send the updated record details to downstream systems.
We do not want a polling mechanism, but rather on the fly i.e. realtime messaging.
We are planning to send tcp messages in the update trigger . The dot net process listening to these tcp messages will pick up these messages and then carry out the necessary activities.
Please let us know if there is a better approach of doing the same ?
Will this tcp sending impact the performance of the database ?
Also let us know as to how to send the tcp messages from the Database to a particular port.?