Biztalk wcf-sql适配器轮询来自Sql Server Broker Queue的消息 [英] Biztalk wcf-sql adapter polling messages from Sql Server Broker Queue

问题描述

大家好

我需要在biztalk中轮询来自SSB队列的消息。我如何根据消息类型执行此操作，因为我希望对队列中的不同消息类型进行不同的订阅编排。如果有一个更新可以更新3个相关表，那么我可以限制
在队列中有3条消息吗？

I need to poll messages from SSB Queue, in biztalk. How can I do that based on message type as I want different subscribing orchestrations to different message types in queue. If there is one change that updates 3 related tables is there a way i can limit having 3 messages in queue?

此外，我在源表上创建触发器以捕获任何更改和SSB队列中的相应插入。我的问题是如何根据表数据识别消息类型，并使用触发器代码将其填充到队列中。

Also I am creating triggers on source tables for capturing any change and corresponding insert in SSB Queue. My problem is how do I identify message type based on table data and populate it in queue using triggers code.

问候

Shivani

推荐答案

Hi Shivani 

Hi Shivani 

您应该为每个messageType创建不同的队列（源表更改），以便每个队列由BizTalk中的不同ReceiveLocation轮询。然后，每个ReceivePorts / ReceiveLocations都可以绑定到不同的业务流程。这样
就可以控制你需要为特定的messageType / source表更改所做的处理。

You should create different queues for each messageType(source table change), so that each queue is polled by a different ReceiveLocation within BizTalk. Each of those ReceivePorts/ReceiveLocations can then be bound to a different orchestration. This way you can control the processing you need to do for a particular messageType/source table change.

请参考下面的示例，了解BizTalk如何轮询SSB队列（它类似于轮询表格） -

Please refer below sample on how BizTalk can poll SSB queues (it's similar to polling a table)-

https://blogs.msdn.microsoft.com/adapters/2008/06/30/using-the-wcf -sql-adapter-to-messages-from-ssb-queues-and-submit-them-to-biztalk /

关于你的其他查询 -

Regarding your other query-

"此外，我在源表上创建触发器，用于捕获SSB队列中的任何更改和相应的插入。
我的问题是如何根据表数据识别消息类型并使用触发器代码将其填充到队列中。"

此问题将如果为每种类型的消息创建不同的队列/您正在捕获的每种类型的源表更改，也可以解决。每个表都有自己的触发器，每个触发器都会将消息写入该特定
表的专用队列（通过队列的代理服务）。

This problem will be solved as well if you create different queues for each type of message/each type of source table change you are capturing. Each table will have it's own trigger, and each trigger will write a message to the dedicated queue for that particular table (via the queue's broker service).

请参阅此处的示例使用源表更改触发器设置SSB -

Refer the sample here for setting up SSB with source table change triggers-

http://itknowledgeexchange.techtarget.com/sql-server/using-service-broker-instead-of-replication/

这篇关于Biztalk wcf-sql适配器轮询来自Sql Server Broker Queue的消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！