SOA-3: You Need to Integrate, But What
do You Need to Know and Do?
Sandy Caiado
Bob Trabucchi
Sr Presales Consultant
Sr Presales Consultant
Agenda
 Current OpenEdge® Integration Options
 Sonic ESB® Integration Demo
 Summary
SOA-3: What you need to know to integrate
2
© 2006 Progress Software Corporation
OpenEdge Integration Technology Choices



Data-level integration
1
• File Transfer Systems
(batch/FTP/ETL/file drops)
• OpenEdge replication
• OpenEdge data server
Application-level integration
(real-time)
HQ
Store
2
1
2
• Sockets
• SonicMQ®
Both integration types
• Sonic ESB
SOA-3: What you need to know to integrate
3
© 2006 Progress Software Corporation
Data Specific Integration Model
1
 Integration through shared data
– Homegrown data-transfer systems
 e.g. FTP, Batch, DB Merge, scripts
– Extract, Transform, Load (ETL) products
– Replication solutions/products
Order
Entry
Application
Progress
DB
SOA-3: What you need to know to integrate
Designed for
Overnight Processing
Inventory
Application
Copy/Batch
Processing
Logic
Oracle
DB
4
© 2006 Progress Software Corporation
Application Specific Model
2
 Integration through real-time data exchange
– Homegrown real-time systems
 e.g. 4GL sockets
Order
Entry
App
Integration
Logic
Comm
Logic
Sockets
Comm
Logic
Integration
Logic
Inventory
App
Progress
Oracle
DB
DB
SOA-3: What you need to know to integrate
5
© 2006 Progress Software Corporation
Application Specific Model
2
 Integration through real-time data exchange
– Homegrown real-time systems
 e.g. 4GL sockets
Order
Entry
App
Integration
Integration
Logic
Logic
Comm
Comm
Logic
Logic
Sockets
Comm
Comm Integration
Logic
Integration
Logic Logic
Logic
Oracle
MSSQL
DB
DB
Progress
DB
SOA-3: What you need to know to integrate
New
Inventory
Inventory
App
App
6
© 2006 Progress Software Corporation
Application Specific Model

2
Integration through real-time data exchange
– Message Oriented Middleware (MOM)
 e.g. SonicMQ
MOM Product
Order
Entry
App
Integration
Logic
Comm
Platform
Integration
Logic
Inventory
App
Progress
Oracle
DB
DB
SOA-3: What you need to know to integrate
7
© 2006 Progress Software Corporation
ESB Integration Model
2
A pre-built Sonic ESB integration




Flexible enough to implement all models
Customer proven to eliminate risk
Comes with 90% of the integration architecture – done
Pre-built deployment and management infrastructure
Order
Entry
Application
Progress
DB
SOA-3: What you need to know to integrate
Comm
Platform
Inventory
Application
Real-time
& Data
Integration
Product
Oracle
DB
8
© 2006 Progress Software Corporation
Why is Sonic ESB a better choice?
 An OpenEdge/Sonic ESB integration
features:
• Real-time integration that works all the time
– Just like you never touched the application!
• One-time and standardized ABL coding gets
you started
• Reused for all future integrations.
• New integrations added incrementally without:
– Redeploying applications
– Bringing the systems down
SOA-3: What you need to know to integrate
9
© 2006 Progress Software Corporation
Agenda
 Current OpenEdge® Integration Options
 Sonic ESB® Integration Demo
 Summary
SOA-3: What you need to know to integrate
10 © 2006 Progress Software Corporation
Demo: What’s installed and running!
 OpenEdge 10.1A

• OpenEdge Adapter for SonicMQ
Sonic Integration Workbench
• Sonic ESB
– Transformation Services and management
• SonicMQ
– Messaging Broker
• Stylus Studio
– XML Development
SOA-3: What you need to know to integrate
11 © 2006 Progress Software Corporation
Demo Scenario
 Company
• All Sports Distribution
 Business
• Sporting goods wholesaler
 Integration Goals
• Publish price changes to local retailers in realtime
• Guarantee delivery of the data
• Wants to reuse the same solution for others
SOA-3: What you need to know to integrate
12 © 2006 Progress Software Corporation
Demo Scenario
 Interested parties that will be notified in a
phased approach.
•
•
•
•
Phase 1: Send to Sandy’ Scuba Shop
Phase 2: Send to Bob’s Boating and Fishing
Phase 3: Send to Divots Golf
Phase 4: Send to Caesar’s Sports
 Purchase decision
 Caesar’s sends purchase order to All Sports
SOA-3: What you need to know to integrate
13 © 2006 Progress Software Corporation
Phase 1: Integrate with Sandy’s Scuba
 Problem
• Price change info generated by the OpenEdge
10.1 price change application needs to get to
Sandy’s Scuba Store in real-time.
 Solution
• Add real-time integration channel
• Sandy’s Scuba only wants price change info
that is meaningful to them.
SOA-3: What you need to know to integrate
14 © 2006 Progress Software Corporation
Phase 1
All Sports
Dist HQ
OpenEdge
Inventory
Application
Sonic ESB
T: MyPartners
Transform
T: DivingTopic
XML
Sandy’s Scuba
Shop
Java
Application
SOA-3: What you need to know to integrate
15 © 2006 Progress Software Corporation
Phase 1: Demo
SOA-3: What you need to know to integrate
16 © 2006 Progress Software Corporation
Anatomy of an ESB Service
OpenEdge
Pricing
Application
Entry
Endpoint
Service
T: MyPartners
Exit
Endpoint
Java
Application
Sandy’s
Scuba
T:DivingTopic
Input
divingcat.xsl
SOA-3: What you need to know to integrate
17 © 2006 Progress Software Corporation
Phase 1: Review
 Real-time integration accomplished!
• Trivial coding effort – got us on the ESB
• Master XML document
– Transformed for Sandy’s Scuba using ESB
• Same system used for this and all future
integrations…
RUN createTempTableMessage IN hptpsession (OUTPUT hMessage).
RUN setTempTable IN hMessage(httItem , ?, TRUE).
RUN PUBLISH IN hptpsession ("MyPartners", hMessage, ?, ?, ?).
SOA-3: What you need to know to integrate
18 © 2006 Progress Software Corporation
Phase 2: Integrate with Bob’s B&F
 Expand All Sports Dist. integration
architecture to support Bob’s Boating and
Fishing application.
– Progress application wants end-to-end
reliability
 ESB does transport and transformation
– Configure new service to transform
 Because of forward planning:
• No code changes to the price change app
SOA-3: What you need to know to integrate
19 © 2006 Progress Software Corporation
Phase 2
Bob’s Boating and
Fishing
All Sports Dist.
OpenEdge
Inventory
Application
HQ
Temp-table
OpenEdge
Application
Temp-table
Sonic ESB
T: FishingBoatingTopic
Transform
Transform
T: MyPartners
T: DivingTopic
XML
Sandy’s Scuba
Shop
Java
Application
SOA-3: What you need to know to integrate
20 © 2006 Progress Software Corporation
Phase 2: Demo
SOA-3: What you need to know to integrate
21 © 2006 Progress Software Corporation
Phase 2: Review
 Real-time integration with Bob’s B&F
accomplished!
• New application gets the bus!
– Minor code changes
• Deliver targeted data
– Deploy ESB out-of-box transformation
• Same system used for both integrations
– No changes to All Sports Distr. application
RUN subscribe in hptpsession ("FishingBoatingTopic", ?, ?, no,
consumerH) no-error.
RUN startReceiveMessages IN hptpsession.
SOA-3: What you need to know to integrate
22 © 2006 Progress Software Corporation
Phase 3: Integrate with Divot’s Golf
 Problem
• Expand the integration to support All Sports
new partner Divot’s Golf
• Divot’s dictates XML format
• Wants NO Sonic components
 Solution
• Add another real-time integration channel to
All Sports distribution center
• Support Divot’s existing specific XML format
SOA-3: What you need to know to integrate
23 © 2006 Progress Software Corporation
Phase 3
Bob’s Boating and
Fishing
OpenEdge
Application
All Sports
Dist.
HQ
OpenEdge
Inventory
Application
Temp-table
Temp-table
Sonic ESB
T: FishingBoatingTopic
Transform
Transform
T: MyPartners
T: DivingTopic
Transform
Transform
Divot’s
Golf
XML
Q: GolfCategory
T: DivotFormatTopic
XML
Sandy’s Scuba
Shop
HTTP
Application
Java
Application
SOA-3: What you need to know to integrate
24 © 2006 Progress Software Corporation
Phase 3: Demo
SOA-3: What you need to know to integrate
25 © 2006 Progress Software Corporation
Phase 3: Review
 Real-time integration with All Sports
distribution service accomplished!
• Reused HTTP application to get on the bus!
– No Sonic client code required
• Supported their own XML format
– Deploy ESB out-of-box transformation
• ESB does transport and duel transformation
• Re-used All Sports Dist. architecture for the
integration
– No changes to All Sports Dist. Application
SOA-3: What you need to know to integrate
26 © 2006 Progress Software Corporation
Phase 4: Caesar’s Sports Purchasing Process
 Caesar’s Sports integrated purchasing

decision
Process
• Receive temp-table from All Sports Dist.
(because Caesar’s has an OpenEdge App.)
• Order item ONLY if price point is lower
SOA-3: What you need to know to integrate
27 © 2006 Progress Software Corporation
Phase 4
OpenEdge
Inventory
Application
XML
Temp-table
All Sports
Dist.
HQ
Sonic ESB
T: MyPartners
Caesar’s Sports
OpenEdge
Application
SOA-3: What you need to know to integrate
T: PurchaseTopic
Temp-table
28 © 2006 Progress Software Corporation
Phase 4: Demo
SOA-3: What you need to know to integrate
29 © 2006 Progress Software Corporation
Phase 4: Review
 Real-time integration with All Sports

distribution service accomplished again!
Automate purchase process
• Minor code changes to receive data
• New process to send data
 Re-used All Sports Dist. architecture for the
integration
– No changes to All Sports Dist. Application
SOA-3: What you need to know to integrate
30 © 2006 Progress Software Corporation
All Sports Integration Approach Review
 Implemented a flexible integration approach
• Minor application changes to get data on the
bus performed once
• Transformation Services created for partners
– Data specific to their market
– Data specific to their format
 SonicMQ Communication layer
• Secure, guaranteed delivery of the data
SOA-3: What you need to know to integrate
31 © 2006 Progress Software Corporation
All Sports integration futures/options
 Using their integration platform, All Sports
now has the ability to add connectivity to
hundreds of other applications like:
• Pre-packaged applications
– SAP, Oracle, Siebel
• Technologies
– Web services (HTTP/SOAP)
– FTP, Email
– .Net Applications
SOA-3: What you need to know to integrate
32 © 2006 Progress Software Corporation
Agenda
 Current OpenEdge® Integration Options
 Sonic ESB® Integration Demo
 Summary
SOA-3: What you need to know to integrate
33 © 2006 Progress Software Corporation
Summary
What have you seen today?
 An OpenEdge/Sonic ESB integration
features:
• Real-time integration that works all the time
• Standardized ABL coding gets you started
• Same product is reused for all future
integrations.
• New integrations added incrementally without:
– Redeploying applications
– Bringing the systems down
SOA-3: What you need to know to integrate
34 © 2006 Progress Software Corporation
Keys to Success
 Collaborative approach
• Products – OpenEdge, Sonic ESB
• Training – Unfamiliar products, and
methodologies
• Mentoring – Integration problems are hard to
solve
SOA-3: What you need to know to integrate
35 © 2006 Progress Software Corporation
Call to Action
 Contact your account manager
 Education
 Check out whitepapers on PSDN
 Talk to others here about their experiences
 Attend the Product Expo
• Tonight 4:30 – 7:00
• Tomorrow 11:30 – 2:00
 Attend other integration sessions
SOA-3: What you need to know to integrate
36 © 2006 Progress Software Corporation
Where To Go From Here?
Get some specifics!






MOV-7 – Sonic Success Stories, Tues 9:15
SOA-06 – Standards for SOA, Tues 10:30
SOA-07 – Sonic ESB for OE Developers, Tues 2:15
SOA-09 – Implementing SOA in Financial Services,
Banco Comafi a Real Lending Case, Tues 4:45
SOA-11 – Design Best Practice, Wed 1:15
SOA-14 – Deploying your SOA App, Wed 3:40
SOA-3: What you need to know to integrate
37 © 2006 Progress Software Corporation
Questions?
SOA-3: What you need to know to integrate
38 © 2006 Progress Software Corporation
Thank you for
your time
SOA-3: What you need to know to integrate
39 © 2006 Progress Software Corporation
SOA-3: What you need to know to integrate
40 © 2006 Progress Software Corporation
Descargar

SOA-3