Strategic Replication & Integration:
SAP Sybase Replication Server
Speakers Name/Department TBD
Month 00, 2013
The Need for a Comprehensive Data Asset Strategy
Beyond Disaster Recovery (DR)
Data is the most valuable asset for organizations,
necessitating:
Access to all data, wherever and however its stored
Current, consistent data across the organization
Real-time data available everywhere
But most IT systems cant meet these needs due to:
Organizational changes resulting in multiple, heterogeneous
data sources
Lack of integration leaving data isolated in incompatible
formats
Poor replication resulting in unsynchronized and often
unavailable data
2013 SAP AG. All rights reserved. 2
SAP Vision: Replication & Integration as
Part of the Real-time Data Platform
A comprehensive data management strategy encompasses both
replication and integration to meet critical business requirements,
such as the need for:
Real-time, 360-degree views of the business across heterogeneous data sources
Support for multi-site operations with a common data infrastructure and localized
applications
End-to-end support for business processes across heterogeneous platforms and
applications
2013 SAP AG. All rights reserved. 3
Traditional vs. Strategic Approaches
to Replication & Integration
Traditional: Point solutions and proprietary tools
Basic ETL, triggers, and updates
No accommodation for other source and target databases
Data stuck in siloes
Very difficult to manage, with a tangle of sources and targets
Strategic: SAP Sybase Replication Server
Real-time and asynchronous replication and integration
High-performance integration with multiple heterogeneous data sources
Centralized, graphical, and intuitive model-driven management
2013 SAP AG. All rights reserved. 4
Centralized Replication & Integration
Easy to Manage, Model, and Extend
Organizations administer all replication and integration activity through
one centralized capability
All replication and integration go through SAP Sybase Replication Server
SAP Sybase Replication Server directly replicates data between SAP Sybase ASE
databases
Replication agent delivers data from primary Microsoft SQL Server, DB2, and Oracle
databases to SAP Sybase Replication Server
2013 SAP AG. All rights reserved. 5
SAP Sybase Replication Server Differentiators
High performance
Delivers data with near-zero latency, and without impacting other systems
Change data capture (CDC) supports real-time analytics reporting
Flexibility
Centralized bi-directional data replication among heterogeneous endpoints
Supports SAP Sybase ASE, SAP Sybase IQ, IBM DB2, MS SQL Server, and
Oracle
Reliability
Continuous data delivery
Near real-time failover to DR sites with minimal data loss
Proven in more than 2,600 implementations, including the demanding financial
services sector
Low TCO
Off-the-shelf product offers streamlined, predictable, and timely deployment
Centralized administration and visual configuration tools simplify administration
Scales readilyfrom gigabytes to terabytes
2013 SAP AG. All rights reserved. 6
Sharing Information Across Sybase and Oracle
Use case: Indian Railways National Train Enquiry System (NTES)
Real-time Challenge
Real-time access to dynamic schedules of 6,000 trainsacross 9,000 stations
Access
Multiple data sources to track
Results
Automated, fast, and reliable bi-directional data movement
6,000 trains Efficient data transfers among heterogeneous databases
across 9,000 stations
Web access for information systems
1.2 million transactions per day
24/7 system uptime for more than eight years
Multiple Data
Sources
Sybase technology was ideal for our situation because of its flexibility to integrate with databases from
Oracle and Microsoft as well as the reliability of its replication.
Suneeti Goel, Associate GM CRIS
2013 SAP AG. All rights reserved. 7
Saving Big Money on Data Movement
Use case: Cargill, Incorporated
100,000 Challenge
transactions per day Decentralized database systems requiring 100,000 transactions per day
across remote across remote locations
locations Inefficient, costly, and high-risk processes
Results
Decentalized Reduced annual IT operating costs from $42 million to $13 million
Database Real-time delivery of information to all locations
Systems Transition completed with virtually no impact on system operations
$29M savings in
annual IT operating
costs
As we explored our options, we concluded that Sybase replication technology was clearly superior to other
available products.
Don Nielsen, Manager, Database Administrator Group, Grain Division, Cargill, Incorporated
2013 SAP AG. All rights reserved. 8
Turning Disparate Systems into a Unified Solution
Use case: State of Pennsylvania Courts
5.6 million court Challenge
cases in 100 More than 5.6 million court cases in 100 different systems
different systems No ability to access or exchange information
High security risk and low operating efficiency
Results
High Security
Single, automated approach to case processing
Risk
Seamless delivery of information anywhere, anytime
Significant improvements in public safety, unification of data, and the ability
to share information
Access to a wide variety of court functions for more than 8,000 users
8,000 users
agencies are evaluating their ability to exchange data in a timely manner. By 2010, the promise of an
integrated justice community may be achieved.
Administrative Office, Pennsylvania Courts
2013 SAP AG. All rights reserved. 9
SAP Sybase Replication Server
The Leader in Database Replication
Strategic data Unmatched Proven in more
asset management performance, than 2,600
with centralized, flexibility, reliability, deployments
heterogeneous and TCO
replication and
integration
1 2 3
2013 SAP AG. All rights reserved. 10
Strategic Replication & Integration:
SAP Sybase Replication Server
Thank you
Contact information:
F name MI. L name
Title
Address
Phone number