Features for SQL adapter clients
In addition to the features discussed throughout the topics of Overview of BizTalk Adapter for SQL Server, the Microsoft BizTalk Adapter for SQL Server also provides the following features that are useful for adapter clients:
Support for configuring adapters using binding properties. Adapter clients can configure the SQL adapter by specifying certain binding properties. For example, clients can specify the maximum number of connections allowed in a connection pool for a specific connection string by setting the MaxConnectionPoolSize binding property. For more information, see Read about the BizTalk Adapter for SQL Server adapter Binding Properties.
Support for null values for operation parameters. Adapter clients can provide null values for operation parameters using the XSD "nillable" attribute.
Support for dynamic ports in BizTalk. Through the BizTalk WCF-Custom adapter, the SQL adapter supports a dynamic port that enables dynamic routing of messages from BizTalk Server based on the message context properties. For more information, see Configure dynamic ports.
Support for performance counters. The SQL adapter supports WCF-based performance counters for use by adapter clients. For more information about performance counters, see Use Performance Counters with the SQL adapter.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for