Using the WCF SQL Adapter to submit messages to SSB queues from BizTalk

This post is a follow-up to http://blogs.msdn.com/adapters/archive/2008/06/30/using-the-wcf-sql-adapter-to-read-messages-from-ssb-queues-and-submit-them-to-biztalk.aspx and explains how to push a message using the WCF SQL Adapter from BizTalk to a SQL Service Broker (SSB) queue.   Scenario   1.       An XML message is dropped to a file share 2.       This XML message is made available to the WCF SQL Adapter by using…

1

Multiple ways to Poll (Receive Location in BizTalk) in the SQL Adapter

In this post, I outlined the ways in which stored procedures can be executed using the SQL Adapter. Similar to the methods described there, are very similar methods for polling on the inbound side. (I won’t mention the advantages/limitations/workarounds here, since there are very similar to those mentioned in the other post). 1. The first…


Multiple ways to generate metadata / execute Stored Procedures in the SQL adapter

If you’ve used the SQL Adapter in CTP3 of the BizTalk Adapter Pack V2, you’ll notice that there are two nodes in the Metadata Hierarchy for Stored Procedures – one is named “Procedures”, and the other is named “Strongly-Typed Procedures”. What’s the difference, and what are the scenarios which they are meant to solve? What…

0

Address should be unique for Receive Location – error when creating a Receive Location in BizTalk

Assume you’re using the WCF SQL Adapter (part of the BizTalk Adapter Pack 2.0). You decide to create 2 Receive Locations (RL), in order to poll the database. Each RL polls a different table (e.g., the “PollingStatement” binding property in the first RL is “SELECT * FROM T1”, while the “PollingStatement” binding property in the…


The new "WCF LOB Adapter SDK"-based SQL Adapter – Limitations

As mentioned in this post, we’re developing a new SQL Adapter, which will be available in the next release of the BizTalk Adapter Pack. The list of features which we’re supporting is mentioned in that blog post.As for the features/items/etc which we’ve decided NOT TO SUPPORT, they are: The ability to have multiple transactional blocks…


The new "WCF LOB Adapter SDK"-based SQL Adapter – Features

The current release of the Adapter Pack contains the SAP, Siebel and Oracle adapters (written using the WCF LOB Adapter SDK). For the next release of the Adapter Pack, one of the adapters which we’re adding is a SQL Adapter. Some of the features which we’re addressing are: SQL 2005 and SQL 2008 datatypes (XML,…


Getting LOB metadata from SAP, OracleDB and Siebel adapter using svcutil

The WCF based adapters that ship in the Biztalk Adapter Pack are WCF bindings. The svcutil tool can be used to get metadata for a LOB method using these bindings. The scheme in the URI determines which adapter binding is loaded by svcutil. However when using the svcutil tool, there is no easy way to specify…

2