Fetch data from Oracle DB through BRE

This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by community-content.

Viewing 1 reply thread

Author

Posts
- July 4, 2013 at 12:25 AM #26086
  community-content
  Hi,
  
  I need to fetch data from Oracle DB through BRE.
  
  For example, the incoming message consists of EmpID. We need to fetch EmpName from DB and update the message.
  
  We don’t want to use Orchestration for this.
  
  There will be hundreds of messages flowing in.
  
  Please advice.
- July 6, 2013 at 6:28 PM #26087
  community-content
  Hi,
  
     To fetch data from Oracle through the BRE, I suggest you go through the instructions laid out in this blog:
  
  http://thirteendaysaweek.com/2010/06/15/using-oracle-data-in-the-business-rules-engine/
  
     Regarding the messaging scenario without orchestration, you can look into using a MSMQ adapter with a custom receive pipeline component that calls your BRE policies. Here’s another blog that shows you an example of such an implementation:
  
  http://blogs.msdn.com/b/paolos/archive/2011/06/01/a-broker-pipeline-component-for-end-to-end-ordered-delivery.aspx
  
     I hope this information can get you started and heading in the right direction.
Author

Posts

Viewing 1 reply thread

The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.