session soa-12 solving openedge™ integration scenarios with sonic esb® bob trabucchi senior...

Session SOA-12Solving OpenEdge™ Integration Scenarios With Sonic ESB®

Bob TrabucchiSenior Systems Engineer

2 SOA-12: Solving OpenEdge Integration Scenarios With

Sonic ESB © 2005 Progress Software Corporation

Purpose of This Presentation

Problem: too much too fast!– And we often leave you to figure out how

to handle it. Solution: Provide more palatable samples

of our technology– Outline recognized OpenEdge integration

problem

– Show directly how Sonic ESB solves it



Why Does Integration Seem So Hard?

Those who initially ventured out got clobbered!

Integration projects average 20+ months to complete

Fewer than 35% of projects finish on time and on budget

35% of software maintenance budgetis spent maintaining point-to-point application links

Statistics from Forrester Research “Reducing Integration Costs”



What Went Wrong?

Many technologists were forced to use integration technologies available at the time.– Developed for client/server world– Don’t scale beyond the enterprise– Require lots of coding and specialized

processes/ kludges.– Proprietary– Result in single-use solutions



OpenEdge Integration Scenarios

File Transfer Systems Pre-packed applications eCommerce Conclusions



Application Integration Models

Sales Warehouse2

Application Integration Model– Real-time integration– Low message latency – 24 X 7 availability– RPC, MOM, JMS

Invoice Application

Invoice Application

Fulfillment Application Fulfillment

Application

Database Database1

Data Integration Model– No application changes– DB’s of different formats

Two typical approaches



Data Integration Model

Term used to describe a group of homegrown integration solutions that implement a Data Specific Model.

Use combinations of: – multi- step copies– merge of database/file data– FTP– Batch processing– Complex maze of scripts, applications, and

manual processes.

File transfer systems



File Transfer System ExampleFlat file copy

Sales

Order Application

Order Application

Database Database

FTP/Batch

Flat File


Application

Flat File

Warehouse



Warehouse


Application

Database

File Transfer System ExampleDatabase copy

Sales

Order Application

Order Application

Database

Transform

Extract FTP/Batch Load FTP/Batch



File Transfer Systems

Message Latency Information is delivered hours to weeks late

Reliability Other applications,networks,copy problems

Downtime Databases must be frozen for copies

Synchronization Everyone goes “live” together

Technical pains




Revenue generating applications offline Incredible overhead

24 hour IT staff High cost of extra hardware, software

– Networks, databases, maintenance

Problems that systems encounter using stale data

Lost revenue Poor customer service

Business pains



File Transfer SystemsBusiness pains

Finance

Credit Application

Credit Application

Database

Sales

Order Application

Order Application

Database

Inventory

Warehouse Application Warehouse

Application

Database

Overnight Overnight



File Transfer SystemsBusiness pains

Sales

Order Application

Order Application

Database

Finance

Credit Application

Credit Application

Database

Inventory

Warehouse Application Warehouse

Application

Database

Day 1 Day 2

400 units

Order 500 unitsCustomer A: Approve 500 units Denied: Out-of-stock



But it doesn’t have to be this

way!



Introducing Sonic ESB

Standards-based intelligent middleware platform designed to facilitate integration – Contains:

Messaging – 100% reliable, scalable & secure communication delivery system.

Framework – to build/deploy standalone and reusable integration logic modules

Connectivity components – Wide variety of integration endpoints– Service-Oriented architectures of tomorrow

Intelligent middleware implemented



Warehouse


Application

Database

Sonic ESB solutionReliable, real-time, & reusable

Sales

Order Application

Order Application

Database

Sonic ESBSonic ESB

TransformExtract Load

Out-of-box Service




Sonic ESB’s real-time data integration means:– Revenue generating apps are constantly running =

increased revenue

– Elimination of 2nd and 3rd shift IT resources = lower costs

– Elimination of hardware and software = lower costs Resulting solution is reusable

The Sonic ESB solution




File Transfer Systems Pre-packaged Integrations eCommerce Integrations Conclusions



Application Integration Models

Sales Warehouse2

Application Specific Model– Real-time integration– Low message latency – 24 X 7 availability– RPC, MOM, JMS

OE Application

OE Application

SAP ERP Application

SAP ERP Application

Database Database1

Data Specific Model– No application changes– DB’s of different formats

Two typical approaches



Real-time Pre-packaged Integrations

Business needs require OpenEdge application to talk with entrenched pre-packed applications.

Traditional solutions use combinations of: – Synchronous exchange – assume 100% up-time

– Complex and hard-coded data conversions

– Expertise in 3rd-party applications

– Solution hard-coded into OpenEdge application

Background



Warehouse

SAP Application

SAP Application

Database

Real-time Pre-packaged IntegrationsBackground

Sales

OE Application OE Application

Database

Transform

Transport

SAP API

RPC

Solution is hard-coded into the application



Warehouse

OE Application

OE Application

Database

Real-time Pre-packaged IntegrationsBackground

Sales SAP

Application SAP

Application

Database

Transform

TransportOE API

Somebody has to take the hit!




Reliability Synchronous transfer assumes 100% up-time

Complexity Limited expertise with prepackaged app

means costly experts or lengthy training Mountains of code to write/maintain

Synchronization Slightest change means redeploying

Technical pains




Problems that systems encounter when a component goes down

Lost revenue Poor customer service

Business needs dictate quickly delivered and reliable integration solution just to survive!

Managers want solution now, not in 6 months when it is too late

Business pains




way!



Sonic ESB Alternative

Adapter-based solution Pre-built adapters map proprietary APIs to

standards (XML) Solution built on Standards-based

messaging Insulates applications from downtime Scalable and flexible

All participants are blissfully unaware Integration modules exist outside the

business critical applications

A better way



Sonic ESBSonic ESB

Sonic ESB Adapter-based SolutionReliability and interoperability solved

Warehouse

SAP Application

SAP Application

Database

Sales

OE Application

OE Application

Database

1 2 3

Component Breakdown:

OpenEdge Sonic Adapter

Transformation Service (resolve mismatches)

SAP Adapter for Sonic ESB

1

2

3



Real-time Prepackaged Applications

Sonic ESB’s real-time application integration means:– Revenue generating apps are constantly running =

increased revenue

– Solution is built using out-of-box components = lower costs

Resulting solution is reusable– Prepackaged applications now

– HTTP, Java, C#/.Net, Web Services next





File Transfer Systems Pre-packed applications eCommerce applications Conclusions



Real-time eCommerce Integration

Business needs require OpenEdge application share data over the Internet

Traditional solutions use combinations of: – Synchronous exchange – assume 100% up-

time– Complex, hard-coded, non-standard

transforms– Expertise in HTTP(S)– Security expertise

Background



Warehouse

Java Application

Java Application

Database

Internet Internet Internet Internet

Real-time eCommerce IntegrationBackground

Head Office

OE Application OE Application

Database

Each codes Security, Transform, and Transport Logic

HTTP(S)



Real-time eCommerce Integration

Reliability Synchronous transfer assumes 100% up-

time Complexity

Mountains of code to write/maintain Synchronization

Slightest change means redeploying Security

Security is your domain

Technical pains




way!



Sonic ESB Alternative

Solution built on standards-based messaging with native HTTP(S) support

Insulates applications from downtime Scalable, flexible, built-in security

All participants are unaware of each other Integration modules exist outside the

business critical applications and are built using reusable components.

A better way



Sonic ESBSonic ESB

Sonic ESB eCommerce SolutionSecure, resilient, and reusable!

Sales

OE Application

OE Application

Database

1 2

Component Breakdown:

OpenEdge Sonic Adapter

Transformation Service (resolve mismatches)

1

2

Trading Partner


Application

Database

HTTP(s)



Real-time eCommerce

Sonic ESB’s real-time eCommerce application integration means:– OpenEdge applications are shielded from failures =

higher revenue Result: Reusable Solution

– HTTP(s) Now

– Same solution for pre-packaged applications, FTP, Java applications, etc.





File Transfer Systems Pre-packed applications eCommerce applications Conclusions



In Summary

Avoid costly mistakes

Build the smarter solution first!

Get on the Bus!



Where To Go From Here?

SOA-03 – Open Up Access to your 4GL Applications Using Web Services

SOA-05 – Building an Enterprise SOA Using ESB

SOA-06 – Get on the Bus with the OpenEdge Adapter for Sonic ESB

SOA-09 – Conducting Business with OpenEdge and Sonic

Get some specifics!



Questions?



Thank you for your time!

session soa-12 solving openedge™ integration scenarios with sonic esb® bob trabucchi senior...

Documents

integration costs

software maintenance

integration projects

use combinations

live togethertechnical

manual processes

specialized processes

incredible overhead24