Skip to Content

SAP Gateway for Microsoft Self-Paced Learning

What is SAP Gateway for Microsoft?

SAP Gateway for Microsoft is an interoperability framework from SAP that leverages SAP Gateway and Microsoft technologies enabling customers and partners to easily and quickly compose solutions that consume and extend SAP throughout Microsoft technologies for on premise and on demand deployment.

Visit the Introductory Blog Announcing GWPAM on the SAP Service Marketplace

SAP NetWeaver Gateway productivity accelerator for Microsoft

How does SAP Gateway for Microsoft Self-Paced Learning work?

The SAP Gateway for Microsoft Self-Paced Learning has been developed for customers, partners and SAP consultants. You may want generic information or a technical deep dive on what SAP Gateway for Microsoft offers you as a Business User or as a Solution Developer. Through a series of recorded presentations and demos, you can get in-depth training based on your interest and learning pace. Simply click on related links in each track applicable to what you want to learn.


There are a series of 4 Tracks to choose from:

Track 1: SAP Gateway for Microsoft Overview

Track 2: SAP Gateway for Microsoft for Solution Developers

Track 3: SAP Gateway for Microsoft for Business Users

Track 4: SAP Gateway for Microsoft Security and Supportability

Track 1: SAP Gateway for Microsoft Overview

Audience: General & Technical
Level:        Beginner/Intermediate
This track is intended for anyone new to SAP Gateway for Microsoft.
LessonLinkDescription
Lesson 1: SAP Gateway for Microsoft Product Features

Video (9:46 min)

Get a quick overview highlighting the value and features of SAP Gateway for Microsoft. This Interoperability framework enables IT to deliver SAP Business Solutions into Microsoft products, driving business value.
Lesson 2: SAP Gateway for Microsoft Service Pack 02 -- Now available!BlogWhat's new for SAP Gateway for Microsoft Service Pack 02?
Lesson 3: SAP Gateway for Microsoft Installation Use CasesDocumentGet an overview of the installation process of SAP Gateway for Microsoft. You will find information on prerequisites, where to find the SW and which SW needs to be installed on which computer.

Track 2: SAP Gateway for Microsoft for Solution Developers

Audience: Technical
Level:        Beginner/Intermediate
This track is intended for developers creating SAP Business Solutions for Microsoft products.  It is broken down into 5 Categories:

Microsoft Visual Studio Add-in for Outlook Solutions

Microsoft Visual Studio Add-in for Excel Solutions

Microsoft Visual Studio Add-in for C# Solutions

Extending functionality of a SAP Gateway for Microsoft Project

LessonLinkDescription
Getting Started
Lesson 1: Visual Studio Add-in InstallationVideo (5:00 min)Learn how to install the SAP Gateway for Microsoft Visual Studio Add-In.
Lesson 2: Introduction to OData

Video (17:50 min)

SAP Gateway for Microsoft consumes SAP Gateway OData services. For those unfamiliar with OData services, this session covers the OData Standard and how it works, covers how OData is structured and how SAP leverages OData in SAP Gateway.

For developers who want access to sample SAP Gateway OData Services , please sign up for access to an online demo-system using the following link: SAP Gateway Demo System .

Lesson 3: Browse SAP Services

Video (7:08 min)

Explore the functionality, features and sample data of SAP Gateway OData services directly in Microsoft Visual Studio.  This feature is especially helpful for developers who may not be familiar with OData services or SAP Gateway but need to find an OData service to build their solution.

Microsoft Visual Studio Add-in for Outlook Solutions
Lesson 4: Outlook Contact Template

Video (9:47 min)

Learn how to use the Contact Project Template of SAP Gateway for Microsoft to create a C# Microsoft Visual Studio project to retrieve and update SAP Contacts using Microsoft Outlook Contacts as the UI.

Lesson 5: Outlook Appointment Template (Calendar)

Video (9:00 min)

Learn how to use the Appointment (Calendar) Project Template of SAP Gateway for Microsoft to create a C# Microsoft Visual Studio project to retrieve and update SAP Time Entries using Microsoft Outlook Calendar as the UI.
Lesson 6: Outlook Tasks Template for Workflows

Video (9:38 min)

Learn how to use the Workflow (Task) Project Template of SAP Gateway for Microsoft to create a C# Microsoft Visual Studio project to retrieve and update SAP Workflow Tasks using Microsoft Outlook Tasks as the UI. Use of OData services used in SAP Fiori apps as well as the SAP Gateway delivered Workflow OData services will be explored.

Microsoft Visual Studio Add-in for Excel Solutions
Lesson 7: Excel Template

Video (8:04 min)

This video demonstrates how to use the Excel template of the Visual Studio Add-In of SAP Gateway for Microsoft to generates Excel Add-In solutions that bind OData Services to Excel spreadsheets.

Lesson 8: Excel Conflict Resolution

Video (7:23 min)

This demonstration will show you how to utilize ETag capabilities in SAP Gateway for Microsoft Excel to resolve conflict of data submitted by multiple users.
Microsoft Visual Studio Add-in for C# Solutions

Lesson 9: Add SAP Service Reference

Video (13:17 min)

PDF

Video (5:37 min)

This presentation provides a detailed examination of the Add SAP Service Reference feature, which enables you to include an OData service proxy to any C# project.

This PDF is the hardcopy of the video presentation with the script.

This demonstration provides a detailed examination of the Add SAP Service Reference feature.

Extending Functionality with Custom Coding
SAP Gateway for Microsoft Developer GuideDeveloper Guide

How to Guides are provided to familiarize you with the extensibility capabilities of SAP Gateway for Microsoft Add-on. We have listed scenarios that are widely used and using these scenarios as samples, the generated code can be extended as preferred.

Lesson 10: Add Custom Value Help

Video (11:12 min)

PDF


Video (12:54 min)

In this presentation, you will learn how to extend your generated SAP Gateway for Microsoft solution by

adding a custom value help.

This PDF is the hardcopy of the video presentation with the script.


This step-by-step demonstration will illustrate how to extend your generated SAP Gateway for Microsoft workflow-based solution by adding a custom value help to assist the user to select the recipient when forwarding a task in Microsoft Outlook.

Case Study: Approving SAP Leave Requests in Microsoft OutlookVideo (3:43 min)

In this demo, the end product of an extended SAP Gateway for Microsoft Outlook project for SAP Leave Request Vacation Approval scenario will be shown. The SAP Gateway for Microsoft project was developed using all three templates (Contact, Workflow, Appointment), Add SAP Reference functionality as well as examples from the Developer Guide to further extend the Outlook UI in the generated GWPAM C# coding.

Track 3: SAP Gateway for Microsoft for Business Users

Audience: Business Experts / End Users

Level:        Beginner

This track is for Business Power Users and End Users using the SAP Gateway for Microsoft Excel Add-in.  No development expertise is required.

LessonLinkDescription
Lesson 1: Excel Add-in Installation

Video (3:00 min)

Learn how to install SAP Gateway for Microsoft Excel Add-in.
Lesson 2: Using the SAP Gateway for Microsoft Excel Add-inVideo (5:36 min)

This demonstration highlights the functionality available with the SAP Gateway for Microsoft Excel Add-in

using two perspectives.

  • The first is as the power user who will bind an OData service (which points to an SAP System) to a Microsoft Excel Template and save it.
  • The second  perspective of the end user will show how the saved bound template can then be used to fetch SAP Data, update, create or delete records in Microsoft  Excel to save changes back to SAP. Single sign on, batch and etag (conflict resolution) functionality will be briefly discussed.
Lesson 2: Add Filters

Video (12:50 min)


PDF

This  presentation and demonstration covers the Add Filter topic of SAP Gateway for Microsoft Excel Add-in. You will learn how to use filters to limit results when fetching data from SAP. This topic is a deeper dive into filters and recommended for the power user.

This PDF provides a hardcopy of the Add Filter content  outlined in the Video.

Lesson 3: Batch Processing

Video (12:03 min)

PDF 

This presentation and  demonstration covers the Batch Feature of SAP NetWeaver Gateway productivity  accelerator for Microsoft Excel. You will learn how batch operations are supported and can be enabled.

This video is a deeper dive into Batch Processing and recommended for the power user.


This PDF provides a hardcopy of the Batch Processing content outlined in the Video.

Track 4: SAP Gateway for Microsoft Security and Supportability

Audience: Technical

Level:        Intermediate

This track is intended for administrators and developers to learn about security features for solutions as well as understand how to use the supportability features of SAP Gateway for Microsoft.

LessonLinkDescription
Lesson 1: SecurityPDF

This presentation will cover the Security features available for SAP Gateway for Microsoft as well as step by step instructions on the Group Policy Roll-Out.

Lesson 2: SupportabilityPDFSupportability features and considerations when using SAP Gateway for Microsoft will be covered in this presentation.

Tags: