Building QXtend Dell Boomi Based Integration Framework Gary

Building QXtend / Dell Boomi Based Integration Framework Gary Yang, Roundview Technologies

QXtend / Boomi About Roundview Technologies Ø Founded in 2010 (www. roundviewtech. com) Ø QAD Service Partner Ø Dell Partner (Boomi) Ø Specializes In QAD Technical Consulting Ø Extensive Experiences In QAD Services Including QXtend, Dell Boomi, . Net UI, CSS, Enterprise Financials, Advanced Customizations, etc. Ø Global Resources in QAD Technologies, . Net, J 2 EE Custom Developments

QXtend / Boomi Top Pains In Integration Projects Ø Not Robust – Too Many Failures Ø Poor Visibility – No One Knows What Happens to The Data Ø Extremely Long RCA And Issue Resolution - Poor Exception Handling Ø Not Scalable – Cannot Handle Increased Volume Or New Business Proces

QXtend / Boomi QAD QXtend Integration Framework And Dell Boomi Ø QXtend is the integration framework from QAD Ø QXtend is the adapter to QAD EA that allows QAD to communicate with 3 rd party applications using standard Web Service protocols Ø QXtend is NOT a middleware, so the request/response model does have some rigidity for inbound transaction processing Ø After evaluating 56 or so middleware solutions, QAD has partnered with Dell and recommend Boomi as the middleware to work in conjunction with QXtend

QXtend / Boomi Messaging Middleware – Why We Need It? Ø QXtend Web Service Is Synchronous - SOAP over HTTP(s) Ø Need For Queuing Mechanism Ø QXtend Is Only An Adapter Ø Failed Message Retry And Exception Handling Can Be A Challenge For Third Party Caller Ø Transformation And Message Orchestration – Dealing With Text Files, For Example Ø Need For Data Encryption Ø Enterprise Service Bus Is Becoming A Standard In Corporate IT

QXtend / Boomi Messaging Middleware QAD EA MES 3 PL QXtend PLM Payroll ESB / EAI (Web. Sphere MQ, Oracle Fusion, JCAPS, Boomi, SAP Net. Weaver, Biz. Talk, etc) QMS Banks Workflow Web Portal Corporate Systems

QXtend / Boomi Dell Boomi (http: //www. boomi. com) Ø A Cloud Based Messaging Middleware Solution Ø Configuration And Developed Objects Are Stored in Boomi Cloud Ø Runtime Environment (Atoms) Can Be Deployed In The Dell Cloud, QAD Cloud Or On Premise Ø Queuing Feature Assures Message Delivery Ø More Flexible XML Structure (examples) Ø Customizable email alerts Ø Various Adapters That Covers All Common Connection Protocols Ø Development Of Boomi Is Done Via the Graphical User Interface, Almost All Done Via Drag/Drop And Configurations Ø We Have Certified Boomi Consultant On Our Team

QXtend / Boomi QAD Boomi Atom. Sphere Program Goals n n n Provide Boomi functionality to QAD customers at significant savings Support QAD cloud connectivity n Securely integrate to cloud applications n Reduce integration development time and cost n Easily connect to key 3 rd party applications n Reduce integration management overhead Support integration and upgrade projects n Develop/re-develop integrations in less time at lower cost n Improve security, support cloud applications and reduce management overhead

QXtend / Boomi Dell Boomi – Integration Platform As A Service (i. Paa. S) Integration Paa. S Apps Social Networks Cloud Services Saa. S Apps

QXtend / Boomi Cloud apps Dell Boomi – Secure Cloud & On Premise Integration External firewall 128 -bit encryption (metadata only) On-premise Data

QXtend / Boomi Dell Boomi – Market Leader For i. Paa. S (Gartner)

QXtend / Boomi Dell Boomi – Intuitive User Interface

QXtend / Boomi Dell Boomi – Intuitive User Interface (Continued)

QXtend / Boomi Dell Boomi – Intuitive User Interface (Continued)

QXtend / Boomi Key Design Features Of Roundview Solution Ø We Strive To Utilize Standard QXtend Functions To Minimize Custom Architecture Ø Choose QXtend Outbound Direct Data Publishing For High Volume Data Export From QAD, and Event Based Messaging For Real Time Data Extract Ø For Inbound Messages, We Have The Following Processes To Ensure Delivery: § § § Ø 3 rd Party System Sends Data To Boomi Via Web Service Boomi Queues The Message And Converts It To QDoc, Sends To QXI Via SI Adapter. The Data Is Stored In Custom Repository Tables First To Avoid Exposing QAD Transactional Issues To Boomi Custom Tables Triggers The QXO Processing Of The Messages Which Are Sent To QXI For QAD Transactions Message Monitor, Which Is A. Net UI Plug-In For QAD. Net UI Client, Can Be Used To Track The Inbound & Outbound Message Processing, And Allows User To Resubmit Message If Failed (Due To Record Locking Or Data Setup Issues)

QXtend / Boomi Architecture User Can Review Inbound & Outbound Message Processing Status Via Message Monitor SI QXtend Calls To Populate Intermediate Table QXtend Outbound Becomes The Repository For Asynchronous Inbound Transaction Processing SOAP QDoc MES UI API QXtend Inbound FTP SI API FTP Bank Boomi Atom QDoc Event QDoc AS 2 3 PL MFG/PRO QAD DB Set QXtend Outbound DDP

QXtend / Boomi QXtend Message Monitor Ø One Of The Most Important Aspects That Defines Successful Interface Project And Failure Is The VISIBILITY Of Message Processing State Ø Message Monitor Is A QAD. Net UI Plug-In Ø User-Friendly Tool To Check For Message Processing Status And Data: § § Browse Widget Can Retrieve Large Set Of Data Workbench Type User Interface Provide Rich Data Content Ø User Can Re-Process Failed Message From Here If Needed Ø Key For Our Effort To Enable Business To Take Control Of THEIR Data

QXtend / Boomi QXtend Message Monitor

QXtend / Boomi Things Can Be Done More Effectively

QXtend / Boomi Questions? Gary Yang At gary. yang@roundviewtech. com / Linked. In