Using OpenSource MuleESB And QXtend To Build Robust SOA Solutions

1. Using OpenSourceMuleESB And QXtend To Build Robust SOA Solutions Gary Yang, Roundview Technologies

2. QXtend & MuleESB About Gary Yang And Roundview Technologies • Have been a QAD consultant / solution architect since 1997 • Started own consulting business in 2010 • Pioneer in QXtend integration framework implementations with the first successful project in QXtend and a number of large scale projects, such as Eaton, Visteon, Avery Dennison, Nexteer, Tower, Freudenburg-NOK, Harris, Physio-Control (Medtronic), Superior Industries, A. O. Smith, Excel Industries, Sugar Foods • Specialize in advanced / new QAD technologies, .Net UI, CSS, Enterprise Financials, Performance Tuning, Non-Intrusive Customizations • Have team of consultants in US and China available globally

3. QXtend & MuleESB Service Oriented Architecture (SOA) • SOA is a business operations strategy for leveraging information to meet the enterprise’s objectives and deliver business capacity • SOA provides a set of principles of governing concepts used during phases of system development and integration • With loose coupling of services, SOA fulfils intra and inter-enterprise services reuse and process interoperability • SOA will automate business functions and deliver solutions cheaper, better and faster

4. QXtend & MuleESB *From QAD QXtend Training Guide

5. QXtend & MuleESB QXtend Inbound • Supports versions eB through QAD 2012EE and SE • Receive QDocs via Web Service and process QDocs by a pool of sessions (multi threaded) • Supports both standard and custom QDocs • Security checking • QAD Enterprise Applications authentication • XML message validation • E-mail alerts • Pre/post-processing available for added functionality • Query Service (in conjunction with QXO) allows real time query into QAD Enterprise Applications • Service Interface for maximum flexibility

6. QXtend & MuleESB QXtend Inbound (QXI) Enterprise Interfaces QAD App QXtend Inbound QXtend Outbound QDoc QAD App QAD EA SOAP (XML) Over HTTP 3rd Party Programs

7. QXtend & MuleESB QXtend Inbound vs. CIM • CIM Has Been Used Very Often In Integration Solutions, But… • Sequence sensitive • Easy to break • Only works with character interface • Difficult response tracking / exception handling • Difficult to work across servers / databases / domains • Maintenance programs with UI triggers (wrappers, ICT, TailorPro) will fail • End of life approach • QXtend Is The Answer To The Problems With CIM

8. QXtend & MuleESB Query Service And Service Interface (SI) • Allow the data retrieval from QAD via the Web Service • Easy to build for conventional queries • Flexible SI for more complex logic such as best pricing or BOM (recursive algorithm) • Si can also be used to handle high volume transactions where UI API does not perform well enough

9. QXtend & MuleESB QXtend Outbound • Provides outbound QAD integration • Event-based publish subscribe model • Direct Data Publishing model (DDP) • Publishes QDocs or other XML documents • Delivers to subscriber via web-service or file • Real time or batched • Built-in email alerts

10. QXtend Case Study Bank Interfaces QAD MES BOM Shipping Info For Customs (2TS) (SRM) Spend Management QAD .Net UI Or Batch Initiates Messaging (Event Or DDP)

11. QXtend & MuleESB Shared Service Model QXO UI Source Application Subscriber QDocs MFG/PRO #1 QXO Server MFG/PRO #1 (via QXI) Adapter MFG/PRO #2 (via QXI) MFG/PRO #2 Adapter MFG/PRO #3 (via QXI) MFG/PRO #3 Adapter JCAPS (EAI)

12. QXtend & MuleESB Solutions We Built With QXtend • Inbound And Outbound Third Party Software Integrations • Data Replications • Master Data • Transactional Data • QAD Customizations – Turn QAD Modules Into Objects • QAD Data Load / Conversion Utilities • Web Based Solution Integrations • From QAD eB through 2012 EE

13. QXtend & MuleESB Selected List Of Customers We Helped With QXtend Solutions

14. QXtend & MuleESB The Need For An Efficient Messaging Middleware • QXtend is a point-to-point solution if connected directly with the client • Cannot handle asynchronous processing • Difficult to manage messaging exceptions, retries, and notifications • No visibility of the processing by business • No guaranteed delivery • Difficult to manage large number of interfaces

15. QXtend & MuleESB *From QAD QXtend Training Guide

16. QXtend & MuleESB Choices Of Messaging Middleware • Oracle Fusion / WebMethod • IBM WebSphere MQ • Sonic ESB • Sun (Oracle) JCAPS • Microsoft BizTalk • Open Source Solutions

17. QXtend & MuleESB No. 1 Open Source ESB Solution - MuleESB • Free Base ESB Product • Commercial Strength • Graphical Workflow Design • Mule Studio For IDE • Scalable, Reliable and Extensible

18. QXtend & MuleESB Using MuleESB In QXtend Centric Architecture

19. QXtend & MuleESB QXtend Outbound Flow

20. QXtend & MuleESB QXtend Inbound Flow: Synchronous

21. QXtend & MuleESB QXtend Inbound Flow: Asynchronous

22. QXtend & MuleESB Portal For Business Visibility – The Key To Success • Remove The Need For IT To Be In The Middle Of Daily Data Issue Resolution • Empower Business With The Tools They Need • Provide Visibility To The Messaging Status And Cause Of Failures • Provide business with reprocessing capabilities in certain situations • Have Used Similar Approaches At Visteon, Nexteer, Lang-Mekra And They Were All Well Received

23. QXtend & MuleESB

24. QXtend & MuleESB

25. QXtend & MuleESB Conclusions • MuleESB is an affordable middleware solution for customers need more robust integration solution • Business Portal provides great visibility and issue resolution tools for business to take control of the integration process

26. QXtend & MuleESB Questions? Gary Yang At gary.yang@roundviewtech.com / LinkedIn