Transcript Document

BizTalk 2009 Series
Created by the Community
for the Community
BizTalk Light and Easy
Webcast Series
Thiago Almeida
http://connectedthoughts.wordpress.com
Senior Integrations Consultant/Team Leader
Datacom Systems Limited, New Zealand
Auckland Connected Systems User Group Leader
Created by the Community
for the Community
Introduction
Installation
WCF SQL Adapter with BizTalk Server
WCF SQL Adapter with Service and Channel Models
Summary
Created by the Community
for the Community
BizTalk Adapter Pack 2.0
Five adapters:
SQL Server
Oracle Database v3.0
Oracle E-Business Suite
mySAP Business Suite v3.0
Siebel eBusiness Applications
Built on top of the WCF LOB Adapters SDK
Expose line of business applications and data as
Windows Communication Foundation (WCF)
services
Created by the Community
for the Community
BizTalk Adapter Pack 2.0 Licensing
All BizTalk 2009 editions except branch edition
All BizTalk 2006 R2 edition licenses with
software assurance not expired before 1st May
2009, except branch edition
Separate SQL Server adapter SKU for all
BizTalk 2009 editions
License per processor otherwise
Created by the Community
for the Community
BizTalk Adapter for SQL Server
Exposes SQL Server databases as a WCF
service
Translates SOAP messages into ADO.NET
calls
Can be used by BizTalk, the WCF service
model or the WCF channel model
Created by the Community
for the Community
SQL 2008 support
64-bit support
WCF based
Supported outside BizTalk Server
Metadata browsing
Generic SQL statements
Polling doesn’t need FOR XML (but still
supported)
Created by the Community
for the Community
Polling via SQL query and Query
Notifications
New data types (date, time, hierarchyid)
Scalar and table valued functions
Support for user-defined types (UDTs)
Support for filestream
Composite Transactions
Isolation level control
...
Created by the Community
for the Community
Architecture:
Uses LOB SDK to
Interface with WCF
Uses ADO.NET to
Interface with SQL
Created by the Community
for the Community
Operating System:
Windows Server 2008
Windows Server 2003 R2
Windows Server 2003 SP2
Windows Vista SP1
Windows XP SP3
Microsoft .NET Framework 3.5 Service Pack 1
Microsoft Visual Studio 2008 or Microsoft Visual
Studio 2005 SP1 (development only)
Microsoft BizTalk Server 2009 or BizTalk Server
2006 R2 (if using adapter with BT)
WCF LOB Adapter SDK SP2
Created by the Community
for the Community
Must install 32-bit version of SQL adapter to
develop in Visual Studio or to use BizTalk
Admin Console
For BizTalk 2006 R2 install hotfix in kb article
942612
After installation you get in machine.config:
Created by the Community
for the Community
Introduction
Installation
WCF SQL Adapter with BizTalk Server
WCF SQL Adapter with Service and Channel Models
Summary
Created by the Community
for the Community
Created by the Community
for the Community
Created by the Community
for the Community
Use the “Consume Adapter Service” wizard
Creates schemas for the message
structures expected by the adapter
Creates binding file for selected operations
Appears as sqlBinding in the WCF-Custom
adapter or as WCF-SQL adapter
Created by the Community
for the Community
Development from BizTalk
Created by the Community
for the Community
Use the Add Adapter Service Reference
Creates proxy and operation classes for all
the selected operations
Creates app.config entries for binding and
client endpoints
Classes get sent to WCF channel model
through binding
Created by the Community
for the Community
Control over how messages are created
Must conform to messages expected by the
adapter
Submit message or object directly to
channel
Created by the Community
for the Community
Development from Service
Model
Created by the Community
for the Community
Development from Channel
Model
Created by the Community
for the Community
Decide beforehand all the items you want to
generate the proxy or schemas, to avoid ending
up with multiple proxy files or schemas
Take advantage of SQL 2008’s features like
query notifications, merge statement
Watch out for timeouts with large messages
and varbinary(max), varchar(max), filestream
Create canonical schemas/façade services to
avoid exposing SQL Server specific names
Created by the Community
for the Community
Introduction
Installation
WCF SQL Adapter with BizTalk Server
WCF SQL Adapter with Service and Channel Models
Summary
Created by the Community
for the Community
Completely new SQL Adapter
Part of the BizTalk Adapter Pack 2.0
Built on top of the WCF LOB Adapter SDK
Exposes SQL Server databases as WCF
service
Consume from BizTalk, WCF Service and
WCF Channel model
Created by the Community
for the Community
BizTalk Light and Easy Webcast Series
Created by the Community
for the Community
Meet the team….
© 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market
conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation.
MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.