the enterprise component architects 4 september 2015 sterling software cool products: a better way...

30
The Enterprise Component Architects March 27, 2022 Sterling Software COOL Products: A Better Way to Get Things Done Extending the Extending the Reach of DB2: Reach of DB2: Web Integration Web Integration and and Data Warehouse Data Warehouse Marc Wellman Senior Product Specialist Sterling Software

Upload: arabella-montgomery

Post on 26-Dec-2015

215 views

Category:

Documents


2 download

TRANSCRIPT

The Enterprise Component ArchitectsApril 19, 2023

Sterling Software COOL Products: A Better Way to Get Things Done

Extending the Reach of Extending the Reach of DB2: DB2:

Web Integration and Web Integration and Data WarehouseData Warehouse

Marc WellmanSenior Product Specialist

Sterling Software

The Enterprise Component ArchitectsApril 19, 2023

Sterling Software COOL Products: A Better Way to Get Things Done

Two Technologies Two Technologies for Enabling for Enabling

Access to your Access to your Corporate Corporate

Processes and Processes and DatabasesDatabases

Sterling Software COOL Products: A Better Way to Get Things Done

Web-Enabling your Business

With the possible exception of the Year 2000 With the possible exception of the Year 2000 snafu, Web/legacy integration may be the snafu, Web/legacy integration may be the biggest challenge of the next few years….biggest challenge of the next few years….

New York based market-research company, New York based market-research company, Datamonitor, predicts the Web/legacy market Datamonitor, predicts the Web/legacy market will skyrocket to $14 billion in the next four will skyrocket to $14 billion in the next four years.years.

Sterling Software COOL Products: A Better Way to Get Things Done

DB2DB2OperationalOperationalDatabasesDatabases

COBOLCOBOLIMSIMS

CICSCICSJCLJCL

ModelingModelingandand

Development Development ToolsTools

Legacy Systems Modernization

Ser

ver-

Cen

tric

Dev

elop

men

t Pro

cess

LAN

Internet/Intranet

thinclients

serverapplications(e.g. legacy)

enterprise application

servers

Sterling Software COOL Products: A Better Way to Get Things Done

LAN

Internet/Intranet

clients

web serverand

applicationproxy

externalservices

distributedservices

Distributed Architectures

• Optimize processing for platform:Optimize processing for platform:– Presentation on ClientPresentation on Client

– Business Logic/Data Access combined on Business Logic/Data Access combined on two-tiered systemtwo-tiered system

– Business Logic/Data Access separated on Business Logic/Data Access separated on three-tiered systemthree-tiered system

• Application server accommodates large Application server accommodates large number of clients (high scalability)number of clients (high scalability)

• Database integrity and transaction Database integrity and transaction integrity accomplished by back-end integrity accomplished by back-end serversservers

• Higher performance due to load Higher performance due to load balancing and configurabilitybalancing and configurability

• Separate middleware often usedSeparate middleware often used

Sterling Software COOL Products: A Better Way to Get Things Done

Connecting Web Applications to Enterprise Databases and Transactions

• Enterprise DBMSs are typically Enterprise DBMSs are typically surrounded by transactionssurrounded by transactions

• Transactions are secured from Transactions are secured from unauthorized users, and control unauthorized users, and control commit/save processcommit/save process

• Transaction Monitors/Processors Transaction Monitors/Processors schedule resources involved in schedule resources involved in business processingbusiness processing

Sterling Software COOL Products: A Better Way to Get Things Done

Choices for Data Publication

• Extracts/Loads from production Extracts/Loads from production databasesdatabases– Requires separate extract/load services (often Requires separate extract/load services (often

batch services)batch services)– Data currency depends on extract/load periodData currency depends on extract/load period

• Opening up production dataOpening up production data– Requires careful security planning and accessRequires careful security planning and access– Multiple tiers supports authenticationMultiple tiers supports authentication– Determine static versus truly dynamic dataDetermine static versus truly dynamic data

Sterling Software COOL Products: A Better Way to Get Things Done

Web Changes Criteria for Provisioning New and Existing Business Systems

• Exponential Exponential scalabilityscalability required to support an required to support an unpredictable client populationunpredictable client population

• Continuous Continuous availabilityavailability to support consumer to support consumer computing hours (24x7)computing hours (24x7)

• DecoupledDecoupled business process execution due to business process execution due to the “stateless nature” of the webthe “stateless nature” of the web

• SecuritySecurity demands rise tremendously when demands rise tremendously when exposing business process to unknown usersexposing business process to unknown users

• Time to Market demands Time to Market demands rapidrapid deployment deployment

Sterling Software COOL Products: A Better Way to Get Things Done

• Transition from fat client (RDA) to server-centric computing

• Reduce contention for database and server resources

• Eliminate coding business logic in different client technology (e.g. Java, C++, VB)

• Ensures consistent execution of agreed to business rules

Thin Client Delivery RequiresServer-Centric Computing

LAN

Internet/Intranet

Clients

BusinessApplication

Servers

WebServers

Sterling Software COOL Products: A Better Way to Get Things Done

Extend the Business Integrity through Advanced Proxy Technology

• Partitioned design preserves Partitioned design preserves business transactionsbusiness transactions

• Extending the transaction via Extending the transaction via proxy technology ensures proxy technology ensures integrity and securityintegrity and security

• Middle-tier supports Middle-tier supports tremendous scalability and tremendous scalability and reliabilityreliability

• Enables evolution towards Enables evolution towards component based computing component based computing via standard interfaces and via standard interfaces and consumptionconsumption

LAN

Internet/Intranet

clients

businessapplication

servers

web serverand

applicationproxy

Sterling Software COOL Products: A Better Way to Get Things Done

Legacy Data Access

• Data CaptureData Capture– Model relational dataModel relational data– Other data (source Other data (source

code)code)

• Data AccessData Access– Direct accessDirect access– Indirect accessIndirect access

(non-relational data)(non-relational data)

• Data integrityData integrity

NewTran

ExistingLegacy Data

(non-relational)

Relational Data

Connector

API/Stored Procedure

GUI Client Web Client

Direct Access

Sterling Software COOL Products: A Better Way to Get Things Done

Legacy Transaction Integration

• MVS SystemsMVS Systems– CICS/DB2CICS/DB2– IMS DB/DCIMS DB/DC– VSAM VSAM

• Unix SystemsUnix Systems– HPHP– SUNSUN– AIXAIX New

BusinessTransaction

ExistingLegacy

TransactionConnector

ClientPlatform

GUI Client Web Client

Sterling Software COOL Products: A Better Way to Get Things Done

ERP/HR Business-Level Integration

• Need to extend or blend Need to extend or blend functionality of large functionality of large package with your businesspackage with your business

• Need to leverage server skill Need to leverage server skill setssets

• Need to deliver consistent Need to deliver consistent client approachclient approach

NewBusinessProcess

ClientPlatform

GUI Client Web Client

Connector

Sterling Software COOL Products: A Better Way to Get Things Done

• All servers developedAll servers developed using a single, using a single, consistent processconsistent process

• Leverage "business Leverage "business knowledge" at the serverknowledge" at the server

• Rapid development of Rapid development of servers using templates servers using templates and patternsand patterns

• Connect to servers Connect to servers through generated COM through generated COM or Java proxiesor Java proxies

Serv

er

Develo

pm

en

t

Web

Devel

opm

ent

GUI

Dev

elop

men

t

Java

Dev

elop

men

t

The Server-Centric Development Process

Sterling Software COOL Products: A Better Way to Get Things Done

Serv

er

Develo

pm

en

t

The COOL:Gen Server Development Process

Diagrams to CodeDiagrams to Code• Data ModelingData Modeling

(capture persistent data)(capture persistent data)

• Logic DiagrammingLogic Diagramming(develop business logic)(develop business logic)

• Packaging and GeneratingPackaging and Generating

Sterling Software COOL Products: A Better Way to Get Things Done

What is COOL:Gen?What is COOL:Gen?A set of integrated, model-based development tools enabling customers to develop and integrate mission-critical enterprise applications rapidly, reliably, and with quality. Model Based

Sales_Order: Add_Order - Action Diagram X

Diagram Edit Detail View Options Window Help

ADD_CUSTOMER_ORDER

IMPORTS: . . .

EXPORTS: . . .

READ customer

WHERE DESIRED customer number ISEQUAL TO imports customer number

ENTITY ACTIONS: . . .

WHEN successful

MOVE customer TO export customer

Sales_Order: Sales_Order - Data Model X

Places

Diagram Edit Detail View Options Window Help

Customer

NumberNameAddress_Line_1Address_line_2

Order

NumberNameValue

Delete_OrderAdd_Order

Sales_Order: Navigation Diagram X

Diagram Edit Detail View Options Window Help

Customer ListSort SelectionCustomer Details

Customer ListList Box: ALL_OUTPUTEntry Field: ZIP_CODE

InterfaceData

Business Logic

Components

Code Generation &Deployment Packaging

Sterling Software COOL Products: A Better Way to Get Things Done

Develop and Maintain at Specification Level

• Easy-to-Read graphicsEasy-to-Read graphics• Self-documenting structure Self-documenting structure

leverages maintenance resourcesleverages maintenance resources

• Business rule focus: quickly adapt Business rule focus: quickly adapt

to business changeto business change

• Easy to maintainEasy to maintain• Built-in consistency checksBuilt-in consistency checks

– speeds testing speeds testing – higher application qualityhigher application quality

Sales_Order: Add_Order - Action Diagram X

Diagram Edit Detail View Options Window Help

ADD_CUSTOMER_ORDER

IMPORTS: . . .

EXPORTS: . . .

READ customer

WHERE DESIRED customer number ISEQUAL TO imports customer number

ENTITY ACTIONS: . . .

WHEN successful

MOVE customer TO export customer

Sales_Order: Sales_Order - Data Model X

Places

Diagram Edit Detail View Options Window Help

Customer

NumberNameAddress_Line_1Address_line_2

Order

NumberNameValue

Delete_OrderAdd_Order

Sales_Order: Navigation Diagram X

Diagram Edit Detail View Options Window Help

Customer ListSort SelectionCustomer Details

Customer ListList Box: ALL_OUTPUTEntry Field: ZIP_CODE

Sterling Software COOL Products: A Better Way to Get Things Done

Application Deployment Architecture

Centralized Mainframes

Departmental servers

Distributed Components

3270,VT100

COOL:GenGUI Client

Desktop applications(VB, PB, Access, Excel,etc…)

WebInternet

Middleware

Java/Com Proxy

COM Proxy

Sterling Software COOL Products: A Better Way to Get Things Done

COOL:Gen Deployment Platforms

NTWin95

Win3.11OS/2

Mainframe Servers

MVS CIC

S

MVS IMS

Servers

HP 9000

RS/6000

Sun

Sequent

NCR

Digita

l Unix

Digita

l Open V

MS

NT

NT Alp

ha

Tandem

OS/2

GUI Clie

nts

Proxy

Internet

ActiveX

Java

C

Servers

Sterling Software COOL Products: A Better Way to Get Things Done

Definition: Definition:

A proxy is a local representation of an object that is located on a A proxy is a local representation of an object that is located on a remote machine. The proxy represents the object’s interface to remote machine. The proxy represents the object’s interface to other objects other objects on the local machine, appearing to them as a local on the local machine, appearing to them as a local

object. object.

As it pertains to Distributed Objects, a proxy is the most common As it pertains to Distributed Objects, a proxy is the most common mechanism for achieving the result of Remote Transparency. mechanism for achieving the result of Remote Transparency.

David TaylorDavid Taylor

Object Technology: A Manager’s GuideObject Technology: A Manager’s Guide

What is a Proxy?

Sterling Software COOL Products: A Better Way to Get Things Done

Proxy Technology from Sterling Software

• Proxies are the mechanism for extending Proxies are the mechanism for extending your existing business processes and data your existing business processes and data to distributed architectures using widely to distributed architectures using widely accepted technologiesaccepted technologies– Implementation technology: COM, Java, or CImplementation technology: COM, Java, or C– Communications technology: Messaging or Communications technology: Messaging or

TCP/IPTCP/IP– Architecture technology: 3-,4-, N-tiered computingArchitecture technology: 3-,4-, N-tiered computing

Sterling Software COOL Products: A Better Way to Get Things Done

Java Makes Business Sense

• PortabilityPortability• Lightweight, Web-friendly, “open”, reusableLightweight, Web-friendly, “open”, reusable• Built-in support for network protocolsBuilt-in support for network protocols• Meteoric rise of the Corporate Intranet/ExtranetMeteoric rise of the Corporate Intranet/Extranet• Beans provide development of reusable controlsBeans provide development of reusable controls• EJB provides platform for component based EJB provides platform for component based

computingcomputing• Primary alternative to Microsoft approachPrimary alternative to Microsoft approach

Sterling Software COOL Products: A Better Way to Get Things Done

Web Application using JAVA Proxy

Web Client

CustomJava Bean

GeneratedJava Bean

Web Server

Java Servlet

Proxy

http

UNIXServer

MVSServer

NTServer

Server Environment

TCP/IP

Sterling Software COOL Products: A Better Way to Get Things Done

- GeneratedHTTP

IIS, Netscape, Apache Web Server

JavaServlet

JNI/ C++

ODC

HTTP

Browser: Java VM 1.1

Custom Java Applet

Java I/F(Bean/class)

OS: NT or W95 (or where compatible browser runs)

Html page

OS: NT, HPUX, Solaris

JAR file

AppletJava I/F(Bean/class)

HTML /applet

COOL:Gen Servers on: MVS OS/2 UNIX VMS NT

COOL:Gen Java Proxy

Java Proxy Runtime Architecture

Generated

COOL:Gen Java Proxy

Sterling Software COOL Products: A Better Way to Get Things Done

COM is the choice for Microsoft Architectures

• Well understood as a programming Well understood as a programming technologytechnology

• Wide choice of COM compliant technologyWide choice of COM compliant technology• Built-in support for networked objects Built-in support for networked objects • Easily consumed via Windows and NT Easily consumed via Windows and NT

platformsplatforms

Sterling Software COOL Products: A Better Way to Get Things Done

Web Application using COM Proxy

Web Client MS IIS Web Server

Active ServerPage (ASP)

COMProxy

http(s) UNIXServer

MVSServer

NTServer

Server Environment

TCP/IP

Sterling Software COOL Products: A Better Way to Get Things Done

COOL:Gen COM Proxy

HTTPMS IIS Web Server

COM C++

Comm

Browser: (Most Any HTML browser)

Client OS: Where ever the browser runs

Html page

ASP ActiveXI/F (class)

OS: NT

ActiveX via Internet

ActiveX via Desktop

Client OS: NT or W95

Appl.: (VB or Other ActiveX controllers)

ActiveXI/F (class)

COM C++

Comm

TCP/IP*

TCP/IP*

COOL:Gen Servers on: MVS OS/2 UNIX VMS NT

ActiveX/COM Proxy Runtime Architecture

- GeneratedGenerated

Sterling Software COOL Products: A Better Way to Get Things Done

COOL:Gen - Quick Reaction to Business Change

Code Generation• Client logic• Server logic• COM and Java proxy interfaces• TP middleware• Communication middleware• Communication Protocol• Windows GUI• Database access• Referential Integrity

Sterling Software COOL Products: A Better Way to Get Things Done

Technology Leveling

• Reduce the skillsets needed to target:Reduce the skillsets needed to target:

– multiple application architecturesmultiple application architectures

– multiple hardware environmentsmultiple hardware environments

– multiple operating systemsmultiple operating systems

– multiple databasesmultiple databases

– multiple network environmentsmultiple network environments

– multiple middleware productsmultiple middleware products

The Enterprise Component ArchitectsApril 19, 2023

Sterling Software COOL Products: A Better Way to Get Things Done

Data Modeling Data Modeling and Design Tools and Design Tools

for the Data for the Data WarehouseWarehouse