How to extract BizTalk subscriptions

BizTalk, a powerful integration platform with a vast user base, has been serving organizations for over 20 years. As businesses migrate to Azure or the cloud, a critical task involves analyzing existing integrations in BizTalk and preparing them for migration or recreation in the cloud. However, the process can be complex, especially when dealing with incomplete or outdated integration documentation and direct message bindings. To simplify this analysis and gain insights into message routing, a tool called BizTalk Subscription Extractor can be utilized.

The Challenge of Analyzing BizTalk Integrations

Moving to Azure requires analyzing existing integrations in BizTalk, which may lack comprehensive documentation and rely on direct message bindings. This can lead to time-consuming efforts in determining which flows or integrations are involved in processing specific messages based on message types or promoted properties.

Introducing BizTalk Subscription Extractor

BizTalk Subscription Extractor is an open-source tool designed to extract all relevant information for BizTalk subscriptions. It leverages both the BizTalkMgmtDb and BizTalkMsgboxDb databases, making it suitable for environments with multiple message boxes.

Key Features and Benefits

• Comprehensive Extraction: The tool extracts information for all subscriptions, allowing you to analyze the entire scope of integrations in your BizTalk environment.
• Free text search: Once the subscriptions’ information is exported, you can easily search for specific message types, context properties, receive ports, BizTalk applications, enabling efficient analysis.
• Data Safety: BizTalk Subscription Extractor ensures data safety by only extracting information from BizTalk databases without making any changes to the data or databases.
• 100% Open Source: The tool is built in C#, making it simple to customize and modify the output.

Example of Exported Subscription Information

The exported file contains subscription details structured in XML format. Each subscription entry includes

• Name: the subscriber’s name.
• BTAppName: BizTalk application.
• ClassName: (Message In Process, Orchestration, etc..).
• HostName: the name of the host underwhich the subscription is running
• uidPortID: Unique port ID (it can be a send port, a receive port, or even a logical port)
• fEnabled: refers to the port status Unlisted, Stopped, Enabled, etc…
• Conditions: lists all conditions defined for message routing.

<Subscription>
  <Subscription>
    <Name>subscriber's name: File</Name>
    <BTAppName>INT1001.SalesOrder</BTAppName>
    <ClassName>Messaging InProcess</ClassName>
    <HostName>SendHost</HostName>
    <uidPortID>1652ECF8-9EF6-4C69-A429-8D5673B2D71B</uidPortID>
    <fEnabled>1</fEnabled>
    <fPaused>0</fPaused>
    <Conditions>
      <OR>
        <AND Property="http://INT1001.SalesOrder/Schemas/InternalProperties#OrderId" Operator="exists" Value=""/>
        <AND Property="http://schemas.microsoft.com/BizTalk/2003/system-properties#OutboundTransportType" Operator="==" Value="File"/>
        <AND Property="http://schemas.microsoft.com/BizTalk/2003/system-properties#SPID" Operator="==" Value="INT1001.SalesOrder"/>
      </OR>
    </Conditions>
    <Conditions>
      <OR>
        <AND Property="http://INT1001.SalesOrder/Schemas/InternalProperties#SalesType" Operator="==" Value="B2BSales"/>
        <AND Property="http://schemas.microsoft.com/BizTalk/2003/system-properties#OutboundTransportType" Operator="==" Value="File"/>
        <AND Property="http://schemas.microsoft.com/BizTalk/2003/system-properties#SPID" Operator="==" Value="INT1001.Send.B2BSalesOrder"/>
      </OR>
    </Conditions>    
  </Subscription>
  <Subscription>
    <Name>Activate: INT1001.SalesOrder.Orchestrations.OrderConfirmation.ProcessOrderConfirmation(e73c6ebd-f01b-1305-3e83-36d4edbe93c7)[0]</Name>
    <BTAppName>INT1000</BTAppName>
    <ClassName>Orchestration</ClassName>
    <HostName>OrchestrationHost</HostName>
    <uidPortID>E73C6EBD-F01B-1305-3E4A-7A25C86BA691</uidPortID>
    <fEnabled>1</fEnabled>
    <fPaused>0</fPaused>
    <Conditions>
      <OR>
        <AND Property="http://schemas.microsoft.com/BizTalk/2003/system-properties#MessageType" Operator="==" Value="http://schemas.microsoft.com/dynamics/2008/01/documents/SalesOrderConfirm#SalesOrderConfirm" />
        <AND Property="http://schemas.microsoft.com/BizTalk/2003/system-properties#ReceivePortID" Operator="==" Value="INT1001.Receive.SalesOrderConfirm" />
      </OR>
    </Conditions>
  </Subscription>
</Subscriptions>

BizTalk Subscription Extractor is a valuable tool for simplifying the analysis of BizTalk integrations when planning a migration to Azure or the cloud. By extracting and examining subscription information, you can gain insights into message routing and efficiently prepare integrations for the migration process. Leverage this open-source tool to enhance your integration analysis and facilitate a successful transition to the cloud.

You can download the latest executable version from github