DEVQ10107

1
Building Enterprise Interoperability Applications
Using Microsoft Host Integration Server
2000Peter TyMCDBA, MCSE, MCPSBTechnology
SpecialistMicrosoft Hong Kong Ltd.
peterty_at_microsoft.com
2
Session Prerequisites

• Windows DNA Platform
• Active Server Pages (ASP)
• Microsoft Management Console (MMC)

3
Agenda

• Microsofts Integration Strategy
• Data Integration
• Application Integration
• Network Integration
• Summary

4
Microsofts Integration StrategyThe Evolution of
Heterogeneous Integration
Integration Needs
Web integration
Transaction integration
Data integration
Network integration
Time
5
Microsofts Integration StrategyEnterprise
Interoperability Group Mission

• Integrate Windows DNA 2000 with Non-Windows
  Environments
• Develop the Integration Toolbox
• Flexible integration the right tool for the
  job
• Bi-directional integration (Windows and
  host-initiated)
• Windows-only code (no host footprint)
• Support Both Coexistence and Migration Strategies
• AIM Access, Integrate, or Migrate
• Customers choice!

6
Microsofts Integration StrategyWindows DNA 2000
Application Services
7
Microsofts Integration StrategyHost Integration
Server 2000

• Host Integration Server 2000 Integrates
• COM to IBMs DB2 and CICS / IMS transactions
• MSMQ to IBMs MQSeries
• Microsoft SQL Server 2000 with IBMs DB2
  databases
• SNA or TCP protocols
• An Upgrade to SNA Server 4.0
• Integrated with Windows 2000 and Runs on Windows
  NT 4.0

8
Microsofts Integration StrategyHost Integration
Server 2000 Offerings
Providing comprehensive application integration
Application
Providing comprehensive data integration
Data
Providing comprehensive network integration
Providing a comprehensive set of components for
integrating Windows with host systems
9
Agenda

• Microsofts Integration Strategy
• Data Integration
• Application Integration
• Network Integration
• Summary

10
Data IntegrationHost Data Integration Scenarios
Non-Windows Platform
Client-initiated query
Future
Host-initiated query
Heterogeneous database integration
11
Data IntegrationData Access Client-Initiated
Query
Browser Client n-Tier Develop flexible Web-based
applications to access legacy data
Rich Client n-Tier Empower users to access data
while enhancing manageability and scalability
HTTP
DCOM
IIS / ASP
Rich Client 2-Tier Empower individuals to access
data directly from the desktop
ODBC/OLE DB data providers
TCP/IP SNA
12
Data IntegrationIBM Host Data Integration
Source System
Target System
Application
Target System
Target System
Distributed Data Management is a methodology that
allows data on one system to be shared and
accessed by another system.
13
Data IntegrationDDM File Models Supported
Application
Distributed Data Management (DDM)
14
Data IntegrationDistributed Relational Data
Access (DRDA)
IBM Host
Source System
DB2
Application
Application Server
Application Requester
DDM
DDM
15
Data IntegrationFeatures

• DB2 Access via DRDA
• OLE DB Provider
• ODBC Driver
• SNA and TCP/IP protocols
• Stored procedures
• Service components
• Microsoft SQL Server adapters
• OLE DB Provider for VSAM
• OLE DB Provider for AS/400

16
Data IntegrationDRDA Transport Architecture
ADO App
ODBC App
OLE DB App
ADO
DB2
OLE DB
ODBC
DB2 Service (DRDA AR)
DRDA AS
TCP/IP
WinSock
TCP/IP
WinAPPC
SNA LU 6.2
APPC
SNA Server
17
Data IntegrationWhen to Use ODBC vs. OLE DB
Technical Differences
18
Data IntegrationData Access Feature Enhancements

• OLE DB Provider and ODBC Driver for DB2
• Performance improvements
• DTC-driven 2PC support for DB2 for OS/390 and
  AS/400 via LU 6.2
• Configuration and administration
• Other Data Integration Enhancements
• AS/400 data queues
• File transfer for AS/400, AS/36, and VSAM

19
Data IntegrationSupported DB2 Platforms

• SNA LU 6.2
• DB2 for MVS V4R1 and later
• DB2 for OS/390 V5R1 and later
• DB2 for OS/400 V3R2 and later
• TCP/IP
• DB2 for OS/390 V5R1 and later
• DB2 for OS/400 V4R2 and later (UDB)
• DB2 UDB for Windows NT V5R2 and later
• DB2 UDB for AIX V5R2 and later

20
Data IntegrationMicrosoft SQL Server Integration

• Distributed Transformation Services (DTS)
• Bi-directional snapshot data propagation
• Distributed Query Processor (DQP)
• Heterogeneous queries and joins
• Replication
• Snapshot replication

21
Data IntegrationDistributed Transformation
Server (DTS)
22
Data IntegrationDistributed Query Processor (DQP)
23
Data IntegrationSnapshot Replication Concept
and Architecture
24
Agenda

• Microsofts Integration Strategy
• Data Integration
• Application Integration
• Network Integration
• Summary

25
Application IntegrationApplication Integration
Strategies
Non-Windows
BizTalk Server 2000
26
Application IntegrationCOM Transaction
Integrator (COMTI)

• COMTI Automatically Wraps CICS and IMS
  Transactions as COM Objects
• COMTI Enables Windows DNA 2000 Developers to
  Quickly and Easily
• Build n-tier applications that integrate COM
  with IBM CICS and IMS transactions
• Access host transactions without learning host
  programming
• Extend the scope of MTS/COM transactions to
  include CICS/IMS via 2PC
• Support for traditional LU 6.2 or TCP/IP
  transports
• Without Requiring a Host Footprint or Costly Host
  Transaction Re-Writes

27
Application IntegrationCOMTI Architectural
Overview
XML
COM / DCOM
HTTP
Step 1 Process Invocation
MTS/COM
IIS / ASP
BizTalk Server
APPC TCP/IP
APPC TCP/IP
COMTI
Step 2 Transaction Invocation
2PC
CICS
IMS
CICS TP
IMS TP
Step 3 Transaction Runtime
DTC
DB2 / VSAM
IMS Database
28
Application IntegrationCOMTI Host
Communications
CICS
Mirror TP CSMI
Linked-to CICS TP
COMMAREA
APPC TCP/IP
MTS
MTS Component
DB2 / VSAM
IIS / ASP
TCP/IP Listener
COMTI Proxy
Business Process
IMS
APPC TCP/IP
.TLB
Terminal
IMS TP
IMS Control Region
COMTI Component Builder
IMS Database
IMS Message Queue
COMTI accesses CICS TPs through the CICS mirror
transaction (CSMI) and IMS TPs via the IMS
message queue.
29
Application IntegrationCOMTI Client
Communication
Visual Basic Program Private Sub
GetBalance_Click() 'do the COMTI
invocation Set objBank CreateObject("Cedar.Bank"
) lngReturn objBank.cedrbank(txtName.Text, _
txtAccount.Text, curRetBalance) Exit Sub
CICS
Mirror TP CSMI
Linked-to-Program
DCOM
APPC
LINK from mirror transaction
MTS
Analyze input data in COMMAREA
MTS Component Cedar.Bank
Do work using local resource managers
COMMAREA
COMTI Proxy
Name (in)
Place output data in COMMAREA
AccNum (in)
.TLB
AccBal (out)
EXEC CICS RETURN
30
Application IntegrationXML-to-Host Integration
Asynchronous (messaging-based)
MSMQ
Invocation
Execution
MSMQ - MQSeries Bridge
MQSeries
XML-enable host transactions with BizTalk Server
2000 and Host Integration Server 2000.
CICS/IMS
31
Application IntegrationCOMTI Enhancements

• COMTI Remote Environment Dynamic Routing
• OTMA-Based TCP/IP IMS Access
• Performance Tuning and Monitoring
• Streamlined Setup
• Windows 2000 Functionality
• COM

32
Application IntegrationMSMQ-MQSeries Bridge
MSMQ World
MQSeries World
Apps
Apps
Sender
Receiver
Send
Receive
Send
Receive
Providing asynchronous, messaging-based,
communication integration between heterogeneous
applications
33
Application IntegrationMSMQ - MQSeries Bridge
Enhancements

• Integrated Setup and Administration
• Encryption Between MSMQ Clients and the Bridge
• Windows 2000 Functionality
• MSMQ 2.0 and MQSeries 5.1 functions

34
Agenda

• Microsofts Integration Strategy
• Data Integration
• Application Integration
• Network Integration
• Summary

35
Network Integration Providing Comprehensive
Network Support
Host Platforms
Gateway Functionality
Remote Clients
Windows 2000 Server
TCP/IP, IPX/SPX, NetBEUI, Banyan VINES,
AppleTalk, DLC, DecNet
MS-DOS
Telnet
Windows
Unix
Windows 9x
OpenVMS
Windowsfor Workgroups
Macintosh
Windows NT
OS/2
36
Network IntegrationNetwork Features in SNA
Server 4.0 SP3

• Web-Deployable 3270 and 5250 Clients
• Flexible Deployment Options
• TN3270 and TN5250 Client Support
• Host Print Server
• Integrated Security
• Password Sync, Single Sign-on
• Highly Scalable
• 30,000 sessions, load-balancing, and hot backup

37
Network IntegrationNetworking Enhancements

• Host Security Enhancements
• One-way password sync with RACF, ACF/2 and
  Top-Secret
• MSDE-based host security database
• SNA Gateway Enhancements
• Multiple-session 3270 client
• Host Print Service scalability
• LU 6.2 2PC application load balancing and hot
  backup

38
Network IntegrationAdministration Enhancements

• WMI-Based Management and Configuration
• Documentation
• Windows 2000 Functionality
• Active Directory integration
• MMC-based multi-server admin
• Microsoft installer-based setup

39
Agenda

• Microsofts Integration Strategy
• Data Integration
• Application Integration
• Network Integration
• Summary

40
Summary
Integration Components for Host Systems

• Comprehensive Network Support
• SNA and TCP/IP connectivity support
• Security integration
• Network gateway
• Comprehensive Data Access
• Extensive data access providers
• Snapshot Replication
• Comprehensive Application Integration
• Transactional integration via COMTI
• Messaging integration via MQ Series Bridge
• Deployable on Windows NT 4.0 / Windows 2000
• Scalable, Secure, and Manageable

41
Questions?
42
More Resources

• msdn.microsoft.com
• microsoft.com/hiserver/
• microsoft.com/dna/applicationservers.asp
• msdn.microsoft.com/library/techart/dnablueprint.ht
  m

43
(No Transcript)