Step 10: Test the Solution



Microsoft Azure BizTalk Services (MABS) is being retired, and replaced with Azure Logic Apps. If you currently use MABS, then Move from BizTalk Services to Logic Appsprovides some guidance on moving your integration solutions to Logic Apps.

If you're brand new to Logic Apps, then we suggest getting started here:

This section demonstrates how to test the solution by dropping a flat-file message to a folder on the FTP Server. The one-way bridge consumes this message, processes it, and then writes the values into the Claims table in the InsuranceData database in the on-premises SQL Server instance for Humongous Insurance.

To send a message to the bridge

  1. Locate the SampleInsuranceClaim.txt message under the location where you downloaded the FlatFile_Bridge sample. See the contents of the message, which resemble the following:


    Notice the second element, HI. This is type of claim that is being processed. Also, notice that there is no claim description for this claim type in the message that is sent by Northwind.

    Copy the message to the ReceiveFFMessage folder on the FTP Server. The bridge you configured as part of the BizTalk Service project picks messages from this folder.

  2. Wait for the message to disappear. Now go to the Claims table in the InsuranceData database and verify if the new values have been inserted.

    Notice that even though the input flat-file message did not have a claim description, the Claims table has the value “HealthInsurance” inserted for the ClaimTypeDescription column. This value was included in the message by using the Microsoft Azure SQL Database lookup configured as part of the bridge and the transform. If you want to see how the lookup configuration looks up value from the Azure SQL Database table, change the value in the ClaimTypeDescription in the Azure SQL Database table and then drop another message to the FTP location. The next message that is inserted in the Claims table must have the new value you entered in the Azure SQL Database.

    Claims table in SQL Server

  3. Because you configured the bridge to track message properties, you can also view the tracked data from the BizTalk Services Portal. Log in to the BizTalk Services Portal, and from the left pane, click Tracking. In the right pane, under the Messages tab, see the different levels of tracking info. Select a row, and from the bottom of the screen click Details to see more details about that event. For example, the following screenshot shows the detailed info about the Route activity.

    View tracked properties

    Note that it shows the values for ClaimType and ClaimTypeDescription properties. That’s because you selected these properties to be tracked (see Configure Tracking) when you configured tracking as part of the bridge configuration.

    For more information about how to track messages, see Tracking Messages in BizTalk Services portal.

See Also

Tutorial: Using BizTalk Service Bridges to Lookup Data from Azure SQL Database