300 likes | 307 Views
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
E N D
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 “AzureThoughts, 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 Enterprise Service Bus Business Rules Engine Trading Partner Management RFID EDI/B2B Adapters & Adapter SDK Business Activity Monitoring Accelerators (SWIFT/HL7) BizTalk Server
Role of the Adapter Pack .NET/WCF/ AppFabric Service bus BizTalk Server
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
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) OracleDbBinding you can: • Perform Table Operations • Invoke functions, functions with Record Types, or with REF CURSORs • Invoke Overloaded Procedures, Procedures with BFILE Parameters, Stored-Procedures • Polling • Execute Statement
Demo – Integration with Oracle 11g XE • OracleDbBindingConfiguration • Port Configuration • Query Messages
Service Bus Connectivity Messaging
Service Bus Household Appliance (Airco) Telephone, Tablet, PC SaaS (i.e. CRM online, Salesforce) Queues Topics Relays Notifications* Bridges* … Event Aggregator (StreamInsight) Line of Business Application (SAP)
Service Bus: Relay Relay Rendezvous address Outbound Connection Outbound Connection msg msg Client Service NAT Firewall Dynamic IP
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
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
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 :Steef.Jan.Wiggers@motion10.com :http://soa-thoughts.blogspot.com/ :http://www.linkedin.com/in/steefjan :http://twitter.com/SteefJan :http://www.facebook.com/steefjan.wiggers