BizTalk Adapter Pack 2.0 – All you need to know about the
160K - views

BizTalk Adapter Pack 2.0 – All you need to know about the

Thiago Almeida. http://connectedthoughts.wordpress.com. thiagoa@datacom.co.nz. . BizTalk MVP/Senior Consultant. Datacom. Systems Limited, New Zealand. ACSUG Leader. BizTalk Light and Easy Webcast Series.

Download Presentation

BizTalk Adapter Pack 2.0 – All you need to know about the




Download Presentation - The PPT/PDF document "BizTalk Adapter Pack 2.0 – All you nee..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.



Presentation on theme: "BizTalk Adapter Pack 2.0 – All you need to know about the"— Presentation transcript:

Slide1

BizTalk Adapter Pack 2.0 – All you need to know about the SQL Adapter

Thiago Almeidahttp://connectedthoughts.wordpress.comthiagoa@datacom.co.nz BizTalk MVP/Senior ConsultantDatacom Systems Limited, New ZealandACSUG Leader

BizTalk Light and Easy Webcast Series

Slide2

Session Agenda

Introduction

Installation

WCF SQL Adapter with BizTalk Server

WCF SQL Adapter with Service and Channel Models

Summary

Slide3

Introduction

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

Slide4

Introduction

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 1

st

May 2009, except branch edition

Separate SQL Server adapter SKU for all BizTalk 2009 editions

License per processor otherwise

Slide5

Introduction

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

Slide6

Introduction – New Features

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)

Slide7

Introduction - New Features

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

...

Slide8

Introduction

Architecture:Uses LOB SDK to Interface with WCFUses ADO.NET to Interface with SQL

Slide9

Installation

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

Slide10

Installation

Must install 32-bit version of SQL adapter to develop in Visual Studio or to use BizTalk Admin ConsoleFor BizTalk 2006 R2 install hotfix in kb article 942612After installation you get in machine.config:

Slide11

Session Agenda

Introduction

Installation

WCF SQL Adapter with BizTalk Server

WCF SQL Adapter with Service and Channel Models

Summary

Slide12

Demo Project - Diagram

Slide13

Demo Project - Tables

Slide14

Development from BizTalk

Use the “Consume Adapter Service” or “Add Adapter

Metadata” wizards

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

Slide15

Development from BizTalk

Demo…

Slide16

Development – WCF Service Model

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

Slide17

Development – WCF Channel Model

Control over how messages are created

Must conform to messages expected by the adapter

Submit message or object directly to channel

Slide18

Development from Service Model

Demo…

Slide19

Development from Channel Model

Demo…

Slide20

Tips

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

Slide21

Session Agenda

Introduction

Installation

WCF SQL Adapter with BizTalk Server

WCF SQL Adapter with Service and Channel Models

Summary

Slide22

Summary

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

Slide23

© 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.

BizTalk Light and Easy Webcast Series

Created by the Community

for the Community

Meet the team….