Connecting SharePoint Server to Existing Investments in IBM Legacy Applications and Data

triangledriprockInternet and Web Development

Aug 7, 2012 (4 years and 11 months ago)

513 views

Guy Van Roy
Paul Larsen
Jon Fancey
Analysis

Reporting

Customer

Care

Teller

Register

Marketing

Sales

Mobile

Messages

Data

Programs

Network

Security

Consumers

Internet

Information

Services

Web

Services


BizTalk


SharePoint

Dynamics

SQL Server

Services

Messaging

Systems

Database Management

and File Systems

Microsoft

SQL Server




Trusted, Productive,
Intelligent Data Platform

Batch and Transaction
Processing Systems

Microsoft

BizTalk Server




Connecting Systems and
Orchestrating Process

Microsoft

Office SharePoint Server




Connecting People Process
and Information

Program Integration

Message Integration

Data Integration

Custom code


Develop components

(VS
,
BTS
,
SSIS
)
for connectivity,
optionally with data aggregation,
transformation
, security


Use custom code to integrate data
into any Office app


Include business
logic in
forms


Create reusable
custom Web Parts
and Workflow Activities



Customize


Automate task flows using
Workflow
Activities
connected to WCF Services


Connect Web Parts
to
BizTalk
Server
,

Databases
,
SOAP (XML and WCF)
Services
, REST Services
, XML
Files,
Linked
Data, using
Business
Connectivity Services (BCS)

Out
-
of
-
box


Publish connected info from
Office

apps (InfoPath,
PowerPivot
)


Connect Web Parts to
SQL Server
, and
then join data using
Distributed
Queries


Developer

Power User

NO CODE*

Advanced Developer

CODE

Beginner

Intermediate

SharePoint
Designer

SharePoint

SDK

Visual

Studio

Advanced


HPR/IP

TCP/IP

Windows
Server
2008

IBM z/OS , i5/OS, Server OSs

SNA Services

Communications

Server for i5/OS

Communications

Server for z/OS

Data Provider

for DB2

(DRDA AR)

UDB

Server

(DRDA AS)

Optimized Server

for DDM

(DRDA AS)

Distributed

Data Facility

(DRDA AS)

WCF Data Service

DB2 Database

DB2 Database

DB2 Database

Windows
Server
2008

PowerPivot for
SharePoint

Microsoft Windows Server 2008 R2

IBM z/OS

Relational Database Management System

Catalog and

Schemas

Distributed Data Facility (DDF)

IBM RACF Security for z/OS

CA eTrust CA
-
ACF2

CA eTrust CA
-
Top Secret

Packages

and Sections

Data Tables

and Views

Procedures

SQL Engine

Entity

Provider

BizTalk

Adapter

Office

SQL

Server

Metadata

Convert

SNANLS

Enterprise

SSO

OLE DB

Microsoft Client for DB2 (DRDA AR)

SNA

Services

WinAPPC

HPR/IP

WinSocket

TCP/IP

Comm Server

APPC

HPR/IP

Socket

TCP/IP

.NET App

ADO.NET

Service Components (Pooling, Security, Transactions)

.NET Data Provider for DB2

OLE DB Provider for DB2


HPR/IP

TCP/IP

Windows
Server
2008

IBM i5/OS and z/OS

SNA Services

Communications

Server for i5/OS

Communications

Server for z/OS

Data Provider

for Host Files

(DDM Client)

Optimized Server for
DDM

(DDM Server)

Distributed File
Manager

(DDM Server)

Physical and Logical
Files

SAM, VSAM, BPAM
Datasets

PowerPivot

for Excel

Windows
Server
2008

PowerPivot for
SharePoint

Windows Server 2008 R2

IBM z/OS

Systems Management Storage

ADO.NET

Application

BizTalk

Adapter

SQL

Server

Office

ADO.NET

Metadata

Convert

SNANLS

ESSO

BSAM

QSAM

ESDS

KSDS

Sequential

Access

Method (SAM)

RRDS

Altldx

PDS

PDSE

Basic Partitioned

Access Method

(BPAM)

Virtual Storage Access Method

(VSAM)

Data Facility Storage Management Subsystem

(DFSMS)

IBM RACF Security for z/OS

CA eTrust CA
-
ACF2

CA eTrust CA
-
Top Secret

Distributed File Manager (DFM)

Record
-
Level Input/Output (RLIO) Engine


OLE DB

Service Components (Pooling, Security)

Microsoft Client for Host Files (DDM RLIO
Client)

ADO.NET Data Provider

for Host Files

OLE

DB
Provider

for AS/400

and VSAM

SNA

Services

WinAPPC

HPR/IP

Comm Server

APPC

HPR/IP

HPR/IP

Windows
Server
2008

IBM z/OS and i5/OS

TCP/IP

Windows
Server
2008

SNA Services

Communications

Server for z/OS

Transaction

Integrator

CICS Intersystem

Communications

IMS Connect

Optimized Server for
Remote Program Call

WCF Service

SOAP

CICS Program

(EXEC CICS LINK)

IMS Program

i5/OS Program

(CALL PGM)

SharePoint

Business Connectivity
Services

IBM z/OS

Windows Server 2008 R2

SNA

Services

WinAPPC

HPR/IP

Transaction Processing Systems

IBM RACF Security for z/OS

CA eTrust CA
-
ACF2

CA eTrust CA
-
Top Secret

WCF Service

XML Web

Service

BizTalk

Adapter

.NET

Application


Enterprise

SSO

Metadata

WinSocket

TCP/IP

Comm Server

APPC

HPR/IP

Socket

TCP/IP

CICS

Inter
-
System

Communications

IMS

Connect

EXEC

CICS

Link

CICS

Transaction Program

IMS

Transaction

Program


Convert

SNANLS

Transaction Integrator

Protocol Clients

Transaction Integrator Runtime

IBM z/OS

CICS Panel

Program

3270

HPR/IP

ADO.NET

Consumer

Windows
Server
2008

CICS Sender

Program

TDS

SQL Server 2008

Windows
Server
2008

TCP/IP

Communications

Server for i5/OS

SNA Services

CICS Intersystem

Communications

TI HIP

Listener Service

HPR/IP

Windows
Server
2008

TCP/IP

Windows
Server
2008

SNA Services

Message

Integrator

WCF Service

SOAP

SharePoint

Business Connectivity
Services

Communications Server

for z/OS and i5/OS

WebSphere MQ

for z/OS

CICS Program

(MQ Bridge)

IMS Program

(MQ Bridge)

WebSphere MQ

for i5/OS

i5/OS Program

Hub

Queue

Manager

IBM z/OS and i5/OS

HPR/IP

TCP/IP

Communications Server

for z/OS and i5/OS

WebSphere MQ

for z/OS

CICS Program

(MQ Bridge)

IMS Program

(MQ Bridge)

WebSphere MQ

for i5/OS

i5/OS Program

Channel

Spoke

Queue

Manager

Hub

Queue

Manager

IBM z/OS and i5/OS

Windows

Server 2008

Windows

Server 2008


BizTalk Adapter or
WCF Channel

WebSphere MQ

Client for Windows

SNA Services

WebSphere MQ

Server for Windows

SNA Services


BizTalk Adapter

or WCF Channel

WAN

Windows
Server
2008

SNA Services

IBM Data
Center

IBM
System z

HPR/IP

Branch

Offices

TCP/IP

WAN

Windows
Server
2008

SNA Services

TCP/IP

Host System
Product Versions
Operating Systems

IBM z/OS V1.9, V1.10 and V1.11

IBM zVSE V4.1 and V4.2

IBM zVM V5.4 and V6.1

IBM i5/OS V5R4 and V6R1

Transaction Processing
Management Systems

IBM CICS for z/OS V3.1, V3.2 and V4.1

IBM IMS V10 and IMS V11

IBM i5/OS V5R4 and V6R1

Message Processing Systems

IBM WebSphere MQ for z/OS V 6.0, V7.0, V7.0.1

IBM WebSphere MQ for z/VSE V3.0

IBM WebSphere MQ for iSeries V5.3 and V6.0

Relational Database

Management Systems

IBM DB2 for z/OS V8.1 and DB2 for z/OS V9.1

IBM DB2 for i5/OS V5R4 and V6R1

IBM DB2 for Windows, UNIX, Linux V9.1, V9.5, V9.7

File Systems

IBM DFSMS DFM z/OS V1.9, V1.10 and V1.11

IBM i5/OS V5R4 and V6R1