QXtend Dell Boomi Implementation At Key Safety Systems

QXtend / Dell Boomi Implementation At Key Safety Systems Using QXtend / Boomi To Build Scalable QAD integration Solutions Sanjay Jha, Key Safety Systems Gary Yang, Roundview Technologies

QXtend / Boomi About Key Safety Systems Ø Global leader in the design, development and manufacturing of automotive safety-critical components and systems including airbags, seatbelts, and steering wheels Ø KSS is headquartered in Sterling Heights, Michigan with a global network of 34 sales, engineering, and manufacturing facilities. The company has 4 main technical centers located in the U. S. , Germany, China, and Japan Ø Operations in NA, Europe, South America and Asia

QXtend / Boomi ERP Current State: Challenges & Transformation Plan n 8 ERP/Financial systems (from past acquisitions) managing our global business across different geographies & business units QAD 8. 5 (US, Mexico) Most systems were deployed before Y 2 K and are now end-of-life products without vendor support AS 400 ACG 2 (Italy) Challenges in “Real Time” business visibility across the globe Operational KPIs n Planning & Forecasting challenges n Efficient Plant operations management n n n Data integrity issues, process inefficiencies & redundancies Barrier to future growth, regulatory & financial compliance management CHESS 3. 2 (US, Mexico) KSS Board approved the global program on Jan 22, 2014 Golden Lake (Italy) Dual Ciel (Romania) Formula Diapason (Italy) Glovia 5. 2 (Germany, Italy, Romania, UK) QAD EB 2 (China) QAD Enterprise Edition Automotive Edition (QAD EE 2014)

QXtend / Boomi Why QAD? n In 2013, KSS conducted due diligence for ERP solution: n n Evaluated multiple vendors (SAP, QAD, Infor, MS Dynamics) Key Criteria: n n n Real-time global visibility into KSS Manufacturing operations Ability to deploy global templates Statutory/ regulatory /financial reporting compliance in countries where KSS operates Ease of use, maintenance, implementation, training & cost effectiveness HR, Legal, CRM processes were out of scope Selected QAD based on: n Willingness to invest and consider KSS as a strategic account n n Strong automotive Tier 1 supplier presence n n Mexico, US, Italy Due Diligence – QAD invested in this process Out-of-the-box MMOG/LE compliance capabilities Operational metrics to support KSS KPI requirements Ease of use & cloud based comprehensive solution Potential gaps exist, but vendor is willing to partner and close the gaps: n n Purchasing (RFQ process) Finance (Global Consolidation & Reporting – replace Hyperion FDM)

QXtend / Boomi KSS Requirements For QAD / 3 rd Party System Integration Ø A Robust Framework For QAD Related Integrations Ø Highly Scalable, Extensible And Reliable Ø Transparency: Business Has Full Visibility And Control Of Message Processing Ø Globally Standardized Process

QXtend / Boomi About Roundview Technologies Ø Founded in 2010 (www. roundviewtech. com) Ø QAD Service Partner Ø 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 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 Ø 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 Dell Boomi – Intuitive User Interface

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

QXtend / Boomi Key Design Features At KSS Ø 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 KSS 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 SOAP PLM MFG/PRO QAD DB Set QXtend Outbound DDP

QXtend / Boomi

QXtend / Boomi

QXtend / Boomi Interfaces Developed (WIP) Ø Inbound Interfaces § Item Master From ARAS Bill Of Material (Product Structure And BOM Code) From ARAS § Production Reporting (Backflush And Container) From MES § Ø Outbound Interfaces: § § § § Ø Item Master To MES BOM To MES Routing To MES Work Center To MES PO Receipt To MES Shipment To MES AP Bank Driver Master Data Replications § § § Item Master BOM Code Product Structure

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 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 DEMO

QXtend / Boomi Questions? Contact Sanjay Jha At Jha. S@keysafetyinc. com or Gary Yang At gary. yang@roundviewtech. com / Linked. In