Step 8: Test the Solution
Updated: November 9, 2014
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
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:
Wait for the message to disappear. Now go to the OrderDetails table in the Orders database and verify the new values are inserted:
Note that the values correspond to the data in the flat-file message that you dropped to the FTP server.
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:
Note that the tracked values correspond to the values that are inserted into the SQL Server database.