Tony J Winter Chief Technology Officer QAD Building the Effective Enterprise 2 The following is intended to outline QADs general product direction It is intended for information purposes only and may not be incorporated into any contract It is not a commitment to deliver any materia ID: 246561
Download Presentation The PPT/PDF document "Conquering Interoperability" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Conquering Interoperability
Tony J Winter – Chief Technology Officer, QAD
Building the Effective EnterpriseSlide2
2
The following is intended to outline QAD’s general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, functional capabilities, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functional capabilities described for QAD’s products remains at the sole discretion of QAD.
Safe Harbor Statement
Conquering InteroperabilitySlide3
3
Interoperability evolution
Component of integration
Data loading with Excel
Future: Cloud Application Integration QAD Connectors
Overview
Conquering InteroperabilitySlide4
4
EDI will not be covered in this session
Conquering
InteroperabilitySlide5
5
“The
ability of two or more systems or components to exchange information and to use the information that has been exchanged
”
[Source: IEEE]
Interoperability
Conquering
InteroperabilitySlide6
6
Interoperability evolution
Conquering Interoperability
BPM
File Transfer
EDI
EAI
SOA
SOAP - XML
WebServices
Cloud Integration
REST
WebServices
Future
Past
Present
Hard Coded
“Ability for two
or more systems
to
exchange
information”
Explosion of public API’s
Standard Integration
Integration as a Service
Simplified Tools
Converge with BPMSlide7
7
Emerging trend
Conquering
Interoperability
API
Data Access
Business
Logic
DataDirectSlide8
8
On premise application loading order into QAD
EA
W
alkthrough of a simple integration
Conquering
Interoperability
On Demand
On Premise
API / Event
Enterprise Applications
Data
External Firewall
128-bit
encryption
Cloud
Applicatio
n
API
On Premise
Application
API
Data
NetworkSlide9
9
Exposes services and data structures
Traditionally: APIs via CHUI screen wrapper in Q-
Xtend
Modern: APIs via code using AppServer
Application Programming Interfaces (API)
Conquering
Interoperability
On Demand
On Premise
API / Event
Enterprise Applications
Data
External Firewall
128-bit
encryption
Cloud
Applicatio
n
API
On Premise
Application
API
Data
NetworkSlide10
10
Exposes services and data structures
Example of Service Oriented Architecture (
SOA
)QAD Reference Architecture to support API’s
Conquering
Interoperability
API / EventSlide11
11
API Development
Conquering
Interoperability
7.9.5 Pre-Shipper/Shipper Confirm
3.7 Issues - Unplanned
16.20.1 Labor Feedback by Work Order
7.9.4 Pre-Shipper/Shipper Print
3.4.3 Transfer with Lot/Serial Change
16.19 Work Order Operation Backflush
7.9.23 Shipper Delete/Archive
3.4.2 Transfer - Multi Item
16.12 Work Order Receipt Backflush
7.9.22 Shipper Gateway
3.16.12 Tag Recount Entry
16.11 Work Order Receipt
5.7 Purchase Order Maintenance
3.16.11 Tag Count Entry
16.10 Work Order Component Issue
5.13.7 Purchase Order Returns
3.14 Inventory Scrap Transaction
12.19.7 DO Container Maintenance
5.13.20 PO Shipper Receipt
3.13.2 Cycle Count Results Entry
12.19.3 DO Pre-Shipper/Shipper Maint
5.13.19 PO Shipper Receipt Into Transit
3.12 Receipts - Backward Exploded
12.19.13 DO Pre-Shipper/Shipper Confirm
5.13.1 Purchase Order Receipts
3.1.1 Inventory Detail Maintenance
12.17.22 Distribution Order Shipments
35.9.17 Turnaround Data Maintenance
18.22.18 Scrap Transaction
12.15.20 Distributed Order Receipt
35.4.1 Shipment
ASN
Export
18.22.13 Backflush Transaction
3.9 Receipts - Unplanned
16.20.7 Operation Scrap Transaction
Continually building new APIs (2013 EE)Slide12
12
Expose APIs as SOAP
WebServices
using Q-
XtendData structure - QAD XML document (Qdoc
)
WebServices
& Data Transport
Conquering
Interoperability
On Demand
On Premise
API / Event
Enterprise Applications
Data
External Firewall
128-bit
encryption
Cloud
Applicatio
n
API
On Premise
Application
API
Data
NetworkSlide13
No formal format
Simple to usePrevalent for web and mobile appsAn architecture using HTTP
REST APIs
Strict XML format
Good security
Prevalent for integration
Is a container for data
SOAP APIs
What is SOAP and something called REST API’s?
Conquering
Interoperability
Over 9070 Public APIsSlide14
14
QAD canonical message format
Defines message structure
Defined using XML Schema
What is a
Qdoc?
Conquering
Interoperability
<
salesOrder
>
<
operation
>
A
</
operation
>
<
soNbr
>
SO0001
</
soNbr
>
<
soCust
>
001
</
soCust
>
<
salesOrderDetail
>
<
operation
>A</operation>
<sodPart>10-10000</
sodPart
> <sodQtyOrd>
100</sodQtyOrd>
</salesOrderDetail></salesOrder>Slide15
15
Q-
Xtend
inbound
– limited XML transformation (XSLT)Q-Xtend
outbound – simple XML formatting
Simple Transformation
Conquering
Interoperability
On Demand
On Premise
API / Event
Enterprise Applications
Data
External Firewall
128-bit
encryption
Cloud
Applicatio
n
API
On Premise
Application
API
Data
Network
Transformation
QDOCSlide16
Data Loading with MS Excel
Conquering InteroperabilitySlide17
17
Q-Xtend
Excelerator
Supports Excel 2007 & 2010
Export, import and mass change bulk data
Data Loading with MS Excel
Conquering
Interoperability
On Demand
On Premise
API / Event
Enterprise Applications
Data
Q-
Xtend
ExceleratorSlide18
18
Conquering
InteroperabilitySlide19
Future: Cloud Application Integration
QAD Connectors
Conquering InteroperabilitySlide20
20
Provide standardized integrations
Accelerate application integration
C
omprehensive On Demand & On Premise solution
QAD Connectors Goals
Conquering
Interoperability
On Demand
On Premise
API / Event
Enterprise Applications
Data
External Firewall
128-bit
encryption
Cloud
Applicatio
n
API
On Premise
Application
API
Data
NetworkSlide21
21
Global repository for integration
Evolve general integrations to standard ones
Provide a comprehensive integration platform
QAD Connectors Strategy
Conquering
Interoperability
EvolveSlide22
22
Managed
cloud
i
ntegration
P
latform
a
s
a
S
ervice
Types of services:
Mapping
Transformation
I
ntegration workflow…
QAD
iPaaS
Conquering
Interoperability
On Demand
On Premise
API / Event
Enterprise Applications
Data
External Firewall
128-bit
encryption
Cloud
Applicatio
n
API
On Premise
Application
API
Data
Network
Integration Platform
as a ServiceSlide23
23
Summary
Conquering InteroperabilitySlide24
24
New wave of interoperability
Leverage Q-
Xtend
Excelerator
Interested in
iPaaS
– Leave me your business card
Learn more about managed EDI (Thursday 11am)
Summary
Conquering InteroperabilitySlide25
25
Tony J Winter:
tww@qad.com
Questions & Answers
Conquering InteroperabilitySlide26
www.qad.com
©QAD Inc. 2013
26