How to Pick some fields form DB and giving call to WebService and the result again saved to the DB Table after comapring the Value of some Node coming from the WebService RRS feed

  • Question

  • Hi All,


    I have following requirement:


    1> I have to pick 4 values from the DB using BizTalk.

    2>Mapping those values to the fields expected by the WebService.

    3>Calling the WebService using WCF adapter.

    4>After getting the response i have to compare the value to the Node to the Value Picked up from the DB initially and if thts greater or less with the value input i have to insert/UPDATE  into the DB with the values .


    Please suggest how i can achieve that with less use of the .NET coding.


    I appreciate your ideas for that.


    Thanks and Best Regards

    Ramjeet Dixit

    Friday, May 28, 2010 1:39 PM

All replies

  • This sounds like all stuff you can do in standard BizTalk maps. You may need to use a scripting functoid to compare the values.


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Friday, May 28, 2010 5:34 PM
  • Hi Ben,


    Thanks a lot for the suggestion.....


    Please share what we have to do in the Scripting as i have to compare the input schema to the final output schema....





    Saturday, May 29, 2010 8:11 AM
  • Little more details to ur problem (If I understood clearly !)

    1.SQL Schema with 4 fields (select Query or stored proc)

    2.WCF service Request Schema

    3.WCF service Response Schema

    4.Update/insert schema (same schema can serve the purpose - the stored procedure should be intelligent enough )

    Now , map from 1 to 2 with 4 fields (direct link) to get the WCF request

    map from 1&3 to 4 to get the update/insert schema.(In this map there are 2 source schema & one destination (or u can have 2 (one for insert & update))).

    In the above map , you should do ur logical checks with combination of functiods(logical,value mapping etc) ,based on ur requirement.

    Hope this helps & makes sense.

    I have provided a solution with less .NET code , as requested by you !!!






    Please mark as answer if this solved the issue.Thanks
    Friday, December 3, 2010 3:49 PM