Ariba Integration Platform - Ariba Exchange

hungryhorsecabinSoftware and s/w Development

Dec 14, 2013 (3 years and 8 months ago)

647 views

©2009. Ariba, Inc. All rights reserved.
Ariba Integration
Platform
Walter Metrich
Product Manager
2
©2009. Ariba, Inc. All rights reserved.
Agenda
Integration Goals
Integration Toolkit
Data Transfer Tool
DB Connector
Open Protocol Tool
Web Services
Current Approach to Integration
Ariba Platform and Standard ERPs
2
3
©2009. Ariba, Inc. All rights reserved.
Integration Goals
Enterprise-Class Integration
Capabilities for both Ariba CD and On-Demand solutions
Leverage investments in current middleware solutions
Multiple Integration Options:
Integration Toolkit:

Data Transfer Tool: facilitates CSV file transfers

DB Connector: Link between Data Transfer Tool and JDBC-
based backend systems
Web-Services:

Real-time, bi-directional integration of transaction data
*Open Protocol

Upload master data in batch mode without using the Integration
Toolkit
3
* Ariba On-Demand Platform Only
4
©2009. Ariba, Inc. All rights reserved.
Enterprise Data
Recap
Transaction Data
Record of commercial and/or
financial information flow within or
across enterprises
References master data
Changes very frequently
Examples

Requisitions

Purchase Orders

Receipts

Expense Reports

Invoices / Payments

Remittance

RFxProjects

Bid Awards

Contract Terms
Master Data
Reference data related to the core
operations of a business
Shared by multiple users and
groups
Changes infrequently
Stored on different systems
Examples

Users

Groups

Catalog items

Supplier Orgs

Commodity Codes

Currency Conversion Rates

Chart of accounts
4
5
©2009. Ariba, Inc. All rights reserved.
Integration Architecture: circa 2004
5
Ariba System
Corporate Systems
Flat
Files
Interface
Tables
File
Channel
Ariba
Messaging
Framework
Corp
orate
EA
I
Ti
bco
Chan
nel
Message
B
u
s
SAP
Oracle
Peopl
eSoft
JDE
GEAC
Lawson
Walker
Maximo
Indus
Legacy
Ariba
Adapter
Message
Broker
ERP

Adapter
Ti
bco
6
©2009. Ariba, Inc. All rights reserved.
6
Customer
Ariba
Integration
Toolkit
Web Services
File Channel
Limited Master Data,
Transacti
onal D
a
ta / Real-Time
*Open Protoc
ol
Maste
r
Data / Batch Mod
e
Maste
r
Data,
Transacti
o
nal D
a
ta / Batch Mo
d
e
Current Integration Architecture
*SAML
2.0
*SAML
2.0
Single Sign On
Ariba Messagin
g Framew
ork
cXML
Ariba
Netw
ork
Adapter
Ariba Supplier Network
Transacti
o
nal D
a
ta fo
r Invoic
e
Automati
o
n
/Pro / Event Driven
* Arib
a

On-Dem
a
nd Pl
a
tform
Only
Cor
p
.
EA
I
Ariba
Platform
Flat
Files
Inter
f
ace
Tables
7
©2009. Ariba, Inc. All rights reserved.
Enterprise-Class Integration
7
Transaction
Data
Master
Data
Discrete
Bulk
Web Services
Web Services
Integration Toolkit
or
*Open Protocol
Frequency of Change
Volume
(Limited Master Data)
Integration Toolkit
* Ariba On-Demand Platform Only
8
©2009. Ariba, Inc. All rights reserved.
Integration Toolkit
8
The Ariba Integration Toolkit is made up of two tools
Ariba Data Transfer Tool

Command-line utility that facilitates CSV file transfers
DB Connector

Command-line utility that bridges the gap between the Ariba Data
Transfer Tool and JDBC-based ERP systems
Two ways to schedule the tools:
Independently scheduled to run by an external scheduler
Serially by a single script
9
©2009. Ariba, Inc. All rights reserved.
An Example….
Internet
Ariba Platform
Secure
Communication
HTTP(s)
ERP
Ariba Integration Tool-kit
Remittance import
OK to pay export
Master data import
CSV
files
Data Transfer
Tool
DB Connector
JDBC
Interface
Tables
* Ariba On-Demand Platform
10
©2009. Ariba, Inc. All rights reserved.
Data Transfer Tool
The Ariba Data Transfer Tool is a simple HTTP client that runs
on Windows or UNIX
Data is transferred in the form of comma-separated-value (CSV)
files
Wrapper scripts use options that you specify to invoke core code
functionality
11
©2009. Ariba, Inc. All rights reserved.
Data Transfer Tool
Use the Ariba Data Transfer Tool to perform these tasks:
UploadMaster datafrom your Ariba system:

Synchronize the Ariba application with your ERP by transferring a
snapshot of the master data from your ERP system
UploadTransactional datato your Ariba system:

Synchronize the Ariba application with your ERP by transferring
transactional data incrementally from your ERP system
UploadSpend Visibility datato your Ariba system:

Synchronize Spend Visibility with your ERP for reporting and analysis
tasks by transferring analytical data files in ZIP format from your ERP
system.
Download transactional datafrom your Ariba system:

Synchronize your ERP system with Ariba by transferring transactional
data from an Ariba application such as expense reports and payment
requests
12
©2009. Ariba, Inc. All rights reserved.
DB Connector -Example
DBConnector
Read DB config
information
Read queries
PaymentHeaderExport.sql
PaymentDetailExport.sql
Postprocessing.sql
ERP DB
Generate CSV
files under output
directory
Email results to
administrator
Scheduler, or
Invoked by the Ariba
Data Transfer Tool
wrapper scripts
(ex: .bat or .shfiles)
13
©2009. Ariba, Inc. All rights reserved.
*Open Protocol
13
Directly upload data files to the Ariba On Demand Platform
Published details of HTTPS Post protocol used by Integration Toolkit

Relevant parameters are sent as MIME parts

File is sent in binary format

Reply contains standard HTTP codes: 2xx, 4xx or 5xx

Details of server exceptions are available in the body of the reply message
All integration events in the Toolkit also available via Open Protocol
Benefits
Provides flexibility of using corporate EAI tool
Better integration with process management and monitoring
* Ariba On-Demand Platform Only
14
©2009. Ariba, Inc. All rights reserved.
Web Services
Introduction
Abbreviation for “Web of Services”
A software component that is language, platform, and location independent
Excellent for exchanging transaction data such as Purchase Orders,
Invoices, Sourcing Projects etc.
Inefficient and slow for exchanging data in bulk such as a full load of users,
suppliers, accounting combinations, commodity codes etc.
Contextual Terms
WSDL: An XML document that describes the location and operations of a
web-service
SOAP: An XML-based protocol for applications to exchange information over
HTTP in a structured format
Ariba Web Services comply with all major standards
WS-Security: a communications protocol providing a means for applying
security to Web services
WS-Interoperability: An open industry organization chartered to establish
Best Practices for Web services interoperability
14
15
©2009. Ariba, Inc. All rights reserved.
Current Approach to Integration
Upstream Integration Flows
Ariba Strategic Sourcing
HR /
ERP
ERP /
MRP
ERP / PLM / PDM / SRM /
Legacy / Material Master
eProcurement/ Contract
/ Data warehouse
EAI / Middleware / Integration Toolkit
Customer
Web Services (XML / SOAP)
Export Event
results / Contract
Terms
Send Contract
Info
Create Event with Items /
Suppliers / Rules
UOM’s/ ForexRates
Commodity Codes
Regions/Depts
Add
Attachment
Users /
Suppliers
Integration Toolkit or Open Protocol
(On-Demand Platform)
Internet
Master
Data
Master
Data
Project *RFx
Auction
Event
AwardContract
* Applies to Sourcing & SPM Projects
and Contract & Supplier Workspaces
16
©2009. Ariba, Inc. All rights reserved.
Ariba Procurement
ReceiveRequisitionPurchaseInvoice / Pay
Master
Data
Budget
Data
Master
Data
BudgetCheck*
Requisition
Data
PO
Data
Financial Data (Accruals,
Remittance, Invoice)
Receipt
Data
Internet
EAI / Middleware / Integration Toolkit
ERP 1
ERP 3
ERP 2
Customer
Web Services (XML / SOAP)
Integration Toolkit or *Open Protocol
PO -New,
Change,
Cancel
Accruals
Receipt
Req.
Import
Payment
Request
Remittance
Current Approach to Integration
Downstream Integration Flows
* Ariba On-Demand Platform Only
17
©2009. Ariba, Inc. All rights reserved.
How do we deal with standard ERPs?
SAP
17
Transactional data
•End-to-End Integration
•Web Services Channel:
•Real Time Integration
•OOTB NetWeaver mapping
•File Channel:
•Batch Integration
•OOTB RFC mapping
SAP
Master data
•End-to-End Batch integration
•File Channel
•OOTB RFC Mapping
Ariba P2P
SAP NetWeaver XI / PI
SOAP
Request/
Response
SOAP
Adapter
OOTB
Mapping
RFC
Adapter
RFC
Request/
Response
Ariba Integration Toolkit
Data
Transfer
Tool
OOTB
Mapping
RFC
Adapter
RFC
Request/
Response
HTTPS
Web
Services
File
Channel
A M F
Supported Versions:
•4.7 R/3 Enterprise
•5.0 (My SAP 2004/NW2004/ECC5.0)
•6.0 (My SAP 2005/NW2004/EEC6.0)
18
©2009. Ariba, Inc. All rights reserved.
How do we deal with standard ERPs?
PeopleSoft
18
Transactional data
•Web Services Channel:
•Partial Integration
•OOTB Ariba Object Mapping
•EAI Mapping required
•File Channel:
•End-to-End Integration
•Batch Integration
PeopleSoft
Master data
•File Channel
•OOTB Mapping
•Batch Integration
Ariba P2P
EAI Tool
SOAP
Request/
Response
SOAP
Adapter
Required
Mapping
SOAP
Adapter
SOAP
Request/
Response
Ariba Integration Toolkit
Data
Transfer
Tool
OOTB
Mapping
DB
Connector
JDBC
HTTPS
Web
Services
File
Channel
A M F
Supported Versions:
•v8.8
•v8.9
•v9.0
19
©2009. Ariba, Inc. All rights reserved.
How do we deal with standard ERPs?
*Oracle
19
Transactional data
•End-to-End Integration
•** Web Services Channel:
•Oracle Fusion Interface
•Real time Integration
•OOTB Mapping
Oracle
Master data
•File Channel
•OOTB Mapping
•Batch Integration
Ariba P2P
**Oracle Fusion
SOAP
Request/
Response
SOAP
Adapter
OOTB
Mapping
SOAP
Adapter
SOAP
Request/
Response
Ariba Integration Toolkit
Data
Transfer
Tool
OOTB
Mapping
DB
Connector
JDBC
HTTPS
Web
Services
File
Channel
A M F
Supported Versions:
•v11i
•v12i
* Not yet available for Ariba On-Demand Platform
** Currently a future roadmap feature
20
©2009. Ariba, Inc. All rights reserved.
Questions?
20
21
©2009. Ariba, Inc. All rights reserved.
21
This is Spend Management