Consuming Addapter service... RRS feed

  • General discussion

  • Hi All,


    Frnds i have bit doubt.. While pulling data... Going to be input to Orchestration..... Normally we are following notation like...


    Select top(1) * from <TalbeName>..


    Now if the records are more.... The number of hit to database are more... So is there is any way to  give all message to orchestration at single shot.....





    Tuesday, April 12, 2011 5:15 PM

All replies

  • Hi,

    You can select multiple records, and then split them into single messages in a pipeline or in an orchestration.

    I typically select one at a time, but use the "Poll While Data Found" option so that the messages are received quickly.


    Alan - Community Webcasts Powered by Azure
    Tuesday, April 12, 2011 8:00 PM
  • Thanks Alan,


    But what would be good practice...Pipeline or orchestration or polling single data.......



    Wednesday, April 13, 2011 4:13 AM
  • Hi,

    I think polling for single data is best, as it is the simplest design, and there is less work performed by BizTalk. There is more load on the source database, but I don't see this as a problem.

    It depends somewhat on the scenario you are working with.


    Alan - Community Webcasts Powered by Azure
    Wednesday, April 13, 2011 6:42 AM
  • Hi,

    Thank allan for repply......

    But whole biztalk is  above the database.. and we are frequently hitting the database.Irispeective of data.. to check ...

    So it is going to impact more....if i am not wrong....

    Wednesday, April 13, 2011 12:38 PM
  • I generally poll top 500 or so myself.  BizTalk will receive these records very quickly and splitting in the pipeline is also very easy and fast.  Sometimes you don't need orchestration at all (which makes it even faster), but if you do you can keep to the single split message to make it easy.  If your destination system is another database you could even process multiple messages together (because the SQL / WCF SQL adapters can do multiple operations in a single DTC transaction). 

    My biggest warning would be to make sure there are no databases that you're pulling from or pushing to on your SQL instances that hosts BizTalk.  I describe the fun that can happen here:


    Kind Regards,


    If this answers your question, please Mark as Answer
    Wednesday, April 13, 2011 1:10 PM