Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to migrate to WCF Oracle Adapter on Microsoft BizTalk Server 2006?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 26-04-2012
Member
 
Join Date: Jan 2012
Posts: 42
How to migrate to WCF Oracle Adapter on Microsoft BizTalk Server 2006?
  

Well I am using Legacy Oracle adapter on Microsoft BizTalk Server 2006 to select record from Orcale database. I am using delete after poll option to delete selected record. However I have found that there is no such option available in WCF adapter? Can you tell me how can I implement above mentioned thing? I know that I can do this by using stored procedure. But i donít wanted to use it as I am not interested to make any changes on database. Now let me know if you are having any useful instruction to get my requirement. Thanks a lot in advance.

Reply With Quote
  #2  
Old 26-04-2012
Member
 
Join Date: Jul 2011
Posts: 630
Re: How to migrate to WCF Oracle Adapter on Microsoft BizTalk Server 2006?

After going through the problem which you have mentioned over here I wanted tell you that you should try to read more record at a given moment of time. After that you should debatch all the records at a port level. You will be able to process all records through Biztalk engine as per your requirement. Also you will be able to flag records which you have selected. However to add flag you should create an extra column. Also you have to mentioned logic for delete records into PostPollStatement in wcf-oracle adapter binding.
Reply With Quote
  #3  
Old 28-04-2012
Member
 
Join Date: Aug 2011
Posts: 560
Re: How to migrate to WCF Oracle Adapter on Microsoft BizTalk Server 2006?

In this particular situation main issue is you are getting single message for all matching rows when you are polling database table to enter new data on it. normally you would like to debatch messages into separate message for every single row. it seems to be really easy to do. however there could be an issue with property promotions. Since it wont work with incoming schema. The remedy is you have to create separate intermediate schema as per promotions and after that you have to convert incoming messages in newly created schema by making use of inbound maps available at receive port. I let you know that source schema supposed to be on top TypedPollingResultSet0 element at newly generated schema. It should not be below of TypedPolling element because transformation would occur once you have done with debtaching. Also you should not get confused withTypedPollingResultSet0 message as it does not contain much descriptor. RaindanceNotification type of messages are having much description.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to migrate to WCF Oracle Adapter on Microsoft BizTalk Server 2006?"
Thread Thread Starter Forum Replies Last Post
isa server 2006 problem Lalsha Networking & Security 1 23-11-2011 11:54 PM
Ping ISA Server 2006 alsolaih Networking & Security 1 28-03-2011 01:50 AM
How to connect PerformancePoint Services for Microsoft SharePoint Server 2010 to Oracle? Ground 0 Windows Software 5 24-10-2010 05:32 AM
migrate an access database to oracle Sujit15 Software Development 5 25-02-2009 10:50 PM


All times are GMT +5.5. The time now is 08:13 PM.