Answered by:
WCF-SQL Adapter

Question
-
How to add the wcf-sql adapter to BizTalk application?
Aditi
Friday, November 21, 2014 5:53 AM
Answers
-
You need to install LOB Adapter Pack and BizTalk Adapter Pack (both 64 bit and 32 bit)
Then you should be able to use it in both the BizTalk Administration Console and Visual Studio.
Rachit
- Edited by Rachit Sikroria Friday, November 21, 2014 5:56 AM
- Marked as answer by AditiBiz Friday, November 21, 2014 6:11 AM
Friday, November 21, 2014 5:56 AM -
Hi Aditi,
To add WCF-SQL adapter follow the MSDN link:Adding the SQL Adapter to BizTalk Server Administration Console
To add WCF-SQL adapter and start working with it, follow the technet article : BizTalk Server: WCF-SQL Adapter Table Operations
__________________________________________________________________Maheshkumar S Tiwari|User Page|Blog|BizTalk Server: Multiple XML files to Single FlatFile Using File Adapter
- Marked as answer by AditiBiz Friday, November 21, 2014 6:11 AM
Friday, November 21, 2014 6:01 AM -
You can also.,...
Download and install WCF - SQL Adapter from the link.
After installation, you need to add WCF-SQL into the adapter list. Refer: Adding the SQL Adapter to BizTalk Server Administration Console
Note: If you will not see WCF-SQL in the drop down list, check machine config .
Rachit
- Edited by Rachit Sikroria Friday, November 21, 2014 6:05 AM
- Marked as answer by AditiBiz Friday, November 21, 2014 6:11 AM
Friday, November 21, 2014 6:03 AM
All replies
-
You need to install LOB Adapter Pack and BizTalk Adapter Pack (both 64 bit and 32 bit)
Then you should be able to use it in both the BizTalk Administration Console and Visual Studio.
Rachit
- Edited by Rachit Sikroria Friday, November 21, 2014 5:56 AM
- Marked as answer by AditiBiz Friday, November 21, 2014 6:11 AM
Friday, November 21, 2014 5:56 AM -
Hi Aditi,
To add WCF-SQL adapter follow the MSDN link:Adding the SQL Adapter to BizTalk Server Administration Console
To add WCF-SQL adapter and start working with it, follow the technet article : BizTalk Server: WCF-SQL Adapter Table Operations
__________________________________________________________________Maheshkumar S Tiwari|User Page|Blog|BizTalk Server: Multiple XML files to Single FlatFile Using File Adapter
- Marked as answer by AditiBiz Friday, November 21, 2014 6:11 AM
Friday, November 21, 2014 6:01 AM -
You can also.,...
Download and install WCF - SQL Adapter from the link.
After installation, you need to add WCF-SQL into the adapter list. Refer: Adding the SQL Adapter to BizTalk Server Administration Console
Note: If you will not see WCF-SQL in the drop down list, check machine config .
Rachit
- Edited by Rachit Sikroria Friday, November 21, 2014 6:05 AM
- Marked as answer by AditiBiz Friday, November 21, 2014 6:11 AM
Friday, November 21, 2014 6:03 AM -
How to add the wcf-sql adapter to BizTalk application?
Aditi
You need to install WCF Adapter SDK and WCF LOB adapter pack (do a full installation on the drive ) . You can find them in BizTalk Setup option .
Thanks
Abhishek
Friday, November 21, 2014 6:04 AM -
thanks Mahesh and Rachit. :)
Friday, November 21, 2014 6:12 AM