E159 Getting Started With Integration

1. E159Getting Started With Integration • Heather Kawamoto • Product Manager • E-Business Division • Heather.Kawamoto@sybase.com

2. Agenda • Today’s Business Environment • Integration Challenges • Sybase’s Integration Solution • Smaller Scale Solution Defintion • Step by Step Implementation Options • Cost Evaluation • Summary and Questions

3. Today’s 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 Enabling Your Customers Empowering Your Enterprise Enriching B2B Interactions Trading Partners Customers Enterprise Access Power Designer Enterprise Portal - Web & Mobile Access Integrate Process Server Biz Tracker Integration Server Application Adapters Web Services Develop Transact Java IDE Application Server Business Intelligence Replication Database Metadata Repository - Configuration Security - Install - Management SYBASE e-Business Platform

8. Power Designer Enterprise Portal - Web & Mobile Access, Openbiz Process Server Biz Tracker Integration Server Application Adapters Web Services Java IDE Application Server Business Intelligence Replication Database Metadata Repository - Configuration Security - Install - Management SYBASE e-Business Platform 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 Biz Tracker Integration Server Application Adapters Web Services Develop Transact Java IDE Application Server Business Intelligence Replication Database Metadata Repository - Configuration Security - Install - Management SYBASE e-Business Platform

10. Integration – a Coding Nightmare! General Ledger Human Resources PeopleSoft CRM Supply Chain SAP 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 Open Transport AIX Application Application Rules & Formatting Metadata 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/routing logic, and a “where used” utility.

22. Adapter Value Interfacing versus Integration... e-Biz Integrator does the interfacing. The adapter does the integration. Order Entry General Ledger 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. Application Interface Application Interface 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. Formats Meta Data 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