SOA-25 Data Distribution Solutions Using Data Xtend Semantic

SOA-25: Data Distribution Solutions Using Data. Xtend® Semantic Integrator for Sonic™ ESB Users Jim Barton Solution Architect

Do you have one of these in your office? 2 SOA-25: Data Distribution Solutions

Agenda Sonic Data Distribution Solutions using Data. Xtend SI § Common Data Distribution Problems § Introduction to Data. Xtend SI § Solving Data Distribution Problems with DX SI § Demonstration 3 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Remote Data Distribution The problem: Remote sites need up-to-date master data New York BATCH CYCLE Security Master Reference Data WAN Equities San Francisco 4 § Can’t process transactions § WAN Futures Error: UNKNOWN CUSIP Chicago which depend on pending MRD updates. Costly errors occur when MRD batch is late. WAN Fixed Income Forex Charlotte London SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Remote Data Distribution Sonic ESB solution § § § Security Master Reference Data Continuously feeds business transactions as they become available In-order delivery guaranteed ESB can batch up events for an application that must continue to operate in batch mode. WAN WAN Equities Futures Fixed Income Forex San Francisco 5 WAN Chicago Charlotte London SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

The Growing Semantic Challenge in SOA Solving the accidental architecture of data <XML> Tr an sfo r ma tio n <XML> § § 6 <XML> Sonic ESB eliminates the rigidity and fragility of pointto-point connections How do I solve the similar problem in my data model transformations? SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Agenda Sonic Data Distribution Solutions using Data. Xtend SI § Common Data Distribution Problems § Introduction to Data. Xtend SI § Solving Data Distribution Problems with DX SI § Demonstration 7 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Introducing Data. Xtend Semantic Integrator Common model management <XML> Tr an sfo r ma tio n <XML> § § § 8 <XML> Rapidly map to a common data model from any number of schema • Design mappings in Eclipse-based Workbench Common model mediates transformations Deployed and managed as an ESB service • Java™ -based validation and transformation • Regenerated if schema or common model change SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Data. Xtend SI Product Capabilities CENTRALIZED DESIGN DISTRIBUTED RUNTIME TESTING oy Depl Generate § Visual tool for designing integration Runs in Eclipse 9 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users § Stateless for scalability § Runs in any Java container § Connects to any bus © 2008 Progress Software Corporation

Data. Xtend SI Product Capabilities § Visualize and manage complex models • TMForum SID model contains 1, 000+ classes § Build mapping and transformation rules with § § 10 rich UI Create validation rules without (or with) code Use virtual attributes to extend models without violating standards Test models interactively Manage change with impact analysis reports SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Agenda Sonic Data Distribution Solutions using Data. Xtend SI § Common Data Distribution Problems § Introduction to Data. Xtend SI § Solving Data Distribution Problems with DX SI § Demonstration 11 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

What Is Data Distributor? Data. Xtend SI Data Distributor § § § New Data. Xtend SI feature in version 8. 3 Enables real-time, reliable information synchronization across data sources • Frequently databases but not limited to that 2 Key Added Capabilities • Change Data Capture – Captures changes from source database log (e. g. , Oracle) § Can also build your own for unsupported data sources – Publishes changes to Sonic ESB • Reconciler – Captures relevant change messages from Sonic ESB – Applies changes to target database 12 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Maintaining a Customer Master Store CRM Canada CRM US Transform CDB 02 CDC CDB 01 Address Validation CDC R Customer Master Data Management 13 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Maintaining a Customer Master Store CRM Canada CRM US Transform CDB 02 CDB 01 Canadian Changes MDM Common Model Address Validation American CDC Changes CDC R Customer Master Data Management 14 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Maintaining a Customer Master Store CRM Canada CRM US Transform CDB 02 CDB 01 Canadian Changes MDM Common Model Address Validation American CDC Changes CDC R High Speed Cache 15 R Customer Master Data Management SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Maintaining a Customer Master Store CRM Canada CRM US Transform CDB 02 CDB 01 Canadian American Changes High Speed Cache Common Model Customer Update Data Service 16 CSR CSR Portal CSR Portal Portal SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Agenda Sonic Data Distribution Solutions using Data. Xtend SI § Common Data Distribution Problems § Introduction to Data. Xtend SI § Solving Data Distribution Problems with DX SI § Demonstration 17 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Demonstration Architecture CRM Canada CRM US Transform CDB 02 CDC CDB 01 Address Validation CDC R Customer Master Data Management 18 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

In Summary § Information Distribution § § 19 is a common use case for SOA Data. Xtend SI facilitates model-driven data integration Data Distribution marries Data. Xtend SI and Sonic for info distribution between data sources SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

For More Information, go to… § Progress Web Site • Data. Xtend SI Product Information http: //www. progress. com/dataxtend/index. ssp § PSDN • Data. Xtend SI Development Resources http: //www. psdn. com/library/kbcategory. jspa? category. ID=1313 § Downloads • Data. Xtend SI Evaluation Software http: //www. psdn. com/library/entry. jspa? external. ID=4378 • SID Model Browser http: //www. progress. com/dataxtend/web/global/sid-browser/index. ssp 20 SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation

Relevant Exchange Sessions § SOA-13: Introduction to Data. Xtend § 21 Semantic Integrator SOA-19: Combining the Power of Sonic, Data. Xtend Semantic Integrator, and Actional for SOA Operations SOA-25: Data Distribution Solutions Using Data. Xtend SI for Sonic ESB Users © 2008 Progress Software Corporation