Hello All,

I got a task where in I will be polling a oracle table data through consuming adapter services , Thats fine......

but if any change got happened on that table (changes implies -> new record insert , update values in the table etc.)

then I want to execute one procedure which will send data of respective changed record.

Does anybody has an idea How can I achieved that.

Thanks in Advanced.

Hi Nilesh,

Refer MSDN Library post: Receiving Database Change Notifications Using BizTalk Server

________________

Maheshkumar S Tiwari|User Page|Blog|How to Access an Orchestration variable in Map

• Marked as answer by NileshChand 12 hours 39 minutes ago

Hi Nilesh,

Refer MSDN Library post: Receiving Database Change Notifications Using BizTalk Server

________________

Maheshkumar S Tiwari|User Page|Blog|How to Access an Orchestration variable in Map

• Marked as answer by NileshChand Monday, May 25, 2015 6:25 PM

Hi Nilesh,

Refer MSDN Library post: Receiving Database Change Notifications Using BizTalk Server

________________

Maheshkumar S Tiwari|User Page|Blog|How to Access an Orchestration variable in Map

• Marked as answer by NileshChand Monday, May 25, 2015 6:25 PM

Well...hold on there.  Notifications are a feature of both the WCF SQL and Oracle bindings, but...

(In my experience) They are quite brittle, meaning the notification connection randomly stops without warning.  Then, the only way to recover is to restart the Receive Location.

I have seen this with both SQL Server and Oracle but it's much worse with Oracle.  I've tried this feature or seen it tried at least 3 times and it's always been proven too unreliable.

Give it a shot, I really hope it works.

In case it doesn't: http://social.technet.microsoft.com/wiki/contents/articles/24803.biztalk-server-sql-patterns-for-polling-and-batch-retreive.aspx

The section on Polling a Database We Don't Own was developed as a replacement for Notifications.

Thanks Maheshkumar..

I am new to biztalk so

Could you please explain how my orchestration flow will be (in details) ?

It would be better If you can share any sample example for notification.

• Edited by NileshChand 18 hours 52 minutes ago

Thanks John for your reply.

Anyhow I have to do this using Oracle database..

Could you please tell me what are the steps I need to take I mean Generate schema for polling or Notification

and what are the properties I need to set in that(polling or Notification) ?

It would be better If you can share any sample example for notification.

Thanks.

• Edited by NileshChand 18 hours 52 minutes ago

Thanks Maheshkumar..

I am new to biztalk so

Could you please explain how my orchestration flow will be (in details) ?

It would be better If you can share any sample example for notification.

• Edited by NileshChand Tuesday, May 26, 2015 12:12 PM

Thanks Maheshkumar..

I am new to biztalk so

Could you please explain how my orchestration flow will be (in details) ?

It would be better If you can share any sample example for notification.

• Edited by NileshChand Tuesday, May 26, 2015 12:12 PM

Thanks John for your reply.

Anyhow I have to do this using Oracle database..

Could you please tell me what are the steps I need to take I mean Generate schema for polling or Notification

and what are the properties I need to set in that(polling or Notification) ?

It would be better If you can share any sample example for notification.

Thanks.

• Edited by NileshChand Tuesday, May 26, 2015 12:12 PM

Thanks John for your reply.

Anyhow I have to do this using Oracle database..

Could you please tell me what are the steps I need to take I mean Generate schema for polling or Notification

and what are the properties I need to set in that(polling or Notification) ?

It would be better If you can share any sample example for notification.

Thanks.

• Edited by NileshChand Tuesday, May 26, 2015 12:12 PM