SAP Real-time Data Platform. April 2013

(1)

SAP Real-time Data Platform

April 2013

(2)

Agenda

 Introduction

 SAP Real Time Data Platform Overview

 SAP Sybase ASE

 SAP Sybase IQ

 SAP EIM

 Questions and Answers

(3)

Introduction

 Sid Sipes

 Director, Data Warehouse Solutions & HANA Platform

 SAP Solutions Management

 Joined SAP in 2010

 Via Sybase Acquisition in

 Joined Sybase in 1995

 Sybase IQ Specialist

 Data Warehouse Specialist

 Responsibility is to grow SAP Indirect Channels

(4)

SAP Evolution

Core ERP + Suite

1990s 2012

LoB Apps Industry Apps Innovations RDS

2008

BI/Analytics

Core ERP + Suite

2010

BI/Analytics

Core ERP + Suite Technology

/ Database Mobility

Cloud

2011

(5)

The Big Challenge Big Opportunity

BUSINESS NEEDS

Emergence of Social Business, Geospatial data,

and Event Data

Multi-Channel Experience (Mobile Experience)

Quick insights and right action from huge amount of

Data

Trust in Quality &

DATA CHARACTERISTICS Exploding data volumes

Increasing data variety and sources including social,

machine generated

Accelerated data processing velocity

TECHNOLOGY TRENDS

Storage / Memory / CPU Advances

In-memory computing

EDW / Distributed MPP / Hadoop

Data Mining/Predictive analysis

Real-time Data Access and

(6)

How we get there… SAP Real-Time Data Platform

Unified Data Management Platform for real time business

SAP RTDP Foundations

● Cross-application data management

& access for new models of value discovery.

● High-performance on all classes of application and usage scenarios

Benefits

● Store, analyze, optimize, transact and mobilize without system limitations.

● Embrace and extend across variations of data forms and processing models.

● Common modeling, integrated development environment, shared

systems management infrastructure and deployment independent solutions.

● Trusted and unified data environment.

Business Intelligence

Mobile &

Embedded

* Information management solutions include: SAP Data Services Enterprise, SAP Enterprise Master Data Management, SAP NetWeaver Information Lifecycle Management, SAP Enterprise ECM solutions by OpenText, SAP Sybase Replication Server

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase SQL Anywhere

mobile & embedded

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

SAP Data Services

Information management*

Common programming APIs

SAP Sybase PowerDesigner modeling SAP Sybase Control Centermonitoring

Hadoop Big Data Transactional

OLTP

Analytics OLAP

(7)

SAP Real-time Data Platform

Guiding principle – no disruptive migrations

Non-disruptive migration process: key features

● Bidirectional data replication: a SAP HANA version of an application can coexist with a version running on another RTDP server

● Complete and accurate information: unified information management to model, integrate, cleanse, monitor, and govern a variety of data

● Common standards: including guarantees such as high availability and disaster recovery as well as programming APIs, make development of new applications simpler

● Common tooling: provides a consistent experience to IT staff handling migration.

SAP Sybase IQ

SAP Sybase ASE

SAP Sybase SA SAP HANA

SAP Real-time Data Platform

(8)

At the Core: SAP HANA

Analytics OLAP

Mobile &

Embedded

SAP RTDP Foundations

● SAP HANA is a disruptive in-memory data management platform, demonstrating a

breakthrough in big-data analytic performance.

● Customers use SAP HANA to gain “real real- time” business insights into massive amounts of data

Benefits

● Make Decisions in Real-time. Access to real time Analysis; fast and easy creation of ad-hoc business statistics

● Accelerate Business Processes. Increase speed of information processes such as planning, forecasting, pricing, offers…

● Unlock New Insights. Remove constraints for analyzing massive data volumes, trends, data mining, predictive analytics…,Structured and unstructured data

● Improve IT Efficiency. Manage growing data volume and complexity with lower cost of ownership

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

Hadoop Big Data

* Information management solutions include: SAP Data Services Enterprise, SAP Enterprise Master Data Management, SAP NetWeaver Information Lifecycle Management, SAP Enterprise ECM solutions by OpenText, SAP Sybase Replication Server Transactional

OLTP

(9)



At It’s core, HANA is:

– A Relational Database Management System – All Data “In-Memory”

– Uses Standard ANSI-92 SQL (with extensions)



Interfaces include: ODBC, JDBC, MDX, etc



“Real Real-time” performance for huge data volumes



Delivered as a vertically

integrated appliance

via SAP HW partners



Fastest growing product

in SAP’s 40-year history

What is SAP HANA?

Speed

Scale

Flexibility

(10)

Revolutionary In-Memory Platform

Eliminate Redundant Layers; Breaking the Transactional & Analytical Divide

(11)

In-Memory Computing – The Time is NOW

Orchestrating Technology Innovations

HW Technology

Innovations

64bit address space – 2TB in current servers

100GB/s data throughput Dramatic decline in price/performance

Multi-Core Architecture (8 x 8core CPU per blade)

Massive parallel scaling with many blades

One blade ~$50.000 = 1 Enterprise Class Server

Row and Column Store

Compression

Partitioning

No Aggregate Tables

Insert Only on Delta

The elements of in-memory computing are not new. However, dramatically improved hardware economics and technology innovations in software have now made it possible for SAP to deliver on its vision of the Real-Time Enterprise with in-memory business applications

SAP SW Technology

Innovations

(12)

In-Memory Computing Product “SAP HANA”

SAP High Performance ANalytic Appliance

SAP HANA SAP

Business Suite

SAP BW

3rd Party

replicate

ETL

SAP HANA modeling Business

Applications

SQL MDX BICS

3rd Party

What is SAP HANA?

 SAP HANA is a pre-configured appliance that includes in-memory data management software bundled with hardware

 Includes tools for data modeling, data and life cycle management, security, operations, etc.

 Provides support for multiple interfaces

HANA’s Capabilities

 Analyze information in real-time at

unprecedented speeds on large volumes of non- aggregated data.

 Create flexible analytic models based on real- time and historic business data

 Foundation for new category of applications (e.g., planning, simulation) to significantly outperform current applications in category

 Minimizes data duplication

(13)

Cloud

SAP’s Business Strategy

Business

Suite

(ERP)

Business

Analytics

(BO, BW)

mobile

Data platform

(SAP RTDP With HANA)

HANA is at the heart of

# 1, world wide market

share, 2010

# 1, world wide market share, 2011

Gartner magic quarter leader

HANA Fastest growing SAP

product ever 15m paying

cloud subscribers

(14)

Capability: OLTP/Transactional

SAP Sybase ASE, SAP HANA

Analytics OLAP

Mobile &

Embedded Transactional

OLTP

SAP RTDP Foundations

● Customer choice with SAP HANA and SAP Sybase ASE.

● High-performance and optimized

performance on all classes of application and usage scenarios

Benefits

● One data management platform

● Integrated application and data management.

● Accelerate most critical applications with SAP HANA.

● Optimize performance with SAP Sybase ASE.

● Secure and scalable

● Rock-solid reliability

● Superior performance

● Lowest TCO

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

(15)

30,000+

customers world wide

90%

of banks & securities firms

1,250

new customers in 2010

700 New Bus Suite on ASE 2012

97%

customer satisfaction rating

Leader

in Forrester DBMS Wave

#1

database on Wall Street

3 years running

Waters, 2010

SAP Sybase ASE

Trusted by Thriving Global Corporations

(16)

27%

in IT staffing

28%

in operations

50%

in maintenance

Sybase Adaptive Server Enterprise

A way to help customers and hosting partners save

(17)

Fast Growing Companies Succeed with ASE

Powering rapid expansion for the lowest cost

37% Savings after migrating from Microsoft SQL Server

"Performance of database transactions and queries was poor, and it was affecting

business, CPU utilizations were high, and we were running short on memory, with

poor input/output performance. Our business was growing rapidly, and we were

concerned about the incumbent application's scalability and how that would affect

us in the future."

– Dan Swartz, President, SubscriberMail

Reduced DBA hours by 35% and increased CPU efficiency by 30%

“The Sybase upgrade has given us a very stable production system. This is the key

operational system at Trimac … ASE delivered the benefits we expected in terms of

consistent performance and easy maintenance. We are very happy with it.“

(18)

Benefits of ASE

Not much has changed with the SAP Sybase

ASE value proposition



Better Performance and Scalability



Reliable Business Continuity



Flexible Cost Management

SAP Has invested Tremendous Amounts of

Money, Time, and Engineers into ASE

SAP Sybase ASE is the “Standard” RDBMS for

SAP Business Suite and BW (ERP)



Overshadowed by HANA



2x more Suite on ASE in Q1 2013

– 400 ASE vs 160 HANA

(19)

Capability: Enterprise Data Warehouse

SAP Sybase IQ, SAP HANA

Analytics OLAP

Mobile &

OLTP

SAP RTDP Foundations

● SAP HANA – Real Time Agile Data Mart.

● SAP Sybase IQ – PetaByte Scale EDW

Benefits

● Turbocharge recent data reporting in SAP HANA

● SAP Sybase IQ economically scales to large amounts of data and supports data- intense reporting while controlling costs

● Open customer choice for performance and price/performance

● Automatic movement of data between SAP HANA and SAP Sybase IQ

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

(20)

SAP Sybase IQ – What is it?

Sybase IQ is a Relational DB System

Developed by Expressway Technologies (~ 1993)

Sybase Acquired Expressway in 1995

SAP Acquired Sybase in 2010

Sybase IQ was designed specifically for Data Warehousing

Has the look and feel of a typical RDBMS

But under the covers it bears little resemblance

Speed

Scale

Flexibility

(21)

75%

in IT staffing

80%

in Hardware

50%

in maintenance

Sybase IQ

A way to help customers and hosting partners save

(22)

2,400+

customers world wide

Guinness ^BOWR

Most Data Ever Loaded into a

Database

4,500+

Unique Installations

More than all Competitors Combined

200+

new customers per year

Leader

in Gartner Magic Quadrant

#1

Analytic Database

Waters, 2012

SAP Sybase IQ

Trusted by Thriving Global Corporations

(23)

SAP Sybase IQ Facts

Sybase has Sold/Deployed IQ since 1995

2100+ Customers Worldwide



4500+ IQ Installations Running Live

Bigger Install Base than Competitors

 Teradata – 1000 Customers

 ExaData – 1000 Installs

 Netezza – 500 Installs

 Vertica -- 500 Customers

 GreenPlum -- 400 Customers

 ParAccel -- 40 Customers

Double Digit Growth (Sales Volume) for IQ Every Year

More Installs than ALL OTHER Column Stores Combined

(24)

SAP Sybase IQ Fun Facts

SAP Sybase IQ is in Guinness Book of World Records

Most Data Ever Stored in a Data Base



1 PetaByte of Input Data



Actual Stock Market (Tick) Data



Required 250TB for Storage (75% Compression Ratio)

There are Bigger Production Installations



Government



Load Rates of 3-5TB Per Day

SAP IQ positioned in Leaders quadrant for Data warehouse DBMS



SAP Sybase IQ Earns Leader Status for the 3rd Straight Year

(25)

SAP Sybase IQ:

Designed for Speed and Efficiency

A highly optimized Analytics Server, designed specifically to deliver ultra-high-

speed business intelligence and reporting on standard hardware and operating

systems.

IQ is a “Columnar Store” Database



Designed from the start for analytics – not transactions



Unsurpassed query performance



Lowest Total Cost of Ownership for analytical applications



Column-based structure and patented indexing



Gartner Group’s Magic Quadrant

(26)

The SAP Sybase IQ Database Engine

IQ is a Relational DB System



Looks, feels and acts like a traditional RDBMS

– To Developers, Appears as standard ANSI compliant

RDBMS

– To Users, appears as a very “FAST” RDBMS



Difference is Speed and Compression

– 1HR Traditional RDBMS Query – 1 Minute IQ – 1TB Traditional RDBMS is about 100-300GB IQ

Designed from Ground UP to meet these

goals…



Load Data Fast



Query Very Fast



Store Data Efficiently



Work with Common OLAP and ETL tools

(27)

Advantages of IQ

IQ Value Proposition still the same



Analytics/Reporting Performance

– 10x to 100x Performance of Traditional OLTP RDBMS



Enterprise Data Warehouse

– Now Scales to Petabyte Size – Look for new GBOWR soon



Inexpensive

– Runs on Cheap Commodity Hardware

– Better Performance than Appliances, 1/5 cost

SAP Continues to Invest in IQ



HANA Technology in IQ 16



IQ Technology in HANA

(28)

Capability: Business Intelligence/Analytics

Mobile &

Embedded

SAP RTDP Foundations

● Rich Analytics with Business Objects BI Analytics Suite

● Complete BI suite

● Professional grade platform

● Core for innovation

Benefits

● User Friendly Experience

● Designed for All Users

● Open Technology Platform

● Operates in heterogeneous environments

● Market Leadership

● number one overall

● Visionary

● Broad Adoption

 >5 M users of SAP Crystal Reports software

 >3 M users of SAP BusinessObjects Web Intelligence

● Vibrant Partner EcoSystem

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

SAP Sybase PowerDesigner modeling SAP Sybase Control Centermonitoring

SAP Data Services

Data Federation Transactional

OLTP

Analytics OLAP

(29)

Capability: Big Data Performance

SAP Sybase IQ, SAP HANA, Hadoop

Analytics OLAP

Mobile &

OLTP

SAP RTDP Foundations

● Data and query federation with Hadoop and SAP Sybase IQ

● Text analysis for SAP Sybase IQ and SAP HANA

● MapReduce for SAP Sybase IQ and SAP HANA

● Hadoop ETL via SAP Data Services

Benefits

● Enhanced performance and expanded support of big data sources

● Accelerated sentiment intelligence and text mining across all relevant data sources with a high-level of quality

● Integration of current and big data

environments for application processing

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

Text /unstructured data

(30)

Capability: Query Federation

Business Intelligence Transactional

OLTP

SAP RTDP Foundations

● Query federation between DB’s

● SAP Sybase ASE to SAP HANA

● SAP Sybase IQ to SAP HANA

● SAP SQL Anywhere to SAP HANA

Benefits

● Infrastructure that offers the develop once and deployment anywhere flexibility.

● All data stores benefit from the

superlative in-memory performance and ensuing simplification translating to simpler and iterative application design models

● Optimize performance without any application changes

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

SAP Data Services

Data Federation Analytics

OLAP

Mobile &

Embedded

(31)

Capability: Real-time Replication

SAP Sybase Replication Server

SAP RTDP Foundations

● Real-time replication for non-SAP scenarios from systems built on SAP Sybase ASE and Oracle Databases.

● Operational business intelligence substantially improved through multi- source data input and analytics

Benefits

● Quickly analyze data from transactional systems

● Automatically create systems of

decisions in real-time and EDW stores

● Easily build high availability / disaster recovery systems across the RTDP.

Analytics OLAP

Mobile &

OLTP

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

SAP Sybase Replication Server

information management

(32)

Capability: Comprehensive Data Services

SAP Data Services (EIM)

Analytics OLAP

Mobile &

OLTP

SAP RTDP Foundations

● Bulk load data (ELT or ETL) into SAP HANA with SAP Data Services

● Perform data assessment, text data processing, and ensure quality before or within data stores

Benefits

● Common policies to know when data is fit for use

● Enhanced performance of data loading, cleansing, de-duplication, and

enrichment

● Combined data (unstructured and structured) for new contextual insights

● Complete and trusted data for

applications and accurate analytics

In-memory/real-time

SAP HANA

SAP Real-time Data Platform

SAP Sybase ESP

streams

SAP Sybase IQ

EDW

SAP Sybase ASE

transactions

SAP Data Services

(33)

Summary

1 SAP has a comprehensive data management vision and strategy to

address your 21

^st

century business issues

2 SAP is delivering on the Real-time Data Platform for next generation

customer applications

3 SAP and Sybase customers have a clear path to reduced complexity and

non-disruptive innovation

(34)

Questions?

(35)