Step 8: Test the Solution

  • Article

 

Important

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:

In this step, we test the solution by dropping a flat-file message to a folder on the FTP Server. The XML One-Way Bridge should consume this message, process it, and then insert the values into the OrderDetails table in the Orders database SQL Server.

To send a message to the bridge

  1. Locate the Orders.txt message from the location you downloaded the FTP_EAI_Tutorial sample and copy it to a folder on the FTP Server. The bridge you configured as part of the BizTalk Service project must be configured to pick messages from this folder. The Orders.txt message has the following content:

    Ord123|Item201;20;50|Item202;100;20

  2. Wait for the message to disappear. Now go to the OrderDetails table in the Orders database and verify the new values are inserted:

    Message inserted in the database

    Note that the values correspond to the data in the flat-file message that you dropped to the FTP server.

  3. Because you configured the bridge to track message properties, you can also view the tracked data. Go to the BizTalk Services Portal registered for your BizTalk Services subscription, select the Tracking tab, select the Route: Route activity information, and then from the command bar, select Details. In the pop-up window, notice that the OrderId and TotalAmount properties are tracked and their values are also displayed:

    Track message properties

    Note that the tracked values correspond to the values that are inserted into the SQL Server database.

See Also

Tutorial: Using BizTalk Bridges to Insert Flat File Messages into an On-premises SQL Server