September 9–11, 2013Anaheim, California

SAP’s Commitment to Open Data Access Strategy for BI

Henry KamSaskia Battersby

Legal 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 in this document is not a commitment, promise or legal obligation to deliver any material, code or functionality. This document 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 document is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP´s willful misconduct or gross negligence.

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.

3

SAP BusinessObjects

Commitment to open

Commitment to diverse technology landscapes continues to be a priority

4

Investments

Agnostic Roadmap on SMP

Product Investments

New data sources

Partnership Announcement

5

Support for Oracle OLAP

Support for Salesforce.com

Open, agnostic, and unified

EnterprisePortals

MS OfficeOn Demand ServicesBrowsersMobile Devices

ERPSAP Business Suite

Oracle E-Business Suite

PeopleSoft

JD Edwards

Unstructured data in Social Media and Hadoop

OLAP Cubes

Embedded Content

MS ExcelOracle, IBM DB2, Microsoft SQL Server and other relational data sources

Semantic LayerSemantic Layer

Business Intelligence PlatformBusiness Intelligence Platform

EDWSAP NetWeaver BW

Teradata

Other data warehouses

SAP HANA Platform

SAP HANA

Self-ServiceSelf-Service Dashboards and AppsDashboards and Apps ReportingReporting

7

Unified Data Access Strategy – Before

Inconsistent Data Access coverage

Different client tools accessed data differently

8

Unified Data Access Strategy - Now

Single Version of the Truth via Semantic Layer

Centralized Data Access support via new Semantic Layer

Salesforce.com and SAP ERP Data Access centralized in Universes

SAP BusinessObjects Semantic Layer

Common business concepts for all front-ends Common business concepts for all front-ends

Web Intelligence, Crystal Reports, Dashboards, Explorer, Lumira, Predictive Analysis, SDKs*

Empower all people, enable all workflows

Empower all people, enable all workflows

All data sources All data sources

SAP BW OLAP Any RelationalDatabase

HadoopFiles, Web services,

ODBC, JDBC

SAP HANA Sybase

Connect to all data sources

Connect to all data sources

Best access method for each specific data source Best access method for each specific data source

Direct AccessDirect Access Universe AccessUniverse AccessHigh performance,

feature rich secure access

High performance, feature rich

secure access

Empower business users with the autonomy they need to access, analyze, enrich, and share information freely and securely using

familiar business terms

Low TCO BW Access in BI 4.0

Crystal Reports

Web Intelligence

Xcelsius

UniverseBICSBAPI

MDX

Crystal Reports, Web Intelligence, Dashboards, Design Studio and

Analysis

Before: Silo’ed connectivitiesin SAP BusinessObjects XI 3.1

After: Unified direct BICS accessin SAP BusinessObjects BI 4.0

BICS

SAP NetWeaver BW

BEx Query

InfoProviders

SAP NetWeaver BW

BEx Query

InfoProviders

Universe semantic layer authoring Java SDK

Allows developers to programmatically:• Create universes• Customize universes• Deploy universes• Administer universes• Automate universes

Universe Designer (.UNV)• Universe COM SDK for .UNV still available• Applications written in XI 3.x COM SDK still

supported

12

SAP NetWeaver BWSAP ERPSAP HANASAP MaxDBSybase SQL AnywhereSybase, Adaptive Server EnterpriseSybase IQSAP EPM BPC (Business Planning and Consolidation)EPM PCM (Profitability & Cost Management)EPM SSM (SAP Strategy Management)EPM FC (Financial Consolidation)SAP Data Federator

Supported SAP Data Sources for Universes

Supported Non-SAP Data Sources for Universes

13

Options to support additional data sources

14

Conditionally Supported database platforms

Standards-based drivers, vendor-supported ODBC or JDBC drivers

Standards-based Driver Support

Standards Based drivers must comply with the following design guidelines: Database server, Client and ODBC/JDBC driver

used must support multiple threads. Vendor-supported drivers:

ODBC drivers must be ODBC Level 2-compliant

ODBC driver must support multiple connections (for IM products only)

JDBC drivers must be JDBC Type 4-compliant In case of issues, to get support the

customer is requested to attempt to reproduce issue by reference: For ODBC on SQL Server For JDBC on MySQL

15

Support for new agnostic sources in 4.1

New non-relational sources• oData 2.0 data sources• XML files • Web services with WSDL 1.1 (SOAP)

New relational sources• Oracle Exadata• Teradata 14• Hive on Amazon EMR (Elastic MapReduce)• DB2 10 for zOS via JDBC, DB2 for zOS 10.1, DB2 LUW 10 & 10.1,

DB2 for i v7.1• Sybase ASE 15.7• Oracle via ODBC (in addition to OCI and JDBC)• PostgreSQL 9, MS SQL Server 2012, Greenplum 4.1 & 4.2

New SSO support• HANA through SAML• Teradata• Sybase IQ

oData Support

SAP is part of the group that created the oData standard• Along with MSFT and IBM• Open data protocol = a Web protocol for querying

and updating data

There are 2 sides to oData• oData consumption: access an oData compliant

data source• oData provisioning: expose a data stream as oData

oData roadmap for Semantic Layer• oData consumption: available in 4.1• oData provisioning: will be supported in the

upcoming SL consumption SDK

oData consumption in BI 4.1 - a new connectivity

The oData connection is defined in the information design tool The designer can author a UNX universe against an oData service The oData access is available to client tools supporting UNX universes

• Crystal Report Enterprise• Web Intelligence• Dashboard• Explorer• Mobi

New Universe Consumption SDK

Beyond BI 4.1 - Open universe semantic layer consumption

Universe Consumption SDK will allow partners to:• Build custom Universe query panel and embed it

anywhere• Expose Universe metadata within custom

application• Integrate Universe queries directly into custom

applications

Architecture• SDK sends Universe query request as XML to BI

platform• Application receives query data back in oData

format

Platforms we consider beyond Data

Operating Systems (Windows, RedHat, SUSE, AIX, Solaris)

Browsers (Internet Explorer, FireFox, Chrome, Safari)

Application Servers (Jboss, NetWeaver, Tomcat, WebLogic, WebSphere)

Portal Servers (Netweaver Enterprise Portal, WebLogic Portal, WebSphere Portal, Sharepoint)

LDAP (Tivoli, AD, eDirectory, Internet Directory, Sun Java System Directory)

Reverse Proxy

Server/Desktop Virtualization

20

21

Customer Demand Market Share of solution Analyst opinions Emerging Industry trends

Big Data Social Sentiment Analysis Web based data SaaS and Cloud data

How we evaluate and Expand our sources

Future Considerations

22

Connect to social, ‘big’ and web based data

HP Vertica

Google Big Query

Amazon RedShift

Cloudera Impala

Thank you for participating.

Please provide feedback on this session by completing a short survey via the event mobile

application.

SESSION CODE: 8890

Learn more year-round at www.asug.com