Transcript Adapter Pack Integration Capabilities

Integration Capabilities of the Adapter Pack
BizTalk Server, Windows Azure Service Bus, Connect for services
Steef-Jan Wiggers
Principal Consultant, Motion10
MVP BizTalk Server







Working on different integration project in the Netherlands
Writer of numerous articles for Dutch IT Magazine like.NET Magazine,
Software Release Magazine, SDN, and BizTalk Hotrod
Blog “Azure Thoughts, EAI Challenges”, “BizTalkAdminsblogging.com”
BizTalk Forums Moderator
TechNet Wiki Ninja
Author BizTalk Server 2010 Cookbook (April 2012)
Technical Reviewer PACKT Publishing
 BizTalk Server 2010 Patterns
 Microsoft BizTalk Server 2010 (MCTS)
Agenda

Role of the Adapter Pack

Understanding of the Adapter Pack

Show Capabilities of the Adapter Pack
BizTalk Server Components
Business
Rules
Engine
Enterprise
Service
Bus
Trading
Partner
Management
EDI/B2B
RFID
Business
Activity
Monitoring
Adapters &
Adapter SDK
Accelerators
(SWIFT/HL7)
Role of the Adapter Pack
Adapter Pack

Adapter Pack provides versatile and consistent interoperability with LOB
systems like SAP, Siebel, Oracle, and TIBCO.

It is a collection of application adapters that enables any Windows
application to integrate with LOB applications using the Windows
Communication Foundation (WCF) programming model.

Introduced with BizTalk Server 2006 R2.

Adapter Packs has been evolving last years with more adapters and
enhancements to support latest versions of LOB systems and SQL Server.
A little history …

First adapter Microsoft supported was SAP

2005 Microsoft acquired eight adapters from iWay before major release of
BizTalk 2006

Adapters (Amdocs, JD Edwards, Oracle Corp., PeopleSoft, Siebel
Systems Inc. and TIBCO)

Based upon BizTalk Server Adapter Framework

Subsequent adapters (not all) in later packs are based on WCF
Evolution
Each version is aligned with Microsoft Platform (Operating System, SQL Server, and Visual Studio)
Adapter Pack 2010 R2
Adapter Pack 2010
Adapter Pack 2.0
BizTalk Adapters for
Enterprise Applications
Adapter Pack 1.0
WCF LOB SDK 2010
WCF LOB SDK SP2
WCF LOB SDK SP2
WCF LOB SDK
WCF LOB SDK SP1
BTS 2006
.NET 2.0
2006
BTS 2006 R2
.NET 3.0
WCF
BTS 2009
.NET 3.5
WCF
BTS 2010
.NET 4.0
WCF
BTS 2010 R2
2007
2009
2010
2013
.NET 4.5
WCF
Adapter Pack Landscape
Design Time vs Run Time
Visual Studio 2010
Connectivity
Adapter Meta Data
Utility Tool
LoB
Client
Browse meta data
LOB System
Connectivity
Configuration
Binding file
LoB
Client
Perform operation
LOB System
Ease of installation
Ease of configuration
Scenario’s

On-premise scenario with Oracle 11g XE

Connect for services scenario using the Service Bus Relay

Hybrid Scenario using Service Bus Queues, SQL Azure and BizTalk
Server

Using EAI Bridge to Send Message to On-premise LOBs (SQL Server)

BizTalk Server 2010 R2 CTP SB-Messaging
Oracle Connectivity

Adapter Packs 1.0 to 2010 support connectivity with different Oracle

With BizTalk Adapter (WCF) OracleDb Binding you can:





Perform Table Operations
Invoke functions, functions with Record Types, or with REF CURSORs
Invoke Overloaded Procedures, Procedures with BFILE Parameters, StoredProcedures
Polling
Execute Statement
Demo – Integration with Oracle 11g XE
• OracleDbBinding Configuration
• Port Configuration
• Query Messages
Service Bus
Service Bus
Service Bus: Relay
Relay
Connect for Services
 Connect for Services’ feature extends:
 the reach of LOB Services and
 BizTalk application into Windows Azure Service Bus.

Note: LOB Service or BizTalk application runs on-premise, but can be
accessed securely and easily through the Cloud.
Demo – Connect for Services
• Adapter Service Project
• Walkthrough configuration
• Windows Azure ServiceBus
SQL Azure



Adapter offers connectivity from SQL Server 2000 edition until latest SQL
Server 2008 R2.
Not every feature is supported in SQL Azure like:








Common Language Runtime (CLR)
Database file placement, mirroring
Distributed queries, Distributed transactions (No MSDTC)
Filegroup management
Global temporary tables
SQL Server configuration options
SQL Server Service Broker (Query Notifications)
System tables, Trace Flags
Note: Not documented as supported connectivity with SQL Azure is
possible.
Demo – SQL Azure
• Consume Adapter Service
• SQL Azure Instance
• BizTalk Configuration
Service Bus Connect (EAI/EDI Bridges)

Service Bus Connect feature allows an application in the cloud to
communicate with a Line-of-Business (LOB) system on-premise, in your
network, behind your firewall

LOB adapters in the BizTalk Adapter Pack (BAP), a Service Bus Connect
application can execute LOB operations to the following on-premise LOB
systems:





Microsoft SQL Server
Oracle Database
Oracle E-Business Suite
SAP
Siebel eBusiness Applications
DEMO EAI Bridges - SQL
• Show SQL Bridge
• Send Message
Windows Azure Service Bus
SQL Server
Client
Service Bus Messaging


QUEUES
 Provide loose coupling between components and enables load balancing
and load leveling.
 Developers can interact with queues via WCF bindings, .NET API or REST
API.
TOPICS
 Topics are like queues except that they allow messages to be consumed
by multiple parties.
 Subscriptions are added to topics and rules can be applied to limit the
messages received.
 Can have multiple subscribers for a single subscription (for load balancing)
or one subscriber per subscription (multi-cast).
DEMO – Service Bus Messaging
• Show BizTalk Server 2010 R2 SB-Message Adapter
Cloud
Queues
Client App
On-Premise
BizTalk Server 2010 R2
Adapter Pack
Data-Tier
Wrap-up

Capabilities of Adapter Pack are versatile

Adapter Pack Supports LOB systems SAP, Oracle eBS, SQL and Oracle
databases

Adapter Pack plays a role in different types of integration scenario’s:


BizTalk On-premise
Azure Service Bus
Resources









BizTalk Server Adapter Pack 2010 Wiki
Microsoft BizTalk Adapter Pack 2010 Documentation
Working with BizTalk Adapter Pack 2.0 BizTalk Hotrod 8
Installing BizTalk Adapter Pack 2010 on x64
BizTalk Server Adapters and Adapter Pack Forum
Installing and Configuring Microsoft BizTalk Adapters for Enterprise
Applications
Installing Microsoft BizTalk Adapter Pack 1.0
Installing Microsoft BizTalk Adapter Pack 2.0
Installing Microsoft BizTalk Adapter Pack 2010
Contact
: [email protected]
: http://soa-thoughts.blogspot.com/
: http://www.linkedin.com/in/steefjan
: http://twitter.com/SteefJan
: http://www.facebook.com/steefjan.wiggers
Q&A