Using the BizTalk Adapter Service (BAS)
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:
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 E-Business Suite
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).