Windows and .NET for iSeries Interoperability

1
Windows and .NET for iSeries Interoperability
Charles Machalani, Solution Architect Charles.mach
alani_at_microsoft.com Karen McGregor, .NET
Architect Evangelist Karen.mcgregor_at_microsoft.com
Microsoft Canada
2
Before we start .

• What do you currently interoperate with?
• What scenarios do you implement?
• What Microsoft technology do you have, what
  scenarios do you see for integrating with iseries?

3
Microsoft .NET
Software to connect information, people, systems
and devices Our vision provide the platform to
rapidly build and evolve connected applications
4
What is the Business value?

• Faster Time to market
• Lower cost to produce
• Lower cost to deploy
• More flexibility in deployment options (scale up
  vs. scale out)
• Single standard for internal and external
  integration
• Shorter cycles to deploy changes
• Short learning curve

5
User Interface Layers
Office XP DOCUMENT I/O
ASP.NET Mobile Toolkit THIN DEVICE UI
ASP.NET WebForms Digital Dashboard WEB BROWSER UI
.NET Windows Forms SMART CLIENT UI WINDOWS
UI OFFLINE CLIENT
Outlook XP Exchange Forms MESSAGING UI
UI Process and UI
Sharepoint Server USER DOC WORKFLOW
Exchange Workflow COLLAB. WORKFLOW
ASP.NET WEB UI
XML Web Services
6
Services Layer
BizTalk Messaging
ASP.NET Web Services
MSMQ Listeners
.NET Remoting DCOM
Biz Document Exchange
XML Web Services
Persistent Messaging
Application Endpoints
Enterprise Services (Windows)
.NET frameworks
Enterprise Services (Windows)
BizTalk Server
Business Workflows, Components, Entities and
Service Interfaces
Business Process Automation
XML Document Management
Business Component Hosting
XML-Serializable Objects
Biz Document Transformation
Role-Based Security
ADO.NET DataSets
Long-Running Conversations
Distributed Transaction Mgmt
7
Data Access and Services Agents
.NET Framework
BizTalk Adaptors (300)
VS.NETWeb Proxy
Data Access Components
Web Service
Legacy
CRM / ERP
Adapters
ADO.NET Providers
SQL Server
Exchange 2005
WSE
SQL
DB2
LDAP
WebSphere
CICS
iSeries
8
.NET Roadmap
2007
2006
Windows Workflow
Enterprise Library 2.0
2005
2005
9
Networking
UNIX Systems
Data
Management
XML
Integration
Identity
Web Services
Industry Standards
Applications
Languages
Legacy Hosts
10
Business seeks integration for big wins

• Collaboration
• Partnerships
• Supply distribution
• Customer service
• Business Intelligence
• Sales

Samsung enables a 3M annual benefit from
real-time view of orders, sales, shipping and
inventory Virgin Megastore realizes 50 better
fraud prevention with integrated systems and
process Swedish Hospital delivers better patient
care at less cost through an end-to-end experience
11
Integration Examples

• Get more value from your iSeries.
• For EAI/B2B using Visual Studio.NET, IIS and
  BizTalk Server (inc. Host Adapters)
• For BI using Microsoft SQL Server 2005 Analysis
  and Reporting Services
• For BPA and Human Workflow using BizTalk Server
  2006 and SharePoint Services

12
"This project improves our services and lays the
foundation for further automation. The data on
the iSeries system can be easily and immediately
used for other applications from now on." Eddy
Evens, General manager, Raedschelders
Raedschelders
Offered its fifty biggest customers the ability
to order online and to consult all information
about deliveries and past orders via the Internet
.

• Web Services simplified usability, improved
  access time to ERP data and enabled immediate
  response and feedback to customers
• iSeries data, routines and business logic are not
  duplicated but rather reused with the .NET
  environment

• Worked with Microsoft Certified Partner Ordina to
  deploy new Web interface using Microsoft Windows
  Server SystemTM and Host Integration Server 2004
  to bridge the IBM iSeries ERP application

• IBM iSeries terminal based ERP application was
  not user-friendly and lacked agility to respond
  to customer needs
• Deploy Internet application to provide up-to-date
  product information and enable customers to place
  and follow up orders online

13
Deploy hosts in modern scenarios
Integrated applications, web portals, smart
clients
BizTalk and .NET
BizTalk, Windows and/or .NET connectivity
TCP/IPand SNA
COM, XML, Message Queuing
ADO, OLEDB, ODBC
Host IntegrationAdapters
Network Integration
Application Integration
Data Integration
TCP/IPand SNA
APPC, CPI-C, DPL, LUA, BMS, 3270, MQ
DDM (DRDA RLIO), XA, TDS, CLI, DBLIB
IBM zSeries mainframe iSeries midrange resources
14
Planning value from an integrated platform
Schedules
Events
15
Evaluate Service Oriented Architecture (SOA)

• Means to help build distributed, interoperable
  systems
• Deliver new capabilities from existing assets
• Consolidate interfaces and protocols
• Model diverse business functions in common way
• Create composite, collaborative applications
• Consists of principles specifications
  technologies
• Service an end-point capable of dispatching a
  task
• Analysis What services do we define?
• Design How do we conform to best practices?
• Management How do we monitor and maintain?

16
Demystifying MS Integration Technologies

• How do I categorize these capabilities?
• What are the core scenarios per technology?
• Show me
• What if my business scenario requires more than
  one technology?!

17
Technologies by Message Data
Microsofts MessagingIntegration Products
Microsofts DataIntegration Products
Data integrationservice deeply integrated with
SQL
SQL IntegrationServices
MSMQ
Message queuing for Windows
Host Integration Server
IBM Mainframe Midrange connectivity
18
Microsoft Messaging Technologies
Microsofts MessagingIntegration Products
19
Message Styles
Technologies Advantages Challenges
RPC, oRPC SOAP v1 WCF HIS Simple Coding within the app Temporal and address coupled N(N-1) interfaces Interface coupling Protocol and format issues
MSMQ WCF SSB HIS More loosely coupled Temporally uncoupled Address coupled More concepts Protocol issues
BizTalk Server Loosely coupled Temporally uncoupled Address uncoupled Protocol agnostics process Even more concepts
Queued
Broker
20
Queued Messaging Queuing (MSMQ)

• Key features
• Queue, APIs (System.Messaging and WCF), MMC
• Either In memory and durable
• Not conversational (no notion of session)
• When to use
• Asynchronous communication is required between
  two or more Windows applications
• When the sender and receiver might not be running
  at the same time
• When message-level logging is required

21
Queued SQL Server Service Broker

• Key features
• T-SQL constructs
• Conversational, reliable styles
• When to use
• Connecting stored procedures in SQL Server with
  another instance in a messaging paradigm
• Applications that must receive a message and
  perform an update to SQL Server 2005 within the
  same transaction
• Need sticky conversations

22
Queued or Direct WCF

• Key features
• Simplified, re-factored, more capable distributed
  component stack
• Support for industry standard web services
  (WS-Sec,TX, RM)
• When to use
• Direct web services communication
• Direct Windows communication
• Queued Windows communication through MSMQ (future
  SSB)

23
Our new solution based on Microsoft .NET is
helping us improve efficiency through process
automation, support for workflows and work
queues, and improved planning and
reporting. Paramjit Chumber, Senior Vice
President and Chief Information Officer,
Countrywide Tax Services Corporation
Countrywide increases productivity for tax bill
procurement by 25 percent

• Built a new solution using the Microsoft .NET
  Framework and BizTalk Server 2004
• Can resolve some work automatically
• Supports work queue management
• Improves planning and reporting

• Wanted to integrate and streamline the process
  of obtaining tax bills
• AS/400 application had text-based UI and lacked
  basic workflow features
• All work was being done manually

• 4 of 56 technicians freed to do other jobs
• 25 percent productivity increase for remaining
  users
• 25 percent decrease in cycle times
• 365 hour reduction in planning time (year-to-date)

24
Define the flow and behavior of integrations
BizTalk orchestration
25
Mix people and automated processes
26
Broker BizTalk Server

• Key features
• Architecture for the intermediary End-Point
  Plug and Play, tracking, management
• Business process (State Management), activity
  monitoring, rules
• When to use
• Connecting multiple applications together
  including applications you didnt write (e.g
  MQSeries, SAP, etc)
• Implementing integration processes that run for
  hours, days, or weeks, and include business
  rules
• B2B integration requiring industry standards such
  as EDI, RosettaNet and HIPAA
• Creating business processes that give information
  workers real-time visibility into an integrated
  process

27
With Windows Server System and the .NET
Framework, we built a comprehensive solution to a
pressing business problem. Now, we can influence
our results instead of just reviewing
them. Robert Fort, Director of IT, Virgin
Entertainment Group, North America
Entertainment retailer expects store data
analysis to increase sales by 1.8 million

• Evaluated business intelligence software from
  Hyperion, Cognos, and Applix, but chose
  Microsoft Windows Server SystemTM as most
  cost-effective and easiest to use
• Worked with Xavor and Analysis Team to build a
  data-gathering and data-analysis solution

• Wanted to analyze its daily operations data more
  quickly and in greater depth
• Needed to provide simpler way for key staff to
  access crucial business metrics

• Expected savings of U.S.575,000 over comparable
  solutions
• Expected 1.8 million increase in overall revenue
• Increased store traffic from improved campaign
  analysis

28
Integration performance delivered

• EAI Scenarios
• Marks Spencer 2500 msgs/sec
• Lotte Magnet 100 msgs/sec
• London Drug 52 msgs/sec
• B2B Scenarios
• Akzo Nobel 5000 msgs/sec
• Osram Sylvania 800 msgs/sec
• New York Times 140 msgs/sec

gt5000 customers rely on BizTalk for
high-performance and high business value solutions
29
Microsoft Data Integration Technologies
Microsofts DataIntegration Products
Data integrationservice deeply integrated with
SQL
SQL IntegrationServices
30
SQL Integration Services

• Key Features
• ETL (Extract, Transform, Load)
• Error Handling Fuzzy Logic for data cleansing
• DB2 Oracle data providers included
• When to use
• Combining information from a group of operational
  databases into a data warehouse
• Transferring data from one DBMS to one or more
  other DBMSs
• Loading data into SQL Server databases from flat
  files, spreadsheets, and other diverse data
  sources

31
SQL Replication Services

• Key features
• Incremental changes
• User driven UI
• Support Across SQL Server, CE
• When to use
• Replicating data SQL Server tables (offline,
  client/server).
• Replication from and to Oracle and IBM databases

32
iSeries Customers and .NET
Self-service web-based application using BizTalk
for iSeries integration
eSkye
Plus Sinclair Broadcast Group, Piedmont
Behavioural Healthcare, Lance, Hope Network,
Dearborn Wholesale Grocers, Labatt Food Service,
Borgata Hotel/Casino, Dell, Affiliated Computer
Services, Rock-Tenn
http//www.microsoft.com/casestudies
33
I Hate Making Choices

• Often your scenario will require multiple
  patterns
• Aggregate bulk data from multiple stores to SQL.
  Enough stock? Reorder a part
• SSIS and BTS
• Receive a message through a Web Service and send
  to a mainframe
• WCF and HIS
• Shared technologies provide strong interop points

34
The Good News
VS 2005 Designers
Platform Interop
Support XML
NET FW 2.0
SKU
MSMQ
Windows
Web Services
WCF
Windows
SQL Server 2005 Service Broker
SQL 2005Express
BizTalk Server 2006
BTS 2006
Numerous
Host Integration Server 2006
HIS 2006
Numerous
SQL Server 2005 Replication
ODBC OLEDB
SQL 2005SKU
SQL 2005Standard
SQL Server 2005 Integration Services
OLEDB, ODBC Web Services
Comprehensive capabilities for integration on the
Microsoft platform
35
Microsofts Vision

• Improve the application platform
• Make application development easier
• Make application deployment simpler
• Make application management more cost efficient
• Provide operational excellence
• Make everything universally interoperable