WCF SQL Adapter Availability

Question

We use the BizTalk Server 2010 Enterprise Edition, and we want to use the WCF-SQL Adapter, but it does not available in the Transport type drop down. We have followed the instructions in the following page: http://msdn.microsoft.com/en-us/library/dd788542(v=bts.10).aspx

Please let us know how to make WCF-SQL Adapter available.

Answer 1

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

Answer 2

Maximus, You need to install the Biztalk Adapter Pack 2010. It should be there on the CD.

Answer 3

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 . 

Answer 4

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"

Answer 5

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.