Getting Started With Integration E159

1
E159Getting Started With Integration
Heather Kawamoto Product Manager E-Business
Division Heather.Kawamoto_at_sybase.com
2
Agenda

• Todays Business Environment
• Integration Challenges
• Sybases Integration Solution
• Smaller Scale Solution Defintion
• Step by Step Implementation Options
• Cost Evaluation
• Summary and Questions

3
Todays Business Environment

• Huge Organizational Changes
• Mergers and Acquisitions
• Downsizing and re-organizations
• Financial Pressures
• Slowing Economy
• All IT projects carefully evaluated must have
  full ROI
• Increased collaboration with partners and
  suppliers
• Slowing adoption of new technology use it when
  its proven somewhere else

4
Business Requirements

• Process improvement
• Reduce cost of materials/procurement
• Reduce cost of sales

Improve Profitability

• New markets, channels, geographies
• Innovative business models
• New products, competitive responsiveness

Competitive Agility
Customer/ Supplier Loyalty

• Easier to do business with
• Prompt accurate information for partners and
  customers
• Externally-facing applications

5
Integration Business Challenges

• Computing infrastructures are constantly changing
• Organizational efficiency and customer
  satisfaction achieved by prompt, accurate
  responses driven by accurate data
• Partners and Suppliers outside the firewall want
  to communicate
• Solutions must be scalable
• Return on Investment must be proven
• Everyone is talking BPM how does that relate?

6
Integration Technical Challenges

• Computing infrastructures are constantly changing
• Individual departmental solutions may create a
  problem integrating the integration solutions
• Individual projects must support a larger
  enterprise integration vision
• Point-to-point integration coding is
  time-intensive, costly and hard to maintain
• Multi-generational systems result in data in
  different formats
• Increasing need for solutions to manage business
  processes

7
Sybase e-Business PlatformComprehensive,
Modular, Integrated and Open
Enriching B2B Interactions
Empowering Your Enterprise
Enabling Your Customers
Trading Partners
Customers
Enterprise
Access
Power Designer
Enterprise Portal - Web Mobile Access
Integrate
Process Server
Integration Server
Web Services
Biz Tracker
Application Adapters
Develop
Transact
Application Server
Business Intelligence
Replication
Database
Java IDE
Metadata Repository - Configuration Security -
Install - Management
SYBASE e-Business Platform
8
Sybase e-Business PlatformSupport for Web
Services

• Simple Web Services
• Defined as UDDI, WSDL, SOAP
• Supported through
• EAServer
• PowerDesigner

• Collaborative Web Services
• Defined as B2B, RosettaNet, ebXML
• Supported through
• Web Services Integrator
• OpenBiz

9
Sybase e-Business Platform
Access
Power Designer
Enterprise Portal - Web Mobile Access
Integrate
Process Server
Integration Server
Web Services
Biz Tracker
Application Adapters
Develop
Transact
Application Server
Business Intelligence
Replication
Database
Java IDE
Metadata Repository - Configuration Security -
Install - Management
SYBASE e-Business Platform
10
Integration a Coding Nightmare!
General Ledger
Human Resources
PeopleSoft CRM
SAP
Supply Chain
Siebel
Web Application
LegacyMfg.
56 Interfaces
11
Integration a Centralized Approach
General Ledger
Human Resources
PeopleSoft CRM
Supply Chain
E-Biz Integrator
SAP
Siebel
Web Application
LegacyMfg.
8 Interfaces
12
Integration Dept by Dept Approach

• Start small grow over time
• Lessen the financial risk prove ROI with a
  lower initial investment
• Develop an understanding of Sybase technology
• Structure to accommodate additional components to
  support Business Process Monitoring (BPM) and/or
  Business Activity Monitoring (BAM)

13
New Era of Networks Solution

• This sucks but nice idea.
• Provides tools for system integration
• Modular approach solution
• Part of strategic e-Business platform
• Provides tools for quickly defining the
  connection with popular applications, systems,
  mainframes and network technologies
• Reduces implementation time reduced
  implementation cost
• Highly scalable and reusable
• Improves the productivity of resources
• Increases flexibility

KILL
14
Dept By Dept Option 1
Custom Application
Siebel
SAP
Phase 1
Phase 2
E-Biz Integrator
PeopleSoft
Legacy System
AccountingSystem
15
Dept By Dept Option 2
SAP
Siebel
Legacy System
E-Biz Integrator
E-Biz Integrator
PeopleSoft
Connect Brokers from 2 Departments!
AccountingSystem
Supply System
16
Basic Integration Components

• Integration Server (commonly called a Broker)
  New Era of Networks e-Biz Integrator
• Adapters to enable connectivity to end systems
• Message Transport system

17
Integration Server e-Biz Integrator
e-Biz Integrator
Solaris
HP-UX
Integration Server
Application
Application
e-Biz Integrator
Direct API
MQSeries
Rules Formatting Engine
NT
AIX
Open Transport
Application
Rules Formatting Metadata
Application
MSMQ
TIBCO RV
18
Integration Servers Core Services

• Parsing and Transformation Converting data
  from one format to another based on platform,
  standards or internal applications.
• Rules and Routing Content based routing -
  determines what to transform and when, and where
  to deliver the resulting transformed data.
• Open Transport Support for industry leading
  data transport mechanisms.

19
Integration Server Message Flow

• Message is parsed
• Rules are evaluated
• For each rule hit, a set of actions are executed
• Format
• User Defined
• Output

20
e-Biz Integrator Overview

• e-Biz Integrator well suited for
• Enterprise-class integration solutions
• High throughput requirements
• Complex business rules
• e-Biz Integrator can be used with all New Era of
  Networks adapters
• Through Open Transport supports all major
  transports
• Contains Visual Tester to support testing of rules

21
Integration Engine e-Biz Integrator Benefits

• Routes and transforms messages based on its
  content
• Eliminates the costs associated with supporting
  multiple communication infrastructures
• Offers the ability to make transformation,
  routing, and adapter changes in a higher- level
  development tool
• Provides a component- based development
  environment that allows adapters, transformations
  and routing rules to be reused in multiple
  integrations
• A repository for messages and transformation/routi
  ng logic, and a where used utility.

22
Adapter Value
Interfacing versus Integration...
e-Biz Integrator does the interfacing. The
adapter does the integration.
General Ledger
Order Entry
Adapter
Adapter
e-Biz Integrator
Application Interface
Application Interface
No programming required !
23
Adapters Why and How?

• Need a way to connect to end points
• Complex systems like Siebel, PeopleSoft, SAP
• Legacy Mainframe systems
• Custom Internal Applications

24
What is an Adapter?

• Non invasive way to integrate systems
• Adapters query the target to discover the
  target meta-data
• Data entry and exit points to the integration
  server
• Contain intelligence about the applications, e.g
  SAP, PeopleSoft, Siebel
• Adapters can provide pre-/post-processing of data
• Adapters can bridge synchronous and a-synch
  technologies

25
Complex Coding Requirements
Interfacing versus Integration...
Interfacing requires programmatic knowledge of
how the applications really work.
Order Entry
General Ledger
I have to program this !
26
Adapters Design Time Run Time
Design Time Module
Adapter Manager GUI
Schema load
Metadata Repository
Run Time Module
SAP R/3 PeopleSoft Siebel DatabaseXML
DTDsCOBOL etc.
Acquire data
Integration Broker
Deliver data
27
New Era of Networks Adapters

• Financial Adapters
• SWIFT
• FIX

• Technology Adapters
• Databases
• Flat Files
• XJS/390 - OS/390
• XML
• Terminals
• EDI
• E-mail (SMTP/POP3)
• Protocols
• FTP
• TCP/IP
• LU6.2
• ODBC

• Application Adapters
• SAP R/3
• Siebel
• PeopleSoft
• XJS/390 - OS/390
• Adapter Development Kit

e-Biz
28
Adapter Benefits

• Faster legacy integration from pre-packaged
  integration points
• Application-aware technology Less technical
  knowledge required by users for each application
  link
• Single point of maintenance for application
  integration
• Ease of use Single development environment for
  all adapter configuration and customization
• Application Meta-Data discovery

29
Value Proposition Dept By Dept
Ability to achieve project-based
application-to-application integration while at
the same time establishing a strategic enterprise
cross-platform framework that simplifies future
integration.
Elimination of hand-coded project integration
saves TIME MONEY
30
Financial Savings

• No need to build an interface to an EIS
• Update and maintenance savings
• When systems update formats change you can
  modify formats in one place and ALL integration
  points are updated
• Maintenance occurs at a central point
• Open architecture lets you leverage existing
  systems and transports
• Most obvious fewer connections code
  development and maintenance savings

31
Possible Sybase Solutions

• If a Department by Department approach to
  integration interests you check out the
  following Sybase products
• New Era of Networks Integration Package
• New Era of Networks e-Biz Integrator
• New Era of Networks adapters
• For connection directly with a J2EE application
  server New Era of Networks Adapters for
  Application Servers

32
A Few Integration Customers
33
Questions