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

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

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

Order Application

Database Database

FTP/Batch

Flat File

Application

Flat File

Warehouse

Application

Database

File Transfer System ExampleDatabase copy

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

Database

Order Application

Database

Inventory

Warehouse Application Warehouse

Application

Database

Overnight Overnight

File Transfer SystemsBusiness pains

Order Application

Database

Finance

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

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

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

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

Database

Real-time Pre-packaged IntegrationsBackground

OE Application OE Application

Database

Transform

Transport

SAP API

Solution is hard-coded into the application

Warehouse

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

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

Database

OE Application

Database

Component Breakdown:

OpenEdge Sonic Adapter

Transformation Service (resolve mismatches)

SAP Adapter for Sonic ESB

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

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

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!

OE Application

Database

Component Breakdown:

OpenEdge Sonic Adapter

Transformation Service (resolve mismatches)

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...

integration costs

software maintenance

integration projects

use combinations

live togethertechnical

manual processes

specialized processes

incredible overhead24

Documents

openedge mobile an introduction shelley chase progress...

1 what’s new in openedge 10.2b openedge management...

openedge management

openedge developers corner

openedge 11

openedge manual

openedge™ john sadd progress fellow and openedge...

soa-06: get on the bus with the openedge ® adapter for...

integrating the progress rollbase portal into openedge...

move-12: openedge®, adobe flex, and openedge...

esb or not to esb

openedge ecosystem.… · 2019-10-08 · openedge ecosystem...

openedge getting started: progress openedge studio · pdf...

openedge 10 platform & product availability...

move-3: openedge®, sonic esb®, and soa: qad's service...

openedge ® architect

dev-29: a deep dive into the advanced gui openedge ® 10.2a...

progress openedge 11.6.4 upgrade guide...progress openedge...

openedge 10 platform & product availability...

openedge 11 platform & product availability...