SOA-3:%20You%20Need%20to%20Integrate,%20But%20What%20do%20You%20Need%20to%20Know%20and%20Do?

1
SOA-3 You Need to Integrate, But What do You
Need to Know and Do?
Bob Trabucchi
Sandy Caiado
Sr Presales Consultant
Sr Presales Consultant
2
Agenda

• Current OpenEdge Integration Options
• Sonic ESB Integration Demo
• Summary

3
OpenEdge Integration Technology Choices

• Data-level integration
• File Transfer Systems (batch/FTP/ETL/file drops)
• OpenEdge replication
• OpenEdge data server
• Application-level integration (real-time)
• Sockets
• SonicMQ
• Both integration types
• Sonic ESB

1
2
4
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

Designed for Overnight Processing
5
Application Specific Model
2

• Integration through real-time data exchange
• Homegrown real-time systems
• e.g. 4GL sockets

6
Application Specific Model
2

• Integration through real-time data exchange
• Homegrown real-time systems
• e.g. 4GL sockets

Sockets
Progress DB
7
Application Specific Model
2

• Integration through real-time data exchange
• Message Oriented Middleware (MOM)
• e.g. SonicMQ

8
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

9
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

10
Agenda

• Current OpenEdge Integration Options
• Sonic ESB Integration Demo
• Summary

11
Demo Whats 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

12
Demo Scenario

• Company
• All Sports Distribution
• Business
• Sporting goods wholesaler
• Integration Goals
• Publish price changes to local retailers in
  real-time
• Guarantee delivery of the data
• Wants to reuse the same solution for others

13
Demo Scenario

• Interested parties that will be notified in a
  phased approach.
• Phase 1 Send to Sandy Scuba Shop
• Phase 2 Send to Bobs Boating and Fishing
• Phase 3 Send to Divots Golf
• Phase 4 Send to Caesars Sports
• Purchase decision
• Caesars sends purchase order to All Sports

14
Phase 1 Integrate with Sandys Scuba

• Problem
• Price change info generated by the OpenEdge 10.1
  price change application needs to get to Sandys
  Scuba Store in real-time.
• Solution
• Add real-time integration channel
• Sandys Scuba only wants price change info that
  is meaningful to them.

15
Phase 1
OpenEdge Inventory Application
Sonic ESB
Transform
T MyPartners
T DivingTopic
XML
16
Phase 1 Demo
17
Anatomy of an ESB Service
Exit Endpoint
Entry Endpoint
Service
Input
18
Phase 1 Review

• Real-time integration accomplished!
• Trivial coding effort got us on the ESB
• Master XML document
• Transformed for Sandys 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, ?, ?, ?).
19
Phase 2 Integrate with Bobs BF

• Expand All Sports Dist. integration architecture
  to support Bobs 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

20
Phase 2
All Sports Dist. HQ
Bobs Boating and Fishing
OpenEdge Inventory Application
OpenEdge Application
Temp-table
Temp-table
Sonic ESB
T FishingBoatingTopic
Transform
Transform
T MyPartners
T DivingTopic
XML
21
Phase 2 Demo
22
Phase 2 Review

• Real-time integration with Bobs BF
  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.
23
Phase 3 Integrate with Divots Golf

• Problem
• Expand the integration to support All Sports new
  partner Divots Golf
• Divots dictates XML format
• Wants NO Sonic components
• Solution
• Add another real-time integration channel to All
  Sports distribution center
• Support Divots existing specific XML format

24
Phase 3
All Sports Dist. HQ
Bobs Boating and Fishing
OpenEdge Inventory Application
OpenEdge Application
Temp-table
Temp-table
Sonic ESB
T FishingBoatingTopic
Transform
T MyPartners
T DivingTopic
T DivotFormatTopic
XML
Q GolfCategory
XML
25
Phase 3 Demo
26
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

27
Phase 4 Caesars Sports Purchasing Process

• Caesars Sports integrated purchasing decision
• Process
• Receive temp-table from All Sports Dist. (because
  Caesars has an OpenEdge App.)
• Order item ONLY if price point is lower

28
Phase 4
OpenEdge Inventory Application
All Sports Dist. HQ
XML
Temp-table
Sonic ESB
T MyPartners
Caesars Sports
T PurchaseTopic
OpenEdge Application
Temp-table
29
Phase 4 Demo
30
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

31
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

32
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

33
Agenda

• Current OpenEdge Integration Options
• Sonic ESB Integration Demo
• Summary

34
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

35
Keys to Success

• Collaborative approach
• Products OpenEdge, Sonic ESB
• Training Unfamiliar products, and methodologies
  
• Mentoring Integration problems are hard to
  solve

36
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 430 700
• Tomorrow 1130 200
• Attend other integration sessions

37
Where To Go From Here?
Get some specifics!

• MOV-7 Sonic Success Stories, Tues 915
• SOA-06 Standards for SOA, Tues 1030
• SOA-07 Sonic ESB for OE Developers, Tues 215
• SOA-09 Implementing SOA in Financial Services,
  Banco Comafi a Real Lending Case, Tues 445
• SOA-11 Design Best Practice, Wed 115
• SOA-14 Deploying your SOA App, Wed 340

38
Questions?
39
Thank you foryour time
40
(No Transcript)