Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Using the BizTalk Adapter Service (BAS)

Using the BizTalk Adapter Service (BAS)

Updated: July 28, 2015

Using BizTalk Adapter Service, your cloud application can communicate with Line-of-Business (LOB) systems on-premises, in your network, behind your firewall. Using the LOB adapters in the BizTalk Adapter Pack (BAP), a BizTalk Adapter Service application can execute LOB operations to the following on-premises LOB systems:

  • Microsoft SQL Server

  • Oracle Database

  • Oracle E-Business Suite

  • SAP

  • Siebel eBusiness Applications

Consider this scenario:

There is an on-premises SQL Server that stores Customer data, including Name, Shipping Address, Order History, and Payment Methods. You want to develop a purchasing application. When the order is being placed, this application retrieves the Name, Shipping Address, Order History, and Payment Methods from this SQL Server database. The goal is to host the application in the cloud and have it retrieve the customer data from this on-premises SQL Server.

BizTalk Adapter Service is your answer. You continue to maintain your on-premises SQL Server and allow the cloud to host your application. You can execute any LOB operation, like DELETE, INSERT, SELECT, UPDATE, from your cloud application.

BizTalk Adapter Service provides the following benefits:

  • Cost effective: There are no individual relay endpoints in the cloud.

  • Supports a mix of systems: You can connect a cloud application to an on-premises LOB system with the BizTalk Adapter Pack.

  • Maintenance: You continue to host your on-premises LOB system while the application is hosted in Microsoft Azure.

  • Flexibility: Execute a LOB operation in your table structure.

  • Development: Use Visual Studio to create your cloud applications, just like creating BizTalk Server applications.

  • Windows PowerShell: Use cmdlets to manage your LOB components (including creating, updating, and deleting).

In This Section

Reference

Related Sections

Show:
© 2015 Microsoft