Title: ERP Integration
1ERP Integration
Rob SmithPre-Sales ManagerNew Era of Networks
North Europe
rob.smith_at_neonsoft.com
2ERP Integration - Agenda
- Why Integrate?
- What Integration Architecture?
- What can Sybase Offer?
- SAP Example
Open Business Interchange
3But, Firstly...
4ERP Integration - Agenda
- Why Integrate?
- What Integration Architecture?
- What can Sybase Offer?
- SAP Example
Open Business Interchange
5Problems Without Integration...
- Duplicate data entry
- Multiple user interfaces
- Out-of-step data
- Data errors
- Inability to obtain complete information
- Inefficient operation
Open Business Interchange
6...Problems Without Integration
- Poor customer service
- Long cycle times
- High costs
- Inadequate operational support
- Poorly informed management decisions
Open Business Interchange
7Couldnt We Just Re-write?
- Large investment in existing software
- Business depends on it
- Lack of knowledge and skills
- Long timescale
- High cost
- High risk
Open Business Interchange
8Business Integration Drivers
Globalization
e-Business
Corporate acquisitions
6. Web Integration
2. Mergers acquisitions
3. Customer relationship management
Your Suppliers
Your customers
1. Packaged application integration (ERP)
Your Company
4. Supply Chain
5. Straight-through Processing
Cost and cycle time
Competition Consumer power
9Enterprise PortalEP 2.0 e-Business
Infrastructure
- Comprehensive, integrated e-Business
infrastructure for streamlined global IT
operations - Scalable and available for 24x7 operations
- J2EE Application Server
- LDAP Directory Support
- Integrated Security
- Concept based Search
- Data Server
B2B Extensions
Enterprise Integration
Develop and Deploy Faster
10Sybase EP 2.0Foundation for e-Business
Web Users
Mobile/Wireless Users
Business Systems
Trading Partners
Net Markets
www
Enterprise Portal 2.0
e-Business Infrastructure
Enterprise Integration
Feeds
Documents
ERP/ CRM
Database
Mainframe
Custom
11ERP Integration - Agenda
- Why Integrate?
- What Integration Architecture?
- What can Sybase Offer?
- SAP Example
Open Business Interchange
12Point to Point Integration
General Ledger
Human Resources
Customer Relations
Supply Chain
SAP
Legacy Mfg.
Web Application
Logistics
56 Interfaces
13Critical Integration Issue
How can users substantially reduce theeffort
required to integrate the next built or bought
application?
ERP Deployment Level of Effort
14Point to Point Integration
General Ledger
Human Resources
Customer Relations
Supply Chain
SAP
Legacy Mfg.
Web Application
Logistics
56 Interfaces
15Point to Point Integration .
- complex core integration design
- high impact of changes to business practices
- high impact of additions to the business
- high cost of design, development and testing
skills
Hub and Spoke Integration Architecture Minimises
these Problems
16Integrating systems with an Integration Broker
General Ledger
Human Resources
Customer Relations
Supply Chain
Integration Broker
SAP
Legacy Mfg.
Web Application
Logistics
16 Interfaces
17Integration Broker Advantages
- higher speed to market of new products and
services - extended life of existing systems
- unrestricted use of new best of breed by
businesses - administrative efficiency
18The Need for Adapters
- Link applications to the integration architecture
- Import application formats to the broker
- Put application data onto queues
- Get application data from queues
19Essential Integration Capabilities
Application
Application
Application
P R O C E S S A U T O M A T I O N
Application
Move
Application
Route
Transform
Application
Enrich
Bridge
Application
Application
20ERP Integration - Agenda
- Why Integrate?
- What Integration Architecture?
- What can Sybase Offer?
- SAP Example
Open Business Interchange
21Sybase Brokers and Supporting Products
P R O C E S S A U T O M A T I O N
Total SolutionsProducts
Integration Brokers
Adapters Monitoring Security Validation Repair Con
version Tools Plug-in Libraries Services Training
Support
e-Biz Integrator - Designer - Rules -
Formatter e-Biz 2000 - MS environment
Powering the new economy
Support Enhance Integration Broker Delivery
Enterprise Portal
22Integration Designer
23e-Biz Integrator Processing
Produces a policy
Add a new application
Rule
Rule
Add a new rule!
Update target systems
e-Biz Integrator
In the right format
In the appropriate formats
24Process ServerBusiness Process Automation
XML
Process Server
Adapter
Commerce One
e-Biz Integrator
Adapter
Application Server
Enterprise Portal
BroadVision
Adapter
EDI
Adapter
Map Process Flow Within and Between
Enterprises Manage Runtime Execution of the
Process Monitor Business Process
Effectiveness Modify and Update the Process
25Our Adapters..
Business Packages
Enterprise Adapters
Terminal Adapters
- COBOL
- Database
- Flat Files
- 3270/5250
- VT220
- 26 others
- user defined
Adapter
Adapter
NEON Integration Broker
Protocols
Adapter
Other
- COM
- CORBA
- Java
- e-ADK
- e-Mail
B2B Standards
Adapter
Adapter
- EDIFACT
- XML
- S.W.I.F.T.
- FIX
- HL/7
26Sybase - The Total Integration Platform
Integration Brokers
Collaboration
Back Office SAP Oracle PeopleSoft JDE Seibel Le
gacy
Supply Chain i2 Manugistics Oracle SAP
Self Service Sybase Interwoven Vignette IBM BEA
Exchanges
Suppliers
Open Business Interchange
Wired
FIREWALL
FIREWALL
FIREWALL
Partners
Enterprise Portal
Enterprise Portal
Distributors
Logistics
Adapters
Wireless
Process Server
Business Process Accelerators
27Open Business Interchange Services
C1
- Self Service
- Configure
- Monitor
- Maintain
- Format Transformation
- NEON Formatter
- NEON e-Biz2000
- Message and mapping repository
- xCBL, cXML, RosettaNet, OAG, ebXML
- EDI, FIX, SWIFT etc.
- Custom
F I R E W A L L
Ariba
EAI
Open Biz
Oracle
Partners
Others.
- Send your format, protocol, and security and Open
Biz will deliver to your partner or exchange in
their format, protocol, and security
28Open Business Interchange Services
- Protocols
- SMTP/ POP3
- FTP
- HTTP/HTTPS
- MQSeries/MSMQ
- NEONEmq
- SOAP
- EDI VAN
- XPC
- BizTalk
- WAP/WML
- Our intent is to support all protocols
HTTP
HTTP
Back-end Processors/Mappers/Services
FTP
SMTP
POP3
Routing Service Rules Engines
FTP
OTI
OTI
Resources Agents
Response Agents
Queue Farm/Backbone
SQL
EB2K
XML
WWW
BIZ
CONFIG
HTTPS
Internet
29ERP Integration - Agenda
- Why Integrate?
- What Integration Architecture?
- What can Sybase Offer?
- SAP Example
Open Business Interchange
30Integrating SAP with...
Business Packages
Enterprise Adapters
Terminal Adapters
- COBOL
- Database
- Flat Files
- 3270/5250
- VT220
- 26 others
- user defined
Adapter
Adapter
NEON Integration Broker
Protocols
Adapter
Other
- COM
- CORBA
- Java
- e-ADK
- e-Mail
B2B Standards
Adapter
Adapter
- EDIFACT
- XML
- S.W.I.F.T.
- FIX
- HL/7
31SAP R/3 Structural Basics
- ABAP/4
- Specific object oriented programming language,
dynamically developed (Advanced Business
Application Programming) - Business Object
- The SAP business objects held in the Business
Object Repository (BOR) describe complete
business entities that encapsulate their data and
processes - BAPIs - Business APIs
- Methods by which processing applications
(external or internal) can access Business Objects
32SAP R/3 Structural Basics
- Function Modules
- Subroutines written in ABAP that process data
inside R/3. Developed in the Function Builder,
they are managed in a central function library,
and can therefore be called from any ABAP program
- Remote Function Calls (RFCs)
- Provide the transactional integrity
- The access through the application server
controls the correct data synchronization ?
database integrity - Calls are executed in the right order and within
the same program context
33BAPIs and Remote Function Calls
Active X C Class Lib Java Class Lib
RFC
- BAPIs are defined in the Business Object
Repository (BOR) as methods of SAP business
object types or SAP interface types and are
implemented as function modules - You can call the BAPI in the BOR using
object-oriented method calls - You can make RFC calls to the function module on
which the BAPI is based
34Application Link Enabling (ALE)
- ALE (Application Link and Enabling) is SAPs
technology to support business processes across a
distributed yet integrated environment - The IDoc is a SAP standard container/template
- Used to exchange data between any two processes
that understand the syntax and semantics, and
between a SAP system and an external application - IDocs are used in SAP R/3 both by EDI and ALE
- SAP provides standard tools for IDoc creation or
enhancement to support custom interfaces
35IDoc Screen
36SAP R/3 External Interfaces -
- GUI-based
- May be volatile from one release to another high
maintenance may be required - BAPI-RFC
- Safe and sure one may call the method (BAPI) or
the function (RFC) with the same consistent
results - IDoc
- EDI and ALE both use this vehicle. Very stable
- Batch Input
- Still has to obey formal SAP requirements. Very
good for massive asynchronous data uploads
37Integration Hot Points
- Support of multiple APIs
- Matching SAPs metadata definitions for message
brokerage - Future maintenance requirements (upward and
downward release stability/compatibility)
38Sybase Adapter for SAP R/3
- Works with the Integration Brokers
- Its components provide tools and functions that
- Extract SAP R/3 metadata into NEONFormatter
- Mitigate the asynchronous nature of MQSeries with
the synchronous nature of IDocs/BAPIs/RFCs - Put the control of data transformation,
enrichment, validation, mapping and routing in
the hands of the end-user - Supports all the main dialog processes
- ALE/IDocs, BAPI/RFC, DMI/Batch, ABAP Direct
39Sybase Adapter for SAP R/3 Architecture
SAP Meta data
Formatter Meta-data
Adapter Manager
Adapter
SAP
Sybase Integration Broker
ALE
IDoc
Other Systems
BAPI
RFC
RFC
ABAP
Inputfile
Batch in
DMI
40Adapter ManagerIDOC Management
41Adapter ManagerIDOC Management
42Sybase Adapter for R/3Summary
- All major SAP interfaces are supported
- SAP Certifications verifies the functionality
- The user interface makes the integration task
easy - No need for point to point legacy integration
coding - Adapter Manager is a single point of control
- Supports all SAP R/3 environments 3.1 and greater
43Sybase - The Total Integration Platform
Integration Brokers
Collaboration
Back Office SAP Oracle PeopleSoft JDE Seibel Le
gacy
Supply Chain i2 Manugistics Oracle SAP
Self Service Sybase Interwoven Vignette IBM BEA
Exchanges
Suppliers
Open Business Interchange
Wired
FIREWALL
FIREWALL
FIREWALL
Partners
Enterprise Portal
Enterprise Portal
Distributors
Logistics
Adapters
Wireless
Process Server
Business Process Accelerators
44ERP Integration Questions?
Rob SmithPre-Sales ManagerNew Era of Networks
North Europe
rob.smith_at_neonsoft.com