Post on 04-Sep-2020
2008/3/28
IBM Confidential 1
®
IBM Software Group
© 2008 IBM Corporation
主機資料庫整合存取軟體WebSphere Classic Software
Helen LiuSWG, Taiwan
IBM Software Group
2
Agenda
IBM Information Server
WebSphere Classic V9.1 SoftwareWebSphere Classic Federation Server for z/OS
WebSphere Classic Data Event Publisher for z/OS
WebSphere Classic Replication Server for z/OS
WebSphere Data Integration Connector for z/OS
2008/3/28
IBM Confidential 2
IBM Software Group
3
SOA Reference Architecture
App
s &
In
fo A
sset
s
Business Innovation & Optimization Services
Dev
elop
men
tSe
rvic
es
Interaction Services Process Services Information Services
Partner Services Business App Services Access Services
Integrated environment for design
and creation of solution
assets
Manage and secure services,
applications &
resources
Facilitates better decision-making with real-time business information
Enables collaboration between people,
processes & information
Orchestrate and automate business
processes
Manages diverse data and content in a
unified manner
Connect with trading partners
Build on a robust, scaleable, and secure services environment
Facilitates interactions with existing information and application assets
ESBFacilitates communication between services
IT S
ervi
ceM
anag
emen
t
Infrastructure ServicesOptimizes throughput,
availability and performance
IBM Software Group
4
Information Services in IBM ProductsBusiness Information Services
WebSphere Customer CenterWebSphere Product CenterIBM Entity Analytics
Information Integration ServicesIBM Information Server
Content & Discovery ServicesWebSphere Information
Integrator Content Edition
Data ServicesDB2 V9
2008/3/28
IBM Confidential 3
IBM Software Group
5
The IBM Solution: IBM Information ServerDelivering information you can trust
Understand Cleanse Transform Deliver
Parallel ProcessingRich Connectivity to Applications, Data, and Content
IBM Information Server
Discover, model, and govern information
structure and content
Standardize, merge,and correct information
Combine and restructure information
for new uses
Synchronize, virtualizeand move information
for in-line delivery
Unified Deployment
Unified Metadata Management
IBM Software Group
6
Understand Cleanse Transform & Move Deliver
IBM Information Server
WebSphere QualityStage
WebSphere Information Analyzer
WebSphere Classic Federation Server for z/OSWebSphere DataStage
WebSphere Business Glossary
IBM Metadata Server
Parallel Processing
IBM Information Server
WebSphere Classic Data Event Publisher for z/OS
WebSphere Classic Replication Server for
z/OS
Rich Connectivity to Applications, Data, and Content
2008/3/28
IBM Confidential 4
®
IBM Software Group
© 2008 IBM Corporation
WebSphere Classic Federation Server for z/OS
IBM Software Group
8
Read-from and write-to mainframe data sources using SQL from Unix, Windows, Linux and JVM platformsStandard ODBC/JDBC SQL interfaces
ODBC 3.5.1, JDBC 2.1 (some 3.0) type 4
Metadata-driven means:No mainframe programmingrequired Fast installation &Configuration Ease of maintenance
Works with existing and new:Mainframe infrastructureApplication infrastructureToolsets
Deliver mainframe data toSelf-service portals (real-time account details)e-commerce solutions (real-time inventory)Reporting and analytical tools, e.g. Business ObjectsData transformation and cleansing (e.g. DataStage, QualityStage)for data warehousing
WebSphere Classic Federation Server for z/OS
DB2 UDBfor z/OS
Software AGAdabas
VSAM,IAM &
sequential
CA IDMS
CA Datacom
IMS
2008/3/28
IBM Confidential 5
IBM Software Group
9
WebSphere Classic Federation:Standard SQL 92 Support
SELECT/INSERT/UPDATE/DELETE all supported
Standard SQL error handlingSQL error and response codes returned as part of result
Single and two phase commitCommit - Rollback - Autocommit supported for all data sourcesRolling delivery of two phase commit: DB2, IMS and CA-Datacom available now
Stored Procedure “Call” leverages existing programsReuse mainframe algorithmsInvoke IMS transactionsInvoke CICS applications
DBCS SupportClient-based conversionIMS, VSAM, DB2, CA-IDMS, sequential
IBM Software Group
10
WebSphere Classic Federation:Fits into Mainframe Control Infrastructure
Governors – prevent the runaway userLimit resource utilizationSet at installation, server and/or user levels
Security – ensure only authorized accessSAF exit for RACF, ACF and TopSecretOptional embedded DB2-like security
Monitor and control usageLeverage existing system toolsSMF type 99 and/or custom exit for charge-back and other accounting purposes
Tracing and Logging by levelRemote and local monitoringTriggered and post-mortem tracing
2008/3/28
IBM Confidential 6
IBM Software Group
11
WebSphere Classic Federation Server for z/OS v9.1
Interactive metadata managementDynamic discovery from sourcesEclipse GUI for "all" metadata
Available on Cascade & Eclipse platformsNo more "USE" grammar editingPrimary key support
"Accessibility" Client configuration
AIX, HP-UX,Solaris, Linux,
Wintel, JVM
z/OS
Tool Application
MetadataCatalog
Classic FederationServer
ClassicData
Architect
Copybooks, DBDs, …
Classic FederationClient
Classic FederationData Connectors
IBM Software Group
12
Metadata CatalogMetadata defines business-oriented relational mappings
Import existing copybooks, IDMS schemas, IMS DBDs, Predict & DB2 catalogGenerate logical relational reference table definitionsGUI to customize logical tables to business requirements
Simulated RDBMS catalog and moreRDBMS-like catalog support: systables, syscolumns, etc.Query-able tables for non-relational metadata
Some metadata-driven featuresAutomatic translation of legacy data typesHandles legacy constructs like recurring data and redefines
Metadata UtilitiesCreate and update metadata catalog entriesDynamic update, no impact on tools using the metadataVerify metadata against physical (e.g. VSAM index checks)
metadatacatalog
Classic Data ArchitectClassic Data Architect
metadatautilities
Copybooks, DBDs, …
2008/3/28
IBM Confidential 7
IBM Software Group
13
Metadata Usage
Controls how to use native data access APIs including indexes, keys, etc.
Enables complex logical tables and views:
Tables that span multiple segments/records
Views that restrict access based on WHERE qualification
Relates redefined “record types” to distinct logical tables
Heterogeneous JOIN spanning database & filetypes
IBM Software Group
14
Components
ClientsJDBC, JCA and ODBC
Metadata CatalogGenerated from the Classic Data Architect
Classic Data ArchitectAdministration tool to mapping data definitions to logical tables
Data ConnectorsDatabase specific read/write access engines
Federation ServerCore mainframe-based SQL engine
2008/3/28
IBM Confidential 8
IBM Software Group
15
MetadataCatalog
z/OSOS/390
DB2 UDB z/OS VSAM IMS CA-Datacom CA-IDMSAdabas
WebSphere Classic Federation Operational Environment
Data Connector
Data Connector
Data Connector
Data Connector
Data Connector
Data Connector
Portal BI Tool Servlet Servlet Clientclass
EJB
AIX, HP-UX, Solaris, JVM,Widows XP, 2003,
UNIX System Services ODBC Client JDBC Client
Classic Data ArchitectClassic Data Architect
Copybooks, DBDs, …
Classic Federation Server for z/OS
IBM Software Group
16
Operational Elements – Clients
Target Platform Clients -JDBC, ODBC and CLI (call level interface)Retrieve metadata using catalog queriesIssue SELECT-INSERT-UPDATE-DELETECommunicate with Server using TCP/IP or MQSeriesMulti-threaded
JDBC can participate in a J2EE Connection Pool
Portal BI Tool Servlet Servlet Clientclass
EJB
AIX, HP-UX, Solaris, Widows XP, 2003,
UNIX System Services ODBC Client JDBC Client
2008/3/28
IBM Confidential 9
IBM Software Group
17
MetadataCatalog
z/OSOS/390
Operational Elements -- Mainframe
Federation ServerRuns in its own address spaceRespond to Catalog QueriesManage mainframe resourcesDistribute SQL to Data ConnectorsAssemble Result Set
Data ConnectorsDatabase specific read/write enginesDetermine how to access DBs & FilesLeverage native access aidsReentrant for small footprint
DB2 UDB z/OS VSAM IMS CA-Datacom CA-IDMSAdabas
Data Connector
Data Connector
Data Connector
Data Connector
Data Connector
Data Connector
Classic Federation Server for z/OS
IBM Software Group
18
WebSphere Classic Federation Server for z/OS v9.1Focus on usability
Classic Data Architect – robust, visual meta data managementDistributed component installer, including uninstallIntegration with DataStage for z/OS via a CLI Client on USS
Continue to fill functionality "holes"Primary key support Handle zoned-decimal conversion errors by returning all 9sBasic support for Transactional VSAM – enhance WAS-z market
Keeping up with technologyExpanded client platform support (64 bit AIX and Solaris)
PerformanceMulti-threaded at all levels: maximize parallel processingMajor DB2 performance enhancement, especially in a JOINNon-reformatting interface for DataStage
Eliminate transformation overhead on z
2008/3/28
IBM Confidential 10
IBM Software Group
IMS – Course Management
Data about the courses reside in IMS:
What courses are available
What laguage they are held in
When and where
Who is enrolled (participants)
Who lectures
Language4 LANGUAGE SEQ,U
40 TITLE
Instance12 COURSEID SEQ,U
8 BEGDATE
4 LOCID
4 BEGTIME
8 ENDDATE
4 ENDTIME
Partcpnt5 PERSID SEQ,U
Lecturer
5 PERSID SEQ,U
Course6 ID SEQ,U
40 TOPIC
40 TYPE
IBM Software Group
Hierarchy to Relational Mapping - Participant
Only the fields of the lowestmapped segment can beupdated--if the PCB allows it.
Language4 LANGUAGE SEQ,U
40 TITLE
Instance12 COURSEID SEQ,U
8 BEGDATE
4 LOCID
4 BEGTIME
8 ENDDATE
4 ENDTIME
Partcpnt5 PERSID SEQ,U
Lecturer
5 PERSID SEQ,U
Course6 ID SEQ,U
40 TOPIC
40 TYPE
CAC.PARTCPNTID LANGUAGE COURSEID BEGDATE LOCID PARTCPNT
Editable: GET, ISRT, REPL, DLET
Read only: GET
2008/3/28
IBM Confidential 11
IBM Software Group
Hierarchy to Relation Mapping – Sample Tree
INSTANCEBegDate LocID BegTime EndDate EndTime Price
20051004 LNDN 1400 20051006 1600 14
CAC.PARTCPNTID LANG
UAGECOURSEID BEGDATE LOCID PART
CPNT
ZS101 GER 20050401EHN 20050401 EHN 00001ZS101 GER 20050401EHN 20050401 EHN 00002
ZS101 ENG 20050401LNDN 20050401 LNDN 00001
ZS101 ENG 20050401LNDN 20050401 LNDN 00003
00002
PARTCPNTID
0000100003
PARTCPNTID
00001
COURSEID Topic TypeZS101 HEATING YOUR HOUSE WITH A Z-SERIES CLASSROOM
ENG PROFESSIONAL HEATING WITH A Z-SERIES
LANGUAGELang TitleGER HEIZEN MIT EINEM RECHNER DER Z-SERIE
INSTANCEBegDate LocID BegTime EndDate EndTime Price
20050401 EHN 1000 20050401 1700 14
IBM Software Group
22
Example job: Load IMS data into DB2 LUW
1. Classic Federation stageConnects to Classic Federation ODBC/CLI clientRuns SQL SELECT statement against CFS data serverRetrieves result set and passes it no next stage in job flow
2. DB2 stageReceives rows from previous stage in job flowCreates or replaces DB2 target tableLoads rows into target table
2008/3/28
IBM Confidential 12
IBM Software Group
23
Integration in Action – Major US-Based Airline某美國航空公司
提供飛行哩程酬賓會員及時資訊
Dynamically connect Web site to IMS & VSAM operational dataEliminate copies of flight data reducing cost, data latency and
errors
會員會員
TCP/IP
Windowsz/OSBoardingPasses
Frequent Flyer
Web Site
Up to
seco
ndm
ileag
e cre
dit
ClassicFederation
ServerIMS
Flight Operations
VSAMVSAMIMS
ClassicFederation
ODBC Client
會員會員
IBM Software Group
24
Integration in Action – Large Insurance Carrier某大型保險公司
Provide up-to-the-minute policy, claims and accounting informationDynamically connect interactive voice response system to IMS, VSAM & DB2Connect operational data with self-service Web sites
業務業務
客戶客戶
醫生醫生
WinTCP/IP
z/OS
IVR*
PolicyManagement
SelfService
WebSites
Solaris
AgentsAgents
DB2 VSAM
ClassicFederation
JDBC Client
ClassicFederation
ODBC Client
IMS
ClassicFederation
Server
* Interactive Voice Response* Interactive Voice Response
Billing
Claims
2008/3/28
IBM Confidential 13
IBM Software Group
25
IBM Solution - Single-source mission critical dataSeamlessly share order processing data and business logic
No impact on call-centersNew WebSphere e-commerce applications share critical dataLeverage “common” procedures such as ship-to-date calc or pricingWebSphere Studio development independent of mainframe skills
客戶
客戶
客戶TCP/IP
訂單處理
e-CommerceSite
Solaris業務代表
業務代表
運送日計算
Server ClientIDMS
z/OS
E-commerce website for European-based catalog retailer某歐洲郵購公司
IBM Software Group
26
Building DWH based on Oracle and running on Sun Solaris. ETL solution is to extract data from VSAM and CICS/VSAM files on the mainframe and populate warehouse on Oracle
VSAM files are internal files owned by Kirchman banking software
SolarisKirchman
Banking SWDataStage
TCP/IPVSAMCICS/VSAM Server
ODBC Client
z/OS
ODBCStage
Large Bank in Eastern Europe 某歐洲大型銀行IBM Solution – Feed VSAM data into Oracle DWH
OracleDWH
2008/3/28
IBM Confidential 14
IBM Software Group
27
Pull operational data from IMS and populate Teradata data warehouse
IBM solution is based on WebSphere DataStage and WebSphere Classic Federationfor z/OS
Processing 3 million rows in 15 minutes
AIXClaims,
Policies, etcDataStage
TCP/IPServerODBC Client
z/OS
ODBCStage
Large Insurance Company in Northern Europe某歐洲大型保險公司IBM Solution – Feed IMS data into Teradata DWH
TeradataData WarehouseIMS
IBM Software Group
28
IBM solution -- feed operational data to ETL via SQLDynamically connect data warehouse tool with mainframe data
No dependence on mainframe developmentDramatically simplified management: One team owns it all
One consistent process leverages “power” of ETL toolingDevelopment time “cut in half”
Empowers additional usesDynamic query by business intelligence tools extends the warehouse
Credit
Marketing
NT
BusinessIntelligence
AccurateinformationInventory
Management
OrderProcessing
WarehouseBuilders
DataMarts
DataMartsData
Marts
Sales
TCP/IPVSAMIMS DB2 Server Client
z/OS
BI solution for international manufacturer of recreational vehicles某國際製造商
2008/3/28
IBM Confidential 15
IBM Software Group
29
Leveraging existing infrastructure to implement IFRS and Basel II requirements at large German bank某大型德國銀行
SAP ERP Hostsystem Murex
MQ InterfaceMQ Interface
MQ InterfaceMQ Interface
MQ
HeLaBa – Integration Platform(Transport, Mapping, Routing)
WebSphere MQWebSphere BI Message Broker
HostfilesHostfiles
Sun
ADABAS
HostHost
MQ InterfaceMQ Interface MQ InterfaceMQ Interface
SAP FDB
Win2k
Gloria DB2
HostWin2k
MQ MQ SQLMQzOS
MQ, SQL
Win2k
II Classic Fed.II Classic Fed.
MQ
Adapter
Helaba COBOLSubroutines
Helaba COBOLSubroutines
Win2k
MS SQL
MQ, SQL
Host
•Critical business need was complying with International Financial Reporting Standards (IFRS) based on SAP’s IFRS-solution.
•Corporate strategy mandate to leverage existing infrastructure to implement the requirements IFRS and Basel II.
•Operational Data resides on various data management systems like Adabas from Software AG and sequential Files on z/OS.
•Critical requirement was to deliver the right data to the right time with minimal development efforts. •Solution benefits include reduced requirements for ETL resources, increased reliability, robust performance and real time delivery of complex information.
IBM
®
IBM Software Group
© 2008 IBM Corporation
WebSphere Classic Data Event Publisher for z/OS
2008/3/28
IBM Confidential 16
IBM Software Group
31
WebSphere Classic Data Event Publisher for z/OSReal-time &/or background capture & publishing of data changes for:
VSAM filesIMS databasesCA-IDMS databasesSoftware AG Adabas databases
IBM owns multiple Event Publishing infrastructures:WebSphere Data Event Publisher (DB2 on LUW and z/OS)WebSphere Classic Data Event Publisher (VSAM, IMS, …)WebSphere Business Event Publisher (focus is on PROCESS, some data)
VSAMchanges
IMSchanges
DB2 UDBfor z/OS changes
changes changes
CA-IDMSchanges
WebSphere MQ
AdabasChanges
Data Event Publisher Classic Data Event Publisher
IBM Software Group
32
Changes
“Classic” Event Publisher ImplementationThe Enhancements
Focus on usabilityClassic Data Architect
Robust, visual meta data managementDistributed component installer
Including uninstallIntegration with DataStage
Using a Delimited Values output
Continue to fill functionality "holes"View support for redefined data Alternative VSAM capture option
CICS Autojournal - reduces resource utilizationVSAM "batch" coverage
Native VSAM file capture - for Batch-made changes
Support "iskey"
z/OS
metadatacatalog
WebSphere MQ
IDMSJournaling
ClassicData Architect
Adabaslogging
IMSlogging
MVSlog
VSAM
CICS Auto-
journal
Classic Event PublisherServer
Classic Event PublisherChange Capture Agents
2008/3/28
IBM Confidential 17
IBM Software Group
33
Event Publisher for IMS Overview
z/OS
MetadataCatalog
IIMMSSLogLog
Applications IMS
Chan
ges
IMS ActiveCCA
Changes
IMS
correlation service
Distribution service WebSphere MQ
Queue Manager
IMS RecoveryCCA
Chan
ges
CHANGESChanges
IBM Software Group
34
One Capture, One Server, Many OutputsReusable Parts
Multiple Distribution ServicesXML – for broad applicabilityCDV– for custom-delimited-values
Simplifies DataStage integrationCan be used with other 3rd party tools
– Informatica– Business Objects
Replication – for hook to Q-Rep
WebSphere MQWebSphere MQ
WebSphere MQ
metadatacatalog
Distribution service - CDV
CHAN
GES
Distribution service - REP
correlation service
Classic Data ServerDistribution
service - XML
2008/3/28
IBM Confidential 18
IBM Software Group
35
Example XML message
...
IBM Software Group
36
Example delimited messages
8,"IBM","2006030","1523180005","TEST","EMPLOYEE","ISRT","A",100, "John","Doe", "MGR", "SALES",120000,12000
8,"IBM","2006030","1523180305","TEST","EMPLOYEE","REPL","B",110, "Ed","Son", "MGR", "SALES",109000,10000
8,"IBM","2006030","1523180305","TEST","EMPLOYEE","REPL","A",110, "Ed","Son", "MGR", "SALES",129000,12000
2008/3/28
IBM Confidential 19
IBM Software Group
37
Example job:Real time IMS change data feed into DB2 LUW
1. MQ stageConnects to MQ message queueReceives XML messages
2. Event Publisher stageTurns XML into internal row formatFilters messages by source tables 3. Switch stage
Passes insert / update / delete operations to separate output links
5 .File stageTracks XML messages that have been rejected by Event Publisher stage
4. DB2 stageProcesses insert/update/delete operations on target database table
IBM Software Group
38
Solution is to feed DB2 DWH with IMS data and keep it up-to-date in real time
Classic Federation and DataStage are used to load DB2 DWH with IMS data
EventPublisher for IMS is used along with DataStage to push real-time updates into theDWH
z/OS應用
IMS
核心銀行
CHANGES
資料倉儲
Data Stage
WebSphere MQ XML Stage
Large Bank in Turkey某大型土耳其銀行IBM Solution – Replication using Event Publisher for IMS and DataStage
TCP/IP
ServerODBC Client
2008/3/28
IBM Confidential 20
IBM Software Group
39
IDMS to DB2 z Migration – IDMS至DB2 z/OS的轉換Smooth migration from CA IDMS to DB2 for z/OS over several years
Two-way replication scenario keeps both IDMS and DB2 in sync
Custom Java programs handle transformations and exceptional situations
To avoid conflicts,old applications only update IDMS, new applications only DB2
Classic FederationServer
Classic DataEvent Publisher
Data EventPublisher for z/OS
DB2 Connect
Custom Java program
running under USS
Custom Java program
running under USS
Old Assembler and COBOLapplications
New J2EEWeb
applications
IDMS DB2 z
XML messages viaWebSphere MQ
XML messages viaWebSphere MQ
JDBC
JDBC
CHANGES
CHANGES
INS UPD DEL
INS UPD DEL
Classic FederationServer
IBM Software Group
40
Event Monitoring using Classic Event Publisher at large technology distributor某大型配銷商
z/OS
OrderProcessing PaymentReturn
Business Reports
CICS transactionsprocessing
Orders, Payments,
Returns etc.
HTML Documents
IMS
PartnerApplication
Systems
XML
Partner Connectivity
Gateway
Classic
WebSphere MQ
Oracle ODS
CHANGES
2008/3/28
IBM Confidential 21
IBM Software Group
41
Data Source Overview
NOYESYESNOYES (4)YES (3)YESReplication source
NOYESYESNOYES (4)YES (3)YESChange capture
YESYESYESNOYESYES (2)YESWrite (1)
YESYESYESYESYESYESYESRead (1)
V10, V11R15, R16
R14 on request
7.1.3,7.4.3+not 7.4.2 !
z/OS 1.6V7, V8z/OS 1.4CICS TS2.2 / 2.3 / 3.1
V8, V9
V7 on request
Supported
Versions
CA DatacomCAIDMSSW AG AdabasSequential
FilesDB2 z
VSAM &
CICS/VSAMIMSData Source
(1) Supported by WebSphere Classic Federation Server(2) If not using CICS, SQL ROLLBACK in not available (AUTOCOMMIT only)(3) If not using CICS, recovery is not supported (risk of missing changes in case of a crash)(4) Non supported by Classic products but by Data Event Publisher for z/OS and Replication Server
for z/OS (these products are based on Q-Replication technology)
®
IBM Software Group
© 2008 IBM Corporation
WebSphere Classic Replication Server for z/OS
2008/3/28
IBM Confidential 22
IBM Software Group
43
WebSphere Classic Replication Server V9.1Non-relational replication of System z data
"Classic capture" in this releaseVSAM, IMS
Replication Server provides the "apply": DB2 on all platforms, Oracle, SQL Server, Informix and Sybase on distributedExpanded targeting and transformation via Replication Server apply
UnidirectionalClassic to RDBMS
Basic cross-product toolingUse Replication Server's command line processor (ASNCLP)Supported platforms based on "Classic" CLI Client support
ControlControl
Log based
ClassicSource
Admin
WebSphereMQ
TargetQ-RepApply
Utilities
ClassicCapture
WS Classic Replication Server for z/OS WS Replication Server … LUW and/or z/OSIMS
VSAMCA-IDMSADABAS
IBM Software Group
44
Control
Q Replication Sources and Targets
VSAM
IMS
DB2
DB2
DB2
WebSphere Replication Server (LUW)
DB2
Informix
Oracle
SQL Server
Sybase
Control
Federation Engine
WebSphere MQ
ApplyCapture
Sources Targets
WebSphere Replication Server for z/OS
WebSphere Classic Replication Server for z/OS
WebSphere Replication Server for z/OS
WebSphere Replication Server (LUW)
VSAM
IMS
LUW: Windows 32 & 64-bit X86, AIX 64-bit, Solaris 64-bit, Linux 32 & 64-bit X86 systems, Linux 64-bit Power, Linux 64-bit zSeries
2008/3/28
IBM Confidential 23
IBM Software Group
45
WebSphere Replication Server (LUW)
WebSphere Classic Replication Server for z/OS
Control
Q Replication Scenario #1 – What if you want to …
VSAM
DB2
DB2
DB2
Informix
Oracle
SQL Server
Sybase
Control
Federation Engine
Apply
WebSphere MQ
Capture
Sources TargetsWebSphere Replication Server for z/OS
WebSphere Replication Server for z/OS
WebSphere Replication Server (LUW)
Software AGAdabas
CA-IDMS
DB2
IMS
DB2
…Replicate from IMS to DB2 for z/OS (on same system or different system) and DB2 for AIXSource system (Capture) : Purchase Value Units for WebSphere Classic Replication Server for z/OS
z/OS Target system (Apply) : Purchase Value Units for WebSphere Replication Server for z/OS
AIX Target system (Apply) : Purchase Value Units for WebSphere Replication Server
IBM Software Group
46
DB2
IMS
Control
Q Replication Scenario #2 – What if you want to …
DB2
DB2 WebSphere Replication Server (LUW)
DB2
Informix
Oracle
SQL Server
Sybase
Control
Federation Engine
WebSphere MQ
ApplyCapture
Sources TargetsWebSphere Replication Server for z/OS
WebSphere Classic Replication Server for z/OS
WebSphere Replication Server for z/OS
WebSphere Replication Server (LUW)
Software AGAdabas
CA-IDMS
VSAM
Oracle
…Replicate from VSAM to Oracle on HPz/OS Source system (Capture): Purchase Value Units for WebSphere Classic Replication Server for z/OS
HP Target: Purchase Value Units wherever WebSphere Replication Server is installed for federated apply
2008/3/28
IBM Confidential 24
®
IBM Software Group
© 2008 IBM Corporation
WebSphere Data Integration Classic Connector for z/OS
IBM Software Group
48
WebSphere Classic Data Integration Connector V9.1Formalizing today's PRPQ product… Entry point pricing for limited use
Restricted for use with: WebSphere DataStageWebSphere QualityStage WebSphere ProfileStageIBM Information Server components (when available)
AccessSequential
files
CICSlogs &
journals
IMSlogging& logs
DB2logging& logs
PublishIMS
PublishVSAM
WebSphere Event Publisher
for DB2
WebSphere Data Integration Connector for z/OS
VSAM& IAMfiles
IMSDB2 CA-IDMS
AccessAdabas
AccessIDMS
AccessDatacom
AccessVSAM
AccessIMS
AccessDB2
ADABASCA-Datacom
WebSphereMQ
CA-IDMSjournaling& journals
PublishIDMS
Adabaslogging& logs
PublishAdabas
TCP/IP
CDC EXTRACTDataStage
ProfileStage
QualityStage
2008/3/28
IBM Confidential 25
IBM Software Group
49
WebSphere Information Integration V9.1 Classic Products
WebSphere Classic Federation Server
for z/OS
5655-R52
• Access to Adabas• Access to IDMS• Access to IMS• Access to VSAM• Access to Datacom• Access to DB2
WebSphere Classic Data Event Publisher
for z/OS
5655-R54
• Publishing of Adabas• Publishing of IDMS• Publishing of IMS• Publishing of VSAM
WebSphere Data Integration Classic Connector for z/OS
5655-R57
• Access to Adabas• Access to IDMS• Access to IMS• Access to VSAM• Access to Datacom• Access to DB2• Access to Sequential• Publishing of Adabas• Publishing of IDMS• Publishing of IMS• Publishing of VSAM
WebSphere Classic Replication Server
for z/OS
5655-R53
• Replicating Adabas• Replicating IDMS• Replicating IMS• Replicating VSAM
IBM Software Group
50
Wrap-up –Value to the Business對企業的價值
Extend the value of existing mainframe investments延伸既有的主機投資價值
Integrate existing mainframe assets into current business initiativesReduce need to rip and replaceEliminate costs of redundant copies of data
Fits seamlessly into your existing IT infrastructure out-of-the-box直接融入既有的IT架構
Mainframe: Security, Accounting, System ManagementTools: Business intelligence, Analytics, PortalsApplication: development environments, application servers, 3GLs
Accelerate time-to-value of enterprise integration projects快速體現企業整合專案的價值
Metadata-driven for easy configuration and maintenanceTransactional speed and enterprise scaleNo mainframe programming required
2008/3/28
IBM Confidential 26
IBM Software Group
51
Wrap-up –Value to IT Organization對IT部門的價值
Consistent SQL interface … Instant integration提供一致的SQL介面. . .快速整合
Connects mainframe data with any eBusiness platformInsulates application from proprietary back-end dataNon-intrusive – NO impact on mainframe transactions
Powerful data access … non-relational & RDBMS強大的資料存取功能. . .非關聯式及RDBMS
Direct SELECT-INSERT-UPDATE-DELETE Distributed join, data normalization, view-driven filteringScales for demanding workloads
Ease-of-Use容易使用
Sets up in hours, not daysNo mainframe programmingAutomated meta data configuration
IBM Software Group
52
Thank You!