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
| Lesson | Link | Description |
|---|---|---|
| Lesson 1: SAP Gateway for Microsoft Product Features | 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! | Blog | What's new for SAP Gateway for Microsoft Service Pack 02? |
| Lesson 3: SAP Gateway for Microsoft Installation Use Cases | Document | Get 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
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
| Lesson | Link | Description |
|---|---|---|
| Getting Started | ||
| Lesson 1: Visual Studio Add-in Installation | Video (5:00 min) | Learn how to install the SAP Gateway for Microsoft Visual Studio Add-In. |
| Lesson 2: Introduction to OData | 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 | 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 | 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) | 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 | 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 | 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 | 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 | 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 Guide | Developer 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 | 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.
| |
| Case Study: Approving SAP Leave Requests in Microsoft Outlook | Video (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.
| Lesson | Link | Description |
|---|---|---|
| Lesson 1: Excel Add-in Installation | Learn how to install SAP Gateway for Microsoft Excel Add-in. | |
| Lesson 2: Using the SAP Gateway for Microsoft Excel Add-in | Video (5:36 min) | This demonstration highlights the functionality available with the SAP Gateway for Microsoft Excel Add-in using two perspectives.
|
| Lesson 2: Add Filters | 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 | 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.
|
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.
| Lesson | Link | Description |
|---|---|---|
| Lesson 1: Security | 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: Supportability | Supportability features and considerations when using SAP Gateway for Microsoft will be covered in this presentation. |
