none
WCF SQL Adapter Availability RRS feed

Answers

  • Download WCF LOB adapter sdk

    Go to BizTalk 2010 setup folder and click on Setup and click “Install Microsoft BizTalk Adapters”

    Complete Step 1, 2 and 3. I think no need step 4 for WCF-SQL adapter.

    Once it is done then go to BizTalk Admin console -> Platform Settings ->Adapters -> Right click on Adapters -> Select New -> Adapter -> Enter WCF-SQL on Name Column and choose WCF-SQL from Adapter list.


    Thanks, Raja MCTS BizTalk Server 2010, MCC If this answers your question please mark it accordingly

    • Marked as answer by Maximus WC Wednesday, July 4, 2012 9:16 AM
    Wednesday, July 4, 2012 8:56 AM
  • Maximus, You need to install the Biztalk Adapter Pack 2010. It should be there on the CD.
    • Marked as answer by Maximus WC Wednesday, July 4, 2012 9:46 AM
    Wednesday, July 4, 2012 9:10 AM

All replies

  • Download WCF LOB adapter sdk

    Go to BizTalk 2010 setup folder and click on Setup and click “Install Microsoft BizTalk Adapters”

    Complete Step 1, 2 and 3. I think no need step 4 for WCF-SQL adapter.

    Once it is done then go to BizTalk Admin console -> Platform Settings ->Adapters -> Right click on Adapters -> Select New -> Adapter -> Enter WCF-SQL on Name Column and choose WCF-SQL from Adapter list.


    Thanks, Raja MCTS BizTalk Server 2010, MCC If this answers your question please mark it accordingly

    • Marked as answer by Maximus WC Wednesday, July 4, 2012 9:16 AM
    Wednesday, July 4, 2012 8:56 AM
  • Maximus, You need to install the Biztalk Adapter Pack 2010. It should be there on the CD.
    • Marked as answer by Maximus WC Wednesday, July 4, 2012 9:46 AM
    Wednesday, July 4, 2012 9:10 AM
  • Thanks you. I installed the "Install Microsoft BizTalk Adapters". Now it is available.

    In our application we have a SQL adapter and it is production on BizTalk 2006 Server.

    We need to migrate the application to BizTalk 2010. so we went through  

    http://msdn.microsoft.com/en-us/library/aa578608.aspx  link and found out that SQL Adapter is no longer supported in BizTalk 2010.

    But after installing the BizTalk Server 2010, we found that SQL Adapter is available as a standard adapter.

    Can anyone please  clarify the reason why  Microsoft has mentioned that the SQL Adapter no longer supported in BizTalk 2010 in “Changed Features and Tools” (http://msdn.microsoft.com/en-us/library/aa578608.aspx) page . 


    Wednesday, July 4, 2012 9:46 AM
  • Hi 

    IMHO the option is there however since WCF is the roadmap So It would be better to migrate the SQL adapter in BizTalk 2010. There have been few issues reported while using SQL adapter in BizTalk 2010, One of them is discussed here, Please have a look. 

    The WCF-SQL adapter gives lot of performance improvements and other features which makes the integration between BizTalk and SQL easy and standard.


    HTH,
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com
    My new TechNet Wiki "BizTalk Server: Performance Tuning & Optimization"

    • Proposed as answer by Naushad.Alam Wednesday, July 4, 2012 2:55 PM
    Wednesday, July 4, 2012 10:19 AM
  • the old SQL adapter was based old COM+ technology which lots of performance issues. It was  replaced with the WCF adapter with better performance and newer technology. They want everyone to move to the better technology.

    Wednesday, July 4, 2012 10:19 AM