エクスポート (0) 印刷
すべて展開

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

更新日: 2014年1月

This tutorial provides instructions on how to configure a BizTalk サービス solution that receives a flat-file message from an FTP server, processes it through a ブリッジ deployed under the BizTalk サービス subscription on Microsoft Azure, and then inserts the message into an on-premises SQL Server database.

Business Scenario

Fabrikam and Contoso are two business partners. Fabrikam (the retailer) sends sales order messages to Contoso (the supplier). Contoso maintains all the sales order data in table called Orders, which is housed in a SQL Server database within Contoso’s premises. Fabrikam sends flat-file messages to Contoso using an FTP server. Hence, Contoso has to implement a solution on Windows Azure, which enables the following:

  • Contoso must pull the flat file messages from the FTP server at which Fabrikam drops the sales order messages.

  • Contoso must process the message received from Fabrikam and map it to the message for inserting the sales order in its SQL Server database.

To enable this scenario, Contoso does the following:

  • Generates the schema of the flat-file message that it will receive from Fabrikam.

  • Configures an XML 一方向ブリッジ as part of the BizTalk サービス プロジェクト to enable message validation and transformation. This ブリッジ takes a flat-file message, validates it against the schema generated earlier, and then transforms it to the schema required to enter a message into the SQL Server database.

  • Uses BizTalk アダプター サービス to connect to the on-premise SQL Server database from the XML 一方向ブリッジ deployed under the BizTalk サービス subscription.

Before You Begin this Tutorial

For instructions on how to prepare for the BizTalk サービス scenario, see Using the BizTalk Services SDK.

Sample Based on this Tutorial

You can also look at the sample that is based on this tutorial. A sample (FTP_EAI_Tutorial) is available from the list of samples available at http://go.microsoft.com/fwlink/?LinkId=247973.

In This Section

参照

その他のリソース

Tutorials: Azure BizTalk Services

コミュニティの追加

追加
表示:
© 2014 Microsoft