Oliver Szimmetat Principal PM Manager Office Holger Bruchelt Product Manager Gateway Agenda SAP Gateway for Microsoft Introduction Demo Office Addin Development Introduction Excel addin for SAP GWM ID: 293557
Download Presentation The PPT/PDF document "SAP Gateway for Microsoft" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1Slide2
SAP Gateway for Microsoft
Oliver Szimmetat,
Principal PM Manager, Office
Holger Bruchelt
Product
Manager
GatewaySlide3
Agenda
SAP Gateway for Microsoft
Introduction
Demo
Office Add-in Development
Introduction
Excel add-in for SAP GWM
Architecture
DemoSlide4
SAP Gateway for MicrosoftSlide5
With SAP Gateway for Microsoft, we have again developed a joint technology that delivers more value for our mutual customers:
For 20+ years,
mutually focused on our mutual customers
Why Microsoft and SAP?
5
Jointly develop programs and products
Establish cross-company relationships
Understand each other’s operations
1 billion users can now access their SAP data by using Microsoft Office
Business users can now get their data on the go with SAP apps on Windows mobile devices
For decades,
SAP and Microsoft have worked together to:
35,000+ customers can now run their
SAP apps
on Microsoft Azure
1B+
35k+Slide6
INTEROPERABILITY
for Enterprise Applications
MOBILITY & INDUSTRY
SAP Apps on
Windows Mobile Devices
CLOUD
Real-time SAP on
Microsoft Azure
PLATFORM &
INFRASTRUCTURE
for Lower TCO and Higher ROI
SAP data on Microsoft Windows, to run your business better, anytime, anywhere
Rapid, flexible, and cost-effective real-time SAP in
the Microsoft Azure cloud
Reliable, high-performing Microsoft platforms for
optimal SAP value
HIGH COST
OF OWNERSHIP
•
LACK OF AGILITY •
INCONSISTENT DATA • LOW PRODUCTIVITY
Fast, efficient SAP access using familiar Microsoft tools
200m Microsoft users can now access their SAP data through Office tools.100,000+ customers can now run their SAP apps on Microsoft Azure.New SAP Mobile for Windows programme available nowCustomers
Benefits
Innovations
ChallengesOur strategy and investment areas together:Slide7
Is an interoperability framework for secure integration between SAP and Microsoft technologies. It enables the rapid creation of solutions that allow users to access SAP data from their preferred Microsoft application.
Simplify productivity
Introducing SAP Gateway for Microsoft
7
~25%
Back office
business systems
use SAP
Business Users
use Microsoft Office
~90%Slide8
SAP User Experience Strategy
Usage/reach
Existing Applications
RENEW
ENABLE
New
New Applications
UX Design Services
SAP Fiori UXSlide9
SAP
Fiori
App Types
Run on:
Exceptions
apply
for
Financials and MRP
Selected apps
were downported
For
SAP Smart Business, consider «HANA side car» approach as long
as you
are not running
Suite on HANA
Run on:Run on:
Transactional
Task-based Access
Access to tasks like change, create, or approve processes with guided navigation
InsightsVisual overview of a dedicated topic for further KPI related analyses
AnalyticalFactsheet
Search and ExploreView essential information about objects and contextual navigation between related objectsRun on:Run on:Run on:
Try it out: https://demo-fioritrial.dispatcher.hana.ondemand.com/Slide10
Demo
Contoso MotorsSlide11
Office add-insSlide12
Office Add-Ins (a.k.a. Apps)
Extend
the functionality of Office with an add-in that lives within Office applications.
An
add-in runs inside an Office
application
Works with Access, Excel, Word, PowerPoint, Outlook and Project
.Interacts with the contents of an Office document using our rich JavaScript API.
Runs on Office 2013, Office Online, mobile devicesSlide13
Manifest + webpage = an Office add-in
The manifest specifies:
URL of the webpage (UI)
Display name, description,
ID, version
Default locale
Permission level
Data access requirements
Display modeFor documents: Task pane/In contentFor mail items: Reading/composingSlide14
The webpage can be published to any web server or web hosting service (e.g. Azure)
The manifest must be published to:
the
public Office Store,
an
internal SharePoint list, or
a shared network locationManifest + webpage = an Office add-inSlide15
Office add-in
Task paneSlide16
Office add-in
In contentSlide17
Manifest - example
<?xml version="1.0" encoding="UTF-8"?>
<!--Created:cb85b80c-f585-40ff-8bfc-12ff110e34a9-->
<
OfficeApp
xmlns="http://schemas.microsoft.com/office/
appforoffice/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="TaskPaneApp"> <Id>e57a32a9-958a-4579-809f-df1a22a64751</Id>
<Version>1.0.0.0</Version> <ProviderName>Microsoft</ProviderName> <DefaultLocale>
en-US</DefaultLocale> <DisplayName DefaultValue="SAP Integration" /> <Description
DefaultValue="SAP Integration"/> <IconUrl
DefaultValue="https://sapintegration.azurewebsites.net/Images/SAP_Icon_32.png" /> <AppDomains
> <AppDomain>https://sapdatademo.azurewebsites.net</AppDomain> <AppDomain>http://sapdatademo.azurewebsites.net</AppDomain> <AppDomain>https://login.windows.net</AppDomain> <AppDomain>https://login.microsoftonline.com</AppDomain> </AppDomains> <Capabilities> <Capability Name="Workbook" /> </Capabilities> <
DefaultSettings> <SourceLocation DefaultValue="https://sapintegration.azurewebsites.net/pages/home.aspx" />
</DefaultSettings> <Permissions>ReadWriteDocument</Permissions></OfficeApp>Slide18
Office add-ins: Client support summarySlide19
ODataSlide20
RESTful data access protocol
Version 4
standardized at Organization
for the Advancement of Structured Information Standards (OASIS
)
Rich metadata support. $metadata query provides information on:
Data structureData typesRelationships
Open Data Protocol - ODataSlide21
OData
REST commands
For CRUD
(create, read
update, delete)
operationsSlide22
Demo
Workflow approval add-inSlide23
Excel add-in for SAPSlide24
Excel add-in for SAP
Allow users to access SAP data in Excel
Sorting, filtering, reporting…
Support multiple platforms (Office, Office Online, Office for iPad)
Support CRUD operations on SAP data
Slide25
Add-in architecture
SAP Gateway for Microsoft (hosted in Azure)
Odata
endpoint
Helper functions (
DataReader
/
DataWriter
), Web UI
Odata
Custom APIs (JSON)
Helper functions (data, navigation, authentication, formatting,
error handling)Slide26
Parsing metadata from SAP Gateway for Microsoft
GetTables
–
gets all entity sets, including:
Table name
Headers
Entity type nameKeyProperties typeGetMetadata
– retrieves meta-dataGetProperties – all the properties for a given entity type
GetHeaders – column headers for a given entity typeGetTypes – all
the column types for a given entity type
GetKey – the key column for a given entity typeSlide27
Excel helper functionsSlide28
Demo
Excel add-in for SAPSlide29
Resources
SAP Gateway for Microsoft
http://
www.
sap
.com/pc/tech/collaboration.../microsoft
-interoperability/Odatahttp://www.odata.org
Office Dev Centerhttps://dev.office.com/ Slide30
Visit
Myignite
at
http://myignite.microsoft.com
or download and use the
Ignite
Mobile
App
with
the QR code above.
Please evaluate
this
sessionYour feedback is important to us!Slide31