Are You Ready For QXtend?

1. Are You Ready For QXtend? What To Do And What To Avoid Gary Yang, Roundview Technologies

2. Are You Ready For QXtend? • Agenda • QXtend – What Is It? • QXtend Architecture • What Can QXtend Do For You? • QXtend Inbound • QXtend Outbound • Messaging Middleware

3. Are You Ready For QXtend? • What is QXtend? • Is the QAD Interoperability “Framework” • A generic set of ‘modular building blocks’ and standards to provide connectivity across QAD products • SOA (Service Oriented Architecture) Based • Uses web services to plug components together • Enabling Flexible and Quick-to-Market Solutions • Allows anything to plug to QAD products with minimal effort

4. MDM, PLM, etc. QXtend(QXI/QXO) Compliance Shared Services Demand / Supply Financials CustomerSchedules Supplier Schedules Multi- National Financials CustomerSelf Service Supplier Self Service “Core” QAD EA Forecasting Purchasing Distributed Order Mgmt Distributed Order Mgmt Service, Support & Returns Supply Chain Planning EDI EDI Planning Production CustomerConsignment SupplierConsignment Manufacturing Ware-housing Lean JIT/S

5. Are You Ready For QXtend? QXtend Inbound (QXI) Enterprise Interfaces QAD App QXtend Inbound QXtend Outbound QDoc QAD App QAD App SOAP (XML) Over HTTP QAD Custom Programs

6. Are You Ready For QXtend? QXtend Inbound Architecture UI Adapter is QXtend Progress code added to QAD client installation Synchronous WS messages UI/Administration Logging/Auditing External Systems Web Service Transaction Manager Routing Manager External Systems UI Adapter QDoc MFG/PRO MFG/PRO QAD DB Set QDoc Async Dir Service SI Adapter QDoc 0 to X QAD EA’s or QAD Sessions 3rd Party integrations Security JMS Adapter call to QAD application server J2EE App Server

7. Are You Ready For QXtend? QXtend Outbound (QXO) Order Confirm QAD EA Allocation Shipping Invoicing Sales Order Life Cycle

8. Are You Ready For QXtend? QXO: Multi-Sources And Multi-Destinations QXO UI Source Application Subscriber QDocs QAD EA #1 QXO Server QAD SE / EE (via QXI) Adapter QAD EA #2 JIT/S (via QXI) Adapter QAD EA #3 Messaging Broker Adapter JIT/S #1 Web App (web-service enabled) Adapter QAD Add-On ... Adapter

9. Are You Ready For QXtend? QXO Architecture

10. Are You Ready For QXtend? • What Can QXtend Do For You? • Third Party System Integrations • Master Data Replications • Intercompany (Cross Domain) Transactions • Customizations • Data Load / Conversions • Data Inquiries (Get Rid Of ODBC)

11. Are You Ready For QXtend? • QXtend Inbound – DO NOT • Put On The Same Tomcat Instance As .Net UI • Use UI API When SI Is Possible • When Using Query Service, Avoid Inter-System Recursion • Multi-Threading On Transactional Data With Possibility Of Record Locking • Customize QAD Program With Out Testing QXI • Do Not Follow QGenQdoc and Iteration Naming Conventions • Blame QXtend For All Performance Issues

12. Are You Ready For QXtend? • QXtend Inbound – DO • Give Enough Memory To Tomcat • Turn On Debug Mode Log – Yes, Even For Production • Monitor Connection Pool And AppServer Agents • Use Connection Pool “maxuses” To Control The Number Of Invocations From On Agent • Comply With QAD Customization Standards • Use SI For More Complex Queries

13. Are You Ready For QXtend? • QXtend Outbound – DO NOT • Use Replication Triggers Without Considering Performance • Using Event Based Approach For High Volume Data Objects • Include All Fields In A Table • Reversed Scan In Dataset Query • Use Default Profile • Excessive Use Of Calculation Fields • Use Event Triggers For EE Related Objects (such as ad_mstr)

14. Are You Ready For QXtend? • QXtend Outbound – DO • Use Event Filter Or Modify Replication Trigger To Eliminate Unwanted Events • Use DDP (Direct Data Publish) For High Volume Messages • Use Tokens Instead Of Multiple Profiles • Use Custom Parsers To Report Response Message More Accurately • Monitor The AppServer And QXO Sessions Via Automated Scripts • Create Delete / Archive Policy • Enable Business User Visibility Of The Integration Process

15. Are You Ready For QXtend? • Messaging Middleware – Why We Need It? • QXtend Web Service Is Synchronous - SOAP over HTTP(s) • Need For Queuing Mechanism • QXtend Is Only An Adapter • Exception Handling Can Be A Challenge For Third Party Caller • We May Need A Transformation Layer – Dealing With Text Files, For Example • Need For Data Encryption • Enterprise Service Bus Is Becoming A Standard In Corporate IT

16. Are You Ready For QXtend? • Messaging Middleware

17. Are You Ready For QXtend? • Dell Boomi • QAD’s Recommendation Of Messaging Middleware To Work With QAD • Cloud Based Solution With On Premise Deployment Options • Has Load Balancing Via Boomi Molecule and Atoms • WYSIWYG User Interface For Mapping and Development • We Have Certified Boomi Consultant On Our Team

18. Are You Ready For QXtend? • Conclusion • MUST Understand The Architecture • How To Implement QXtend Can Make A Big Difference • Consider Using Message Middleware • Once Done Right, QXtend Can Make The Life Easier For Corporate IT

19. Are You Ready For QXtend? Questions? Gary Yang At gary.yang@roundviewtech.com / LinkedIn