Interoperability with 'NET

1
Interoperability with .NET
Simon Thurman Architectural Engineer Microsoft sim
ont_at_microsoft.com
2
Agenda

• Motivation
• Interoperability Model
• Technologies
• XML, SOAP, Web Services,
• .NET Framework
• SQL Server
• BizTalk Server
• Demonstrations

3
Motivation

• Leverage existing investment
• Existing development
• Off the shelf building blocks
• Make the correct choices moving forward

4
Interoperability Model
Architectural Model
Programming Model
Message Format
Data Format
Transport Protocol
5
Transport Protocol

• Standard transport protocols
• HTTP, SMTP, UDP,
• Message Queuing
• MSMQ 3.0
• Internet Messaging
• 1M Messaging Model
• Triggers
• MSMQ Integration
• BizTalk Adapter
• MSMQ - MQ Series Bridge

6
Data Format

• Standard data format
• XML
• Embedded with the .NET Framework
• W3C Compliance XML, XSD, XSLT,
• Data Access Services
• ADO.NET
• OLE DB
• ODBC
• Host Integration Server
• Relational
• File

7
XML Type XML
8
SQL Server as Integration DBXML support makes
this possible

• Heterogeneous views (DQP)
• Direct URL Queries over http/https, results in
  XML
• http//server/database?sqlSELECTFROMCustomers
  FORXML
• Usable from any XML-enabled platform
• Can transform results via XSL intoHTML, Raw
  Text, PDF, Whatever
• Stored Procedures, Template Queries

9
SQL Server XML and HTTP
10
Message Format

• Standard Message Format
• SOAP
• ASP.NET
• SOAP Section 5 and 7
• Great tool support
• .NET Remoting
• Layered architecture
• SOAP and Binary Formatters
• TCP and HTTP Channels

11
Programming Model

• Standard programming model
• Web Services
• Embedded support within the .NET Framework
• W3C Standards
• COM Interop Services
• 3rd Party Bridges
• Supported by .NET Remoting

12
Web Service Interop
13
Architectural Model

• Integration Broker
• BizTalk Server
• Messaging Services
• Orchestration Services
• Integration Types
• EAI, B2B, EDI
• Supported Architectures
• Point to Point, Hub and Spoke, Publish -
  Subscribe
• Integration Gateway
• Host Integration Server

14
BizTalk Server
15
(No Transcript)