Here is a great explanation of how to use polling with the WCF-SQL adapter.

Richard Seroter's Architecture Musings

A few years back now (sheesh, that long already??) I wrote a post about debatching messages from the classic BizTalk SQL adapter.  Since that time, we’ve seen the release of the new and improved WCF-based SQL adapter.  You can read about the new adapter in a sample chapter of my book posted on the Packt Publishing website.  A blog reader recently asked me if I had ever demonstrated debatching via this new adapter, and to my surprise, I didn’t found anyone else documenting how to do this.  So, I guess I will.

First off, I created a database table to hold “Donation” records.  It holds donations given to a company, and I want those donations sent to downstream systems.  Because I may get more than one donation during a WCF-SQL adapter polling interval, I need to split the collection of retrieved records into individual records.

After creating a new…

View original post 571 more words

Advertisements
Comments
  1. Vinayak Kumashi says:

    Hi ,
    I am able to configure WCF SQL debatching . I had to use a Receive Pipeline with XML Disassembler component Document Schema set to TypedPolling.sqlBinding_ID1.TypedPollingResultSet0 (ID1 is the Polling ID) and the Envelope Schema Set to TypedPolling.sqlBinding_ID1.TypedPolling schema . The Typed Polling Schema should be set to Envelope Schema other things mentioned in the article. The Subscribing Orchestration must subscribe to TypedPolling.sqlBinding_ID1.TypedPollingResultSet0 Message using a Receive shape. Overall Nice article . Thanks a lot . Vinayak

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s