run your sap system best with sybase ase (for net new names)
TRANSCRIPT
Sybase ASE a strategic Choice for your SAP
Application
John Barnard
Technology and Innovation SAP UK
© 2011 SAP AG. All rights reserved. 2
Disclaimer
The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP. This presentation is not subject to your license agreement or any other service or subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation and SAP's strategy and possible future developments, products and or platforms directions and functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information on this presentation is not a commitment, promise or legal obligation to deliver any material, code or functionality. This presentation is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. This presentation is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this presentation, except if such damages were caused by SAP intentionally or grossly negligent.
All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.
© 2011 SAP AG. All rights reserved. 3
Agenda
SAP Data Management Vision
Sybase ASE Overview
Total Cost of Ownership
Customers
Sybase ASE for Business Suite Today
Migration
ASE + HANA
Conclusion
© 2011 SAP AG. All rights reserved. 4
Agenda
SAP Data Management Vision
© 2011 SAP AG. All rights reserved. 5
Jumpstart with current SAP database offerings DB components are optimized for specific use & with each other
BI, mobile clients, other consumption channels
HANA
Real-time analytics &
planning
ASE
Transaction
processing
IQ
Advance EDW
EDW, IQ based
apps
HANA
app 1...n App DW
(BW)
ERP, NW
1...n
Custom
app 1....n
Use cases: Custom & 3rd
party apps, traditional SAP
apps & NW components that need DB
Use cases: Real-time analytics,
new in-memory apps,
accelerated Business Suite processes
Use cases: IQ based
analytical apps, advance
data warehouse scenarios, nearline
storage for BW & HANA
Benefits: Mission critical
data applications
addressing extreme
reliability and performance
with a lower overall TCO
Benefits: Game-changing
performance advantages while
eliminating traditional data
layering redundancies with in-
memory platform
Benefits: Faster ad hoc
& complex business
answers to more users
while being able to
analyze all data across
the enterprise. Cost-
effectively manage critical
corporate data across
multiple data solutions
© 2011 SAP AG. All rights reserved. 6
Vision - HANA evolving as in-memory architectural framework Unified customer experience across administration, interface, programming model, runtime engines
Consumption channels (Mobile, Portal, Enterprise Workspaces)
ASE
custom
app
1....n
HANA
app 1...n App DW
(BW)
ERP
1...n
Advance
EDW, IQ
analytical
apps
Analytical
service
(HANA/IQ)
Transaction
service
(ASE)
SAP HANA framework
Customer Benefits
■ Game-changing business process
performance without traditional DB hurdles
(materialized layers/aggregates)
■ Application Layer to DB Layer – integrated
offering lowering complexity and cost
■ Faster time-to-value – rapid deploy
optimized appliances
■ Complete solution for Big Data
Database Service Layer (DBSL)
Planning &
optimization
service
(HANA)
Event
processing
service
(CEP)
Synchronization service
(Replication Server, Data Service, DB Triggers)
Data
tiering
service
(HANA/IQ)
BI
© 2011 SAP AG. All rights reserved. 7
Agenda
Sybase ASE for Business Suite
© 2011 SAP AG. All rights reserved. 8
Sybase ASE Trusted and relied upon by thriving global corporations
Source: Forrester Research Enterprise DBMS Wave, Q2 2009
30,000+ customers world
wide
90% of banks &
securities firms
1250 new customers
in 2010
97% customer
satisfaction rating
Leader in Forrester
DBMS Wave
#1 database on Wall
Street 3 years
running Waters, 2010
© 2011 SAP AG. All rights reserved. 9
ASE: Help Reduce Operational TCO for SAP Applications Capital Investment cost, operational costs, maintenance efforts
19% lower operational cost
vs Oracle running
applications such as
billing…etc.
50% less effort on average for
DBAs to maintain ASE, with Sybase ASE Control Center
Management & diagnostic
tools
Partitioning functionality
Require no security patch
updates; can save as much as
1-2 DBAs
* Mich Talebzedah
47% savings in capital
investment costs (license
& annual support)
74% said that ASE offers
lower support payments
than Oracle
2.5 1 Sybase
DBA* Other
DBA
© 2011 SAP AG. All rights reserved. 10
Sybase ASE: Strategic Transactional Database for SAP
Applications
OPTIMIZED FOR SAP APPLICATIONS Storage optimizations
Text management efficiencies
Embedded administration
INCREASED VALUE TO SAP CUSTOMERS Integrated product releases with synchronized updates
Lower total cost of ownership (TCO)
Single source for support, maintenance, lifecycle management
MARKET PROVEN 30,000+ customers including 46 of 50 Top Global Banks
Double-digit growth in mature market (22% YoY CY 09)
Best enterprise data management vendor on Wall Street three years running (Waters Magazine); Leader in Forrester DBMS Wave (2009); Awarded “Most Successful Database Software Vendor in China” in 2010/11
© 2011 SAP AG. All rights reserved. 11
ASE Cluster Edition
Scale Out
As part of HA solution
Benefits of SAP Business Suite on Sybase ASE Adaptive Server Enterprise – Optimized Platform TCO
Storage and memory optimization
Storage compression
Advanced text and large object management
Advanced Database Administration
Advanced DBA Cockpit
Reduced administration effort
Best-Of-Breed Replication
Heterogeneous multi-site replication
Publish-Subscribe paradigm
Some items in planning phase
Integrated Database Monitoring
Sophisticated database monitoring
Enhanced tuning options
© 2011 SAP AG. All rights reserved. 12
Monitoring Infrastructure for Sybase ASE
DB Monitoring
DB Perf.
Warehouse
CCDB
E2E Alerting
DB Admin.
DBA Calendar
• DBA Cockpit offers in-
depth insight into ASE’s
detailed monitoring data
• Short and long term
history to analyze
performance changes
• Integration of
administration tasks into
the DBA Cockpit
• Leading DB integration
into the SAP Solution
Manager
SAP/ASE
Monitoring
Backend
DB
A C
ockpit
Solu
tion M
anager
DBA Cockpit offers
• Access to ASE’s detailed
monitoring information
• Short term (2 weeks)
history of relevant
monitoring data
• WebDynpro UI
• Monitoring of ABAP/Java
and non-SAP systems
DBA Cockpit offers
• Access to ASE
configuration
• Administrative Tasks can
be done from the SAP
System
• Change Log for
configuration changes
done inside the DBA
Cockpit
Database Performance
Warehouse
• Integrated into the DBA
Cockpit
• Stores long-term
performance data
• Using BI for data analysis
Configuration Change DB
• Keeps track of
configuration changes of
the SAP System
• Full integration of Sybase
ASE configuration
E2E Alerting
• Sybase ASE’s error
messages and warnings
are integrated into the
E2E Alerting in the SAP
Solution Manager
• Allows DBAs to easily
monitor system
landscapes and work on
DB issues proactivly
DBA Cockpit offers
• Scheduling of regular DB
administration Tasks
• Automated Table
Maintenance
• …
© 2011 SAP AG. All rights reserved. 13
Monitoring Infrastructure for Sybase ASE
DB Monitoring
DB Perf.
Warehouse
CCDB
E2E Alerting
DB Admin.
DBA Calendar
• DBA Cockpit offers in-
depth insight into ASE’s
detailed monitoring data
• Short and long term
history to analyze
performance changes
• Integration of
administration tasks into
the DBA Cockpit
• Leading DB integration
into the SAP Solution
Manager
SAP/ASE
Monitoring
Backend
DB
A C
ockpit
Solu
tion M
anager
© 2011 SAP AG. All rights reserved. 14
Agenda
Total Cost Of Ownership (TCO)
© 2011 SAP AG. All rights reserved. 15
Sybase ASE
SAP contributes to lower overall TCO in significant ways (1/2)
• SAP provides the „DBA Cockpit“ with integrated Monitoring &
Administration Tools for an easier database administration.
• The DBA Cockpit is fully remote enabled and allows database
management even if SAP System is down.
• Database Performance Warehouse in SAP Solution Manager
provides full insight in database performance and its history.
• ASE allows Dynamic Configuration for several parameters. This
avoids unnecessary downtimes of the database for customers.
• Flexible Backup & Restore Methods available. Support of Filesystem
and Tape Devices. Integration with Storage Managers.
Administration – SAP‘s DBA Cockpit and
Solution Manager
Automation
• Integrated Scheduler allows automation of several routine
administration tasks and reduces workload for DB Administrators.
• Automatic Storage Management available.
© 2011 SAP AG. All rights reserved. 16
Sybase ASE
SAP contributes to lower overall TCO in significant ways (2/2)
• Integrated E2E Alerting enables fast identification of the root
cause of a problem.
• SAP Early Watch Alert provides pro-active Alerting of
potential Issues which not yet appears.
• SAP provides 24 x 7 Support .
Support
• Integration to Tivoli in Runtime included.
• Compression Functionallity in Runtime included.
• Data Tiering through Partioning
• With 8 % License Fee on SAV (Software Application Value) SAP
offers attractive license fees
Commercial
Architecture
• ASE Architecture requires less hardware resources compared to
e.g. an Oracle environment.
© 2011 SAP AG. All rights reserved. 17
Platform Teams SAP Sybase Integration Center
ASE Platform Team:
SAP employees Sybase employees
SAP employees
Integration Center Team:
Sybase employees
Close collaboration beetween
Sybase and SAP teams
Sybase Development Lab Dublin
SAP Development Lab St. Leon-Rot
© 2011 SAP AG. All rights reserved. 18
SAP Back-Office &
SAP Development Support
SAP Center of
Expertise
Sybase
Product
Support
Sybase Product Engineering
SAP / Sybase ASE Support
SAP performs 1st and 2nd level support duties for SAP on Sybase ASE
• SAP is first customer contact
• SAP Support provides solution to customers
SAP Support integrates Sybase Product Support organization
Direct interaction with Product Engineering
• Minimizes time to solution and friction loss
Services provided by CoE
Support Channel
Sybase
Product
Support
ASE Client ASE Server
Support Integration
© 2011 SAP AG. All rights reserved. 19
Agenda
Customers
© 2011 SAP AG. All rights reserved. 20
$29M Operational cost
saving by migrating
to ASE
45% Reduction in
support calls, 35%
reduction in DBA
hours
40% Performance
improvements over
other databases on
same platform
What Customers Achieved with ASE Superior performance, Reduction in TCO, Lower maintenance
*72% of customers find ASE product attributes to be strong, very strong and exemplary
*Performance, reliability and scalability are among the highest-rated attributes
© 2011 SAP AG. All rights reserved. 21
Enterprise-class Deployments
Customer ASE Deployment
BlueCross BlueShield of
Tennessee
5 terabytes of data with 3,200 concurrent users per day ; 23, 700
transactions/second on highest volume database
Indian Railways 16 million transactions per day
National Center for Genome
Resources
14 terabytes of genetic data
Bombay Stock Exchange 4 million trades / day, networked to 400 cities; the world's 5th in
transaction numbers
China Ministry of Railroads 1,500 ASE servers in 40+ locations, transporting 17 million customers/day
Passport Canada Up to 100K transactions per minute on most active database, 9TB
database that grows 2TB per year
BNP Paribas Up to 10K transactions per minute
Misys/Summit 3M INSERTS per 30 minutes
Curian Capital & Curian
Clearing
850K trades per day (a trade constitutes multiple transactions)
Deutche Bank Benchmark ASE running 30 engines, 62 GB RAM(on 64 core box with 128 GB of
memory) processed 2.3 Million trades in 26 minutes using 29 concurrent
streams
© 2011 SAP AG. All rights reserved. 22
Agenda
Sybase ASE for Business Suite Today
© 2011 SAP AG. All rights reserved. 23
Sybase ASE for SAP – Key Dates and Customers
Ramp-up started in July
Supported Applications (by December 2011): SAP ERP 6.05
SAP CRM 7.01
SAP SRM 7.01
SAP SCM 7.01
SAP NetWeaver 7.02
SAP NetWeaver 7.30
SAP Solution Manager 7.1
SAP NW BW 7.3
SAP NW Portal 7.3
SAP NW CE/CAF 7.3
SAP PI 7.3
Supported operating systems HP-UX 11.31 on IA64 64bit
Windows Server 2008 R2 x64
RedHat EL6 on x86_64 64bit
SuSE SLES 11 SP1 on x86_64bit
AIX 7.1
Solaris on Sparc 10
Reference Case
el-Machetazo
Reference Case
Sybase IT
Reference Case
SAP IT – Field Services
© 2011 SAP AG. All rights reserved. 27
Information Sheet I3P – 1/3 “Fact Sheet“
Application Release Info
System I3P
Application PPM 5.0
Platform NW 7.02
MaxDB ASE
15.7
Components Versions
Multi-Resource Service
Scheduling -
Workforce Management -
Portfolio & Resource
Mgt. CPRXRPM 5.0
System Key Data
System I3P
Coverage Global
Named Users
Concurrent Users ~13.000
~300
System OLA 98,3%
System Size ~200 GB
System Setup 5tier
• I3P is SAP‘s Global Project and Portfolio Management
System for SAP Field Services
• I3P is The First SAP/ASE System in Production (Oct 30th)
General Availability (GA) for Adaptive Server Enterprise for
SAP Business Suite is planned for end of November.
• DB Server: Linux OS on Intel Architecture
4 CPU‘s à 4 cores with 64 GB Memory
• Database compression in place Support via Component BC-
DB-SYB
• SDN information on Link
© 2011 SAP AG. All rights reserved. 28
Information Sheet I3P – 2/3 “Performance“
transactional cases complex cases mass-data
res
po
ns
e t
ime
s in
se
co
nd
s
Project specific performance test cases
© 2011 SAP AG. All rights reserved. 29
Information Sheet I3P – 3/3 “DBA Cockpit“ I3D DBA Cockpit
Note: we use the DBA Cockpit/ASE to enable NetWeaver Admins to perform the majority of tasks of a DB Admin w/o further training.
© 2011 SAP AG. All rights reserved. 30
Agenda
Migration
© 2011 SAP AG. All rights reserved. 31
Migration
200+ DB Migrations in past 24 months
OS/DB Migration practice as part of SAP Consulting (ITTS)
30+ Migration Specialist trained as part of SAP Consulting
HP rapidly ramping up, 1st training sessions completed
EMEA Partner Training (planned Nov)
Migration Guide
GO LIVE in less than 5 weeks -> Rapid Deployment Solutions (RDS) Package
© 2011 SAP AG. All rights reserved. 32
Consulting Service Offerings: Overview
Platform Assessment Service
Analyze Customer Situation, Determine Requirements, Develop Action Plan
Sandbox System
(POC)
Perform Standard
Installation
RDS offering
New System
Landscape
Perform Standard
Installation of SBX, DEV,
QAS, PRD Systems
RDS Offering
Preliminary Services:
Complementary Services:
Data Migration Technical Landscape
Integration
Performance Optimization Virtualization
Decommissioning Test Management Database Admin Training
System Merge
…
System Migration
Upgrade to Minimum Software Level (EHP 5,
Netweaver 7.02) if necessary
OS-DB Migration
PoC
RDS Offering
OS-DB Migration
Prod. Landscape
RDS Offering
IMIG / NZDT
Prod. Landscape
Customer-
specific estimate
1.
2.
3.
© 2011 SAP AG. All rights reserved. 33
Agenda
Sybase ASE and SAP HANA
© 2011 SAP AG. All rights reserved. 34
SAP HANA with SAP ERP on Sybase ASE
Technical Landscape
* Rapid Deployment Solutions
SAP Business Objects
4.0/Mobile
Real-Time
Replication
SAP HANA Appliance
In-Memory Modeling Studio
MS Office
Frontend
SAP ERP RDS for operational reporting
with SAP HANA*
SAP ERP RDS for profitability analysis
with SAP HANA*
SAP Rapid
database migration
to Sybase Adaptive
Server Enterprise*
© 2011 SAP AG. All rights reserved. 35
MANAGE
MANAGE INFORMATION
Replication Server
Designed for Global Data Distribution and Disaster Recovery Use Cases Optimized for Heterogeneous Databases
Access data sources
Sybase ASE and CE
Sybase SQL Anywhere
Sybase IQ
Oracle
Microsoft SQL Server
IBM DB2
ASE
SQL Anywhere
Sybase IQ
Oracle
Microsoft
DB2
Replication Agent for Heterogeneous Sources
Direct Connect for Heterogeneous Targets
Real-time Events for Message Buses
IBM MQ
TIBCO RV
JMS
1 Primary Site
2
Sybase Replication
Remote or Secondary Sites
3
WAN
4
5
6
NOTE: Rep Agent & Direct Connect not required when connecting to
Sybase sources/targets
Sybase Products
© 2011 SAP AG. All rights reserved. 36
Agenda
Conclusion
© 2011 SAP AG. All rights reserved. 37
Why Sybase ASE Short and Long Run Business Value
o Scalability, Performance DB Challenges
Top 46 of 50 Global Banks use Sybase ASE
o Lower Total Cost of Ownership
Operational Cost Reduction, Compression, Opportunity Cost Reduction
o ASE + HANA
Investment Protection
Consolidate – reduce complexity, further TCO reduction
Close Operational + Analytical GAP