Category: General

09 Apr 2015 06:23

Joined:	08/04/2015
Level:	Bronze
Points:	53

Points:	5

Oracle data change notification

Hello Everyone,

I have a requirement to watch oracle database continuously and get notification as soon as changes happens in the database , Collect changed data ,create excel/cvs/xml file and dump in some folder. These files will be moved to other server using SFTP.
Some of these data will be converted into jason format and sent to cloud in the message format.

I am very new to oracle .
I am not sure which feature of oracle is best fit for above situation.

I am thinking "continues query change notification" will help but not sure .

Please suggest.

#757789

09 Apr 2015 06:43

Joined:	06/04/2012
Level:	Gold
Points:	4230

Points:	2

Hello Mahima,

Refer the link for Oracle database change notifications for Admins, Users.
How to register it and How to deregister it with examples.

http://docs.oracle.com/cd/B19306_01/appdev.102/b14251/adfns_dcn.htm

Hope it will help you.

Regards,
Nirav Lalan
DNS Gold Member
"If you can dream it, you can do it."

#757790

09 Apr 2015 06:46

Joined:	08/04/2015
Level:	Bronze
Points:	53

Points:	1

Thanks Nirav .
Is there any other method to get notification

#757793

09 Apr 2015 08:31

Joined:	08/07/2010
Level:	Gold
Points:	6482

Points:	2

Recently I have implemented oracle database change notification in my asp.net application so whenever the data in the specified table is updated, the asp.net application is notified and it takes the required action by updating the cached database data and update the ui with this new data.

Miss. Jain
Microsoft Certified Technology Specialist in .Net

#757798

09 Apr 2015 09:33

Joined:	08/04/2015
Level:	Bronze
Points:	53

Points:	1

Thanks Priya.

There will be more than 500 users who hits the oracle database frequently . As soon as data changes I need to pull it and send to azure messaging queue.

Do you thing database change notification or Query result change notification will help?

What will be the load on the server ?

Thank you in advance.

#757825

10 Apr 2015 06:44

Joined:	20/03/2013
Level:	Gold
Points:	4176

Points:	2

I think you can use a service for this with a single Service You can update all the Users with that service on a regular time interval basis....

or if you Just want to know whether the Table has a new entry Make One Column New Modified with Datetime...

SRI RAMA PHANI BHUSHAN KAMBHAMPATI

#757827

10 Apr 2015 21:04

Joined:	20/03/2013
Level:	Gold
Points:	4176

Points:	3

Hi Mahima,

You can Use Msmq for this whenever a row in a table gets Updated sent to the Msmq with record added date and time or even you can use flat files and xml files too ....
read the Msmq or read the flat file or xml files for every user in your code and check whether the table has been Updated

For Msmq read my articles....

This is Theoretical Explanation

http://www.dotnetspider.com/resources/44821-Microsoft-Message-Queuing-Aspnet.aspx

and its a Practical Explanation

http://www.dotnetspider.com/resources/45339-Monitoring-services-Remotely-your-computer.aspx.

SRI RAMA PHANI BHUSHAN KAMBHAMPATI

Oracle data change notification

About dotnetspider.com

Quick Links

General

Services