I am trying out dynamic routing In oracle service bus based on message payload. Example if the message contain country code 'UK', the UK end point should be called. similarly if country code is US us endpoint (business service) should be called. 
ER Diagram of the routing database


Last Step


This was achieved using dynamic routing as described in Oracle message flow guide. In the guide two methods are specified for dynamic routing, one static xml and another one is storing routing table in database and fetching routing endpoint using XQuery.
Below is a screen shot of proxy routing.
- First routing destination is determined by inspecting the payload (using XPath).
- Using XQuery respective business service is determined from the DB
- Routing Data is deleted from payload as business service does not need this info
- Dynamic service call
Over All Flow
Step 1 and 2
- First routing destination is determined by inspecting the payload (using XPath).
- Using XQuery respective business service is determined from the DB

ER Diagram of the routing database
Step 3
- Routing Data is deleted from payload as business service does not need this info

Last Step

No comments:
Post a Comment