REP 707: Replication Server Product Futures

1. REP 707: Replication Server Product Futures Naveen Puttagunta Sr. Product Manager Naveen.Puttagunta@sybase.com August 15-19, 2004

2. AGENDA • Introduction • Review of Replication Server 12.6 • Future Roadmap • Demo

3. THE ENTERPRISE. UNWIRED.

4. The Enterprise. Unwired. Industry and Cross Platform Solutions Manage Information Unwire Information Unwire People • Adaptive Server Enterprise • Adaptive Server Anywhere • Sybase IQ • Dynamic Archive • Dynamic ODS • Replication Server • OpenSwitch • Mirror Activator • PowerDesigner • Connectivity Options • EAServer • Industry Warehouse Studio • Unwired Accelerator • Unwired Orchestrator • Unwired Toolkit • Enterprise Portal • Real Time Data Services • SQL Anywhere Studio • M-Business Anywhere • Pylon Family (Mobile Email) • Mobile Sales • XcelleNet Frontline Solutions • PocketBuilder • PowerBuilder Family • AvantGo Sybase Workspace

5. DATA MOVEMENT BUSINESS CHALLENGES • Business Continuity • Eliminate Downtime • Provide Continuous Service • Protect against Disasters • System Migration • Migration to Web, Legacy App/Platform migration • Deployment of new applications • Data and Transaction Synchronization • Application Data Availability across geographies • Application Data distribution to multiple systems • Coordinate Application Data between multiple systems

6. DATA MOVEMENT SOLUTION AREAS High Availability For Database Applications Customer Data Synchronization Disaster Recovery For Database Applications Data Consolidation Data Distribution Real-time Data Mart/Warehouse Population Legacy Data Migration and Synchronization New Application Deployment Reporting Servers

7. DATA MOVEMENT TECHNOLOGY USAGE SCENARIOS Data Consolidation Data Distribution Data Synchronization

8. OpenSwitch DR Site: Sacramento Site 1: SF (Order Entry) WAN OLTP Application ASE Rep Server ASE Standby DATA DISTRIBUTION FOR STANDBY & DISASTER RECOVERY • Disaster Recovery • Business Continuity

9. DATA DISTRIBUTION Site 2: New York (Sales) Rep Server Oracle Sales Decision Support Site 1: San Francisco (Order Entry) Site 3: San Francisco (Finance) WAN OLTP Application ASE Rep Server ASE Finance Reporting • Real time Data Mart • Reporting Servers • Application Deployment • Legacy Data Migration Site 3: Dallas (Manufacturing) Rep Server DB2 Decision Support

10. Site 2: Seoul (Production) Site 4: Boston (HQ) Seoul Application Oracle Rep Server Boston Reporting Application Site 1: Frankfurt (Production) Rep Server ASE Rep Server Frankfurt Application ASE Site 3: Mexico City (Production) Mexico Application DB2 Rep Server DATA CONSOLIDATION • Reporting Servers • Real time Data Warehouse • Application Deployment

11. DATA SYNCHRONIZATION Site 1: New York (Customer Service System) CSS Application Oracle Rep Server Site 2: Dublin (Engineering Bug Tracking System) Site 2: Dallas (Web Site) Rep Server DB2 Bug Tracking Application • Customer Data Synchronization • Distributed geographic apps • Distributed App over multiple systems Web Application Oracle Rep Server

12. Generic Benefits Isolated from Network Outages Independent of Central Server downtime Occasionally connected users Centrally managed, but distributed data Sybase Advantage High Performance Data Distribution and Consolidation Flexible Transformations Centralized Administration of complex deployments Distributed Architecture with guaranteed delivery Bi-directional synchronization across heterogeneous data sources Platform and Database independent BENEFITS OF REPLICATION

13. REPLICATION ARCHITECTURE

14. SYBASE DATA MOVEMENTREPLICATION SERVER • Sybase Replication server is a real time data movement product that provides • non-intrusive transaction capture • flexible transformation of data • Efficient routing across networks • Real-time synchronization across heterogeneous databases Primary Sites Replicate Targets • ASE • ASA • ASIQ Replication Agent Replication Server • Adaptive Server/Enterprise • Adaptive Server/Anywhere • Oracle • Microsoft SQL Server • DB2 UDB (Unix, NT, OS/390) • OS/390 (IMS, VSAM) • Informix • Oracle • Microsoft • DB2 • AS/400 • ODBC • Informix

15. Replication Server Base Server License Replication Server Manager Sybase Central Plug-in for Replication Server Replication Server Base Package Replication Server - Advanced Security Option Option for Oracle Option for Informix Option for Microsoft Option for DB2/UDB RA RA RA RA Replication Server Options Package DC DC DC DC ASE ASE ASE ASE REPLICATION SERVER PACKAGING • Base • Replication to and from Sybase ASE databases • Advanced Security • Enables SSL encryption between sites and/or between Replication Server and ASE • Heterogeneous Replication Options • Each option enables replication to and from the corresponding database

16. Standby DB Primary DB Connection Connection Replicate DB1 RS2 RS1 Add’l routes Replicate DB2 REPLICATION SYSTEM CONFIGURATION • System Configuration • Repservers manage connections to databases • Repservers exchange data via routes

17. Remote SAMPLE REPLICATION ARCHITECTUREGLOBAL, ENTERPRISE-WIDE DISTRIBUTION FOR A GLOBAL BANK’S TRADING SYSTEM Tokyo Reporting London Reporting Tokyo Trading London Trading Remote Remote Remote Chicago Trading Remote Accounting Risk Management Remote Chicago Reporting

18. OpenSwitch Replication Server Coordination Module Active DB Standby DB Queue REPLICATION SYSTEM ARCHITECTUREWARM STANDBY WITH OPEN SWITCH

19. Primary DB (e.g., Oracle) Rep Agent for Oracle RS Add’l routes/ connections Replicate DB (e.g., MS SQL) DirectConnect for MS SQL REPLICATION SYSTEM ARCHITECTUREMULTI-VENDOR REPLICATION & TRANSFORMATIONS • Replication Agents pull data out of non-Sybase sources • DirectConnects are used as gateways to replicate into non-Sybase targets • Support for vendor-specific datatypes, translations etc. • Some Replication Agents read the transaction log (DB2), some build a virtual log with triggers (Oracle, MS SQL) • Function Strings provide powerful transformational capabilities

20. CUSTOMER SUCCESS STORYOMRON CORPORATION • Provide its nationwide sales force with access of key enterprise information • Created a large, distributed database system using cutting-edge Sybase replication technology to maintain data integrity and consistency • Drastically reduce processing bottlenecks, enabling users to quickly and easily access the information they needed from a locally situated server. • Replication is used in various ways • Customer data is replicated bi-directionally between Omron's various sales branch servers (Data Synchronization) • Financial information is similarly replicated from top to bottom (Data Distribution) • Business leads are entered into the system by field-level sales personnel and funneled up through the organization from bottom to top(Data Consolidation)

21. CUSTOMER SUCCESS STORYGENERAL AMERICAN CORPORATION • GAC offers real-estate settlement services to financial institutions through a national electronic gateway • Needed a system that managed high volumes of data while simultaneously adhering to strict state regulations • Used Replication server for distributed systems and High Availability (Disaster Recovery) “Hurricane Irene wiped out two of our offices but we weren’t concerned because we’d never had a problem with Sybase’s replication technology and knew it was reliable. We didn’t lose any data during this disaster and it gives me peace of mind because I never have to worry about losing data.” • Norman Gottschalk, Vice President of IT for General American

22. CUSTOMER SUCCESS STORYMAJOR CREDIT CARD ISSUER • Call center needs DB availability • Customers seek immediate assistance when: requesting new cards, increasing credit limits, and applying for loans. • Database availability required for service rep to handle request • Sybase Replication Server synchs customer data • Collects data from heterogeneous sources (Data Consolidation) • Stores customer info in Sybase ASE, warm standby for HA (High Availability) • Achieved 99.95% database availability • Which contributed to customer acquisition and retention • The warm standby ensures fast failover, limits latency, and enables geographic dispersion. • The ROI of replicating customer data across customer-facing applications has become clear in terms of customer satisfaction and retention.

23. AGENDA • Introduction • Review of Replication Server 12.6 • Future Roadmap • Demo

24. REPLICATION SERVER 12.6 GOALS • Ease of Use and Reduce Complexity • Reduce Configuration Complexity: Multi-Site Availability • Reduce Operational Complexity: Embedded RSSD • Manageability Enhancements • GUI Enhancements • Open Switch Coordination Module • High Availability and Disaster Recovery • Performance Enhancements: SMP & Other • Storage Replication Support: Mirror Activator • Integration & Heterogeneous Environments • Real Time Services for Databases

25. REDUCING CONFIGURATION COMPLEXITYMULTI-SITE AVAILABILITY • Multiple copies of data allow quick deployment of warm standby, reporting copies, and backup copies for disaster recovery • Reduce expertise and skill level required to deploy replication services • Enables enterprises to better utilize existing data assets for their applications • MSA feature allows administrators to very quickly deploy a complete copy of the database to another site or sites • Individual publication and subscription of multiple objects no longer required • The entire database handled as a single object RS1 Active Standby-3 RS2 Standby-4 Standby-1 Standby-2

26. Replication Server 12.5 ASE RSSD REDUCING OPERATIONAL COMPLEXITYEMBEDDED RSSD • Embedded database for meta data, reduces number of components • Reduces operational management costs, reduces TCO • Easier to manage replication environments • ASE not needed for heterogeneous replication • Replication Server completely manages the embedded database • Startup, Shutdown, Recovery • Backups, Restore, Mirroring, etc. Replication Server 12.6 RS Queue ASA ERSSD RS Queue

27. OpenSwitch Replication Server Coordination Module Active DB Standby DB Queue MANAGEABILITY ENHANCEMENTSOPEN SWITCH – REPLICATIONCOORDINATION MODULE

28. HIGH AVAILABILITY & DISASTER RECOVERYPERFORMANCE – SMP • Continued concentrated focus on improving performance in each release • Replication Server is now multi-processor enabled • Scalability: Performance benefits with additional hardware • Benefits in Latency and Throughput of replication

29. Storage Resources Compute Resources Redundant Resources Site-Link HIGH AVAILABILITY & DISASTER RECOVERYSTORAGE REPLICATIONBUSINESS CHALLENGE • Needed: • Fast, cost-effective way to protect database transactions • Currently, the resources spent on Disaster Recovery (Site, Storage, Networking, etc.) are viewed as “expensive insurance” • Your business can’t afford to lose any transactions or be unavailable • Your business needs a way to leverage the resources at the Disaster Recovery site for reporting/query Disaster Recovery Site: Expensive Insurance Primary Site

30. HIGH AVAILABILITY & DISASTER RECOVERYSTORAGE REPLICATION SUPPORT • Sybase Mirror Activator works in conjunction with Disk Block Replicationto provide a standby DBMS • Works with EMC SRDF, IBM PPRC, Veritas Volume Replicator, NetApp SnapMirror, and Hitachi TrueCopy Data Device DBMS DBMS Mirror Activator Mirrored Log Device DB Storage (Data & Log) Log Device Block Replicator App Server App Server File System Storage File System Storage Web Server Web Server Primary Site Disaster Recovery Site

31. HIGH AVAILABILITY & DISASTER RECOVERYSTORAGE REPLICATION SUPPORT Mirror Activator reduces the cost and increases the utility of your current disaster recovery solutions • Reduces Cost: • Significantly reduces cost of database synchronous mirroring • Decreases network bandwidth requirements by as much as 50% • Reduces risk of corrupted data • Improves ROA: • Provides faster failover after failure • Ensures database continuity for both planned and unplanned downtime • Provides a read-only copy of the data that can be used for reporting, queries and analytics without impacting operational data

32. INTEGRATION & HETEROGENEOUS ENVIRONMENTSWHY REAL-TIME SERVICES A Major Ratings Institution When ratings change, proactively send information to Web applications Problem: Stale Data Customer Satisfaction Affected A Major Bank When a loan closes with deficiencies, proactively send information to downstream applications Problem: Delayed Actions Increased Inefficiencies A Government Institution When a passport is reported stolen or lost, proactively send information out to border security, airport security and police. Problem: Limited Awareness Increased Risk

33. INTEGRATION & HETEROGENEOUS ENVIRONMENTSHOW SYBASE DELIVERS REAL-TIME SERVICES Information Value Chain Capture Data Publish Data Enrich and Analyze Data Deliver data to Point of action Real Time Acquisition Service Real Time Data Service Real Time Process Service Real Time Delivery Service Operational ASE ASA Device based Sybase RTDS (Replication, ASE 12.5.2, JMS) Enrich Integration Orchestrator Biztracker Analyze IQ Q-Anywhere MobiLink

34. INTEGRATION & HETEROGENEOUS ENVIRONMENTSENABLING EXISTING APPLICATIONS Any Database to Any Message Bus • Capabilities • Non-intrusive • Heterogeneous Sources • Heterogeneous Message Bus • No Custom Coding ORDER ENTRY SYBASE SYBASE RTDS JMS, MQSERIES, TIBCO BILLING DB2 • Benefits • Eliminate ‘polling’ applications, reduce cost • Be proactively notified when changes happen, without coding • Zero impact on existing applications • Enable multiple applications Rep Server INVENTORY Rep Connector ORACLE

35. AGENDA • Introduction • Review of Replication Server 12.6 • Future Roadmap • Demo

36. MANAGEABILITY & EASE OF USE • Reduce Configuration Complexity • Simplify replication concepts • Modeling Tool support for replication topology and architecture design • Automated configuration deployment through modeling tool • Minimize deployment foot print – replication services well integrated into ASE • Capacity Planning Tools • Reduce administration complexity • Automate or simplify recovery procedures • Enhance fault tolerance characteristics • Automated fault management • Simplify Day to Day operations • Performance & Health Monitoring • Simplify monitoring and performance management • Event management & Enterprise management interfaces

37. AGENDA • Introduction • Review of Replication Server 12.6 • Future Roadmap • Demo