Windows and .NET for

acceptableseashoreSecurity

Nov 5, 2013 (4 years and 8 days ago)

128 views

Windows and .NET for
iSeries Interoperability

Charles Machalani, Solution Architect

Charles.machalani@microsoft.com


Karen McGregor, .NET Architect Evangelist

Karen.mcgregor@microsoft.com


Microsoft Canada

Devices

Information

People

Systems

Microsoft .NET

Software to connect
information,

people,

systems

and
devices

Our vision
: provide the platform to

rapidly build and evolve

connected applications

User Interface Layers

Office XP



DOCUMENT
I/O

ASP.NET
Mobile
Toolkit



THIN

DEVICE UI

Sharepoint

Server

USER DOC

WORKFLOW

Exchange

Workflow

COLLAB.

WORKFLOW

ASP.NET
WebForms

Digital
Dashboard


WEB
BROWSER UI

ASP.NET

WEB UI

.NET
Windows
Forms



SMART CLIENT

UI


WINDOWS UI


OFFLINE
CLIENT

UI Process and UI

Outlook XP

Exchange
Forms


MESSAGING


UI

XML Web Services

UI Components

UI Process Components

Services Layer

Business Process
Automation

ADO.NET DataSets

BizTalk
Messaging

Biz Document
Exchange

Biz Document
Transformation

Business Workflows, Components,
Entities and Service Interfaces

XML
-
Serializable
Objects


XML Document
Management

Long
-
Running
Conversations

XML Web Services

ASP.NET Web
Services

Persistent
Messaging

MSMQ
Listeners

Application
Endpoints

.NET Remoting

& DCOM

Distributed
Transaction Mgmt

Enterprise Services
(Windows)


Role
-
Based Security


Business Component
Hosting

.NET frameworks

Enterprise Services
(Windows)


BizTalk Server

Business
Workflows

Business
Components

Business
Entities

Service Interfaces

Data Access Components

Web
Service

Data Access and Services
Agents

.NET Framework

BizTalk Adaptors

(300+)

VS.NET

Web Proxy

SQL

DB2

LDAP

WebSphere

CICS

iSeries

Legacy

CRM / ERP

Application
Data

Other Data

Sources

Messaging
Data

Legacy

Systems

XML Web
Services

Other

Services

SQL
Server

Adapters

Exchange
2005

ADO.NET
Providers

WSE

Data Access Logic
Components

Service Agents

Data

Sources

Services

.NET Roadmap


2005

2006

2007

Beta

Beta

Beta

Database Developer

Windows Workflow

Enterprise

Library 2.0

2005

Networking

Data

Management

UNIX Systems

Integration

XML

Web
Services

Industry
Standards

Languages

Applications

Identity

Legacy
Hosts

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



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 System
TM

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


Offered its fifty biggest customers the ability to order online and to consult all
information about deliveries and past orders via the Internet

.

"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

Deploy hosts in modern scenarios

BizTalk, Windows and/or .NET connectivity

TCP/IP

and SNA

Network
Integration

TCP/IP

and SNA

COM, XML,
Message
Queuing

Application
Integration

APPC, CPI
-
C,
DPL, LUA,
BMS, 3270,
MQ

ADO, OLEDB,
ODBC

Data
Integration

DDM (DRDA &
RLIO), XA,
TDS, CLI,
DBLIB

IBM zSeries mainframe & iSeries midrange resources

Host
Integration

Adapters

Integrated applications,
web portals, smart clients

BizTalk and .NET

Countrywide increases productivity for tax bill
procurement by 25 percent



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


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


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


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)

Mix people and automated processes

BizTalk

Servers

Web Services

SQL
Server

Outlook

SharePoint

InfoPath

Apps or embedded flows

InfoPath

BAM & SQL RS


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




Evaluated business
intelligence software
from Hyperion, Cognos,
and Applix, but chose
Microsoft
®

Windows
Server System
TM

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

Entertainment retailer expects store data analysis to increase
sales by $1.8 million

“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

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

>5000 customers rely on BizTalk for high
-
performance and high business value solutions

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

iSeries Customers and .NET

Alticor, Sandvik,
St Louis Zoo

BI and data warehousing solutions in
SQL 2005 using data from DB2/400

Self
-
service web
-
based application
using BizTalk for iSeries integration

Thomas Miller &
Co.

XML for claims processing, using data
replication for iSeries integration

Cbk

Visual RPG .NET for Sales Force
Automation

http://www.microsoft.com/casestudies

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 …

eSkye

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

MSMQ

WCF

SQL Server 2005

Service Broker

BizTalk Server 2006

Host Integration

Server 2006

SQL Server 2005

Replication

SQL Server 2005

Integration Services

NET FW 2.0

VS 2005

Designers

Platform

Interop

Support

XML

SKU

Web

Services

Numerous

Numerous

ODBC

OLEDB

OLEDB, ODBC

Web Services

Windows

Windows

SQL 2005

Express+

BTS 2006

HIS 2006

SQL 2005

SKU+

SQL 2005

Standard+

The Good News

Comprehensive capabilities for integration on the Microsoft platform

Microsoft’s 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