Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
dvankempen
Product and Topic Expert
Product and Topic Expert
6,904






Earlier this year, matthew.shaw published a technical article about user onboarding automation

For the SAP HANA Academy and the Partner Innovation Lab, we have created a video tutorials where you can see the sample scripts in action. In this article you will find the videos embedded with references and some additional information.

To be informed when new posts are published about partner-related content in the video tutorials series, follow tag

Questions? Please post as comment.

Useful? Give us a like and share on social media.

Thanks!




Hands-On Video Tutorials


What You Will Learn


In ten videos and a little over one hour we show how to get started.

  1. Covers the functionality and restrictions of the Security user interface of SAP Analytics Cloud

  2. Explains how to register an OAuth client and work with Postman environment and collections

  3. Shows how we can call APIs using the command line using Newman

  4. Explains the process flow of a create user API call

  5. Shows how we can perform delete user requests

  6. Shows how we can perform create teams requests

  7. Shows how we can perform delete teams requests

  8. Shows how we can perform delete teams with members requests

  9. Shows how we can perform add/replace/delete/keep actions on users and roles within teams

  10. Shows how we can perform add/replace/delete/keep actions on users and teams


Playlist


For more video tutorials on the topic, check the playlist



Security Management 


SAP Analytics Cloud


In this video tutorial we discuss use case and functionality of the Security Management menu to create users, teams, and role, as a prelude to automation using the SCIM API.

https://youtu.be/CFDj0H3NDcA?list=PLkzo92owKnVzTXbf1XBOZf03_CvD7DRr0

Time Markers


0:00 - Introduction

1:20 - SAP API Business Hub

1:50 - User, team, and role management using the System menu

2:45 - Import users from file

Resources


For the documentation about user administration, see

For the API specification, see

 




Register OAuth Client


Collection 001


In this video tutorial we start our preparations, configure the Postman environment, and create an OAuth client to obtain an access and X-CSRF token.

Postman collection:

https://youtu.be/4OyLqrJh4ik?list=PLkzo92owKnVzTXbf1XBOZf03_CvD7DRr0

Time Markers


0:00 - Introduction and documentation references

2:50 - Postman

3:10 - Sample scripts

4:00 - Import environment and collection 001

5:00 - Configure environment

6:30 - Create OAuth client

8:15 - Get access token

9:55 - Send POST call for access token

10:30 - GET Users for x-csrf token

Resources


For product information about creating an OAuth client, see

About CSRF, see

To download Postman, visit the website (alternatively, you can use the web client). Here you can also find the documentation and other learning material, highly recommended for those interested in learning how we can interact with APIs


For matthew.shaw's API best practices, see

To download the scripts, visit SAP-samples on Github


For information about namespaces, see



Newman


Collection 101


In this video tutorial we show how we can create users programmatically using the Postman Node.js command line client newman.

Postman collection:

https://youtu.be/UfmauS2xagk?list=PLkzo92owKnVzTXbf1XBOZf03_CvD7DRr0

Time Markers


0:00 - Introduction

1:20 - Execute newman run command

2:20 - Console output

Code


The command executes collection run with the environment from env.json and with data.csv as data input.
newman run run.json -e env.json -d data.csv

Resources


Newman is documented and available for download from NPM.org




Create User


Collection 101


In this video tutorial we show how we can create users programmatically using the SAP Analytics Cloud User and Team Provisioning SCIM API.

Postman collection:

https://youtu.be/W2vislXKVUY

Time Markers


0:00 - Introduction

0:30 - Download newman

1:00 - Import environment

1:30 - Import collection

2:00 - POST Users

7:30 - POST access token

8:50 - GET Users

9:40 - Run collection

9:50 - Documentation

12:00 - Error handling

 



Delete User


Collection 301


In this video tutorial we show how we can delete users programmatically using the SAP Analytics Cloud User and Team Provisioning SCIM API.

Postman collection:

https://youtu.be/PaDAR7BQi_w

Time Markers


0:00 - Introduction

0:40 - Deleting users in SAP Analytics Cloud

1:30 - Import collection

2:00 - Delete request

4:10 - User guide

4:50 - Run collection

6:40 - Create and delete user



Create Team


Collection 501


In this video tutorial we show how we can create teams programmatically using the SAP Analytics Cloud User and Team Provisioning SCIM API.

Postman collection:

https://youtu.be/mLMKlqrNqOU

Time Markers


0:00 - Introduction

0:30 - Teams in SAP Analytics Cloud

2:00 - Import collection

2:20 - User guide

3:50 - Input file

4:20 - Read team (GET)

5:50 - Create team (POST)

6:50 - Update team (PUT)

7:40 - Run collection

9:05 - Teams in SAP Analytics Cloud


Delete Team


Collection 801 & 802


In this video tutorial we show how we can delete teams programmatically using the SAP Analytics Cloud User and Team Provisioning SCIM API.

For very large teams with 10,000 users or more, consider using collection 802 which removes users and role assignment first before deleting the team. This to avoid a time-out on the delete statement.

Postman collections

https://youtu.be/ptDDM_W5eNc

Time Markers


0:00 - Introduction

0:30 - Import collections and set environment

0:55 - User guide

1:55 - Collection 801, common request features

3:45 - GET READ team

3:55 - DELETE team

4:20 - GET READ non-existent team

4:50 - Run collection 801

6:15 - Run collection 103 to recreate users with team

7:15 - Collection 802

7:25 - GET READ team

7:55 - PUT EMPTY team

9:05 - DELETE team

9:25 - Run collection 802


Delete Team and Users


Collection 851


In this video tutorial we show how we can delete teams and users programmatically using the SAP Analytics Cloud User and Team Provisioning SCIM API.

Postman collection

https://youtu.be/BK8jIfCalQY

Time Markers


0:00 - Introduction

0:30 - Documentation

1:15 - GET Groups

1:50 - DELETE Users

2:15 - DELETE Groups

2:30 - GET Groups

2:45 - Run collection 851

3:50 - Result in SAP Analytics Cloud


Users and Roles Actions on Teams


Collection 602 (612)


In this video tutorial we show how we can perform add/replace/delete/keep actions on users and roles within teams using the SAP Analytics Cloud User and Team Provisioning SCIM API.

Postman collection

https://youtu.be/o-gmtDKilOw

Time Markers


0:00 - Introduction

0:40 - User Guide

1:30 - Data file

2:10 - GET Groups

3:25 - PUT Groups

4:30 - POST Groups

5:25 - User security before

6:10 - Run collection 602

7:35 - User security after


Update Users and Teams


Collection 401 | 403 | 404


In this video tutorial we show how we can perform add/replace/delete/keep actions on users and teams using the SAP Analytics Cloud User and Team Provisioning SCIM API.

Postman collection

https://youtu.be/emDiUFCi_vk

Time Markers


0:00 - Introduction

2:00 - User Guide

2:30 - Collection 401

6:00 - Collection 404

7:00 - Collection 403


Share and Connect


Questions? Please post as comment.

Useful? Give us a like and share on social media.

Thanks!

If you would like to receive updates, connect with me on

For the author page of SAP PRESS, visit








Over the years, for the SAP HANA Academy, SAP’s Partner Innovation Lab, and à titre personnel, I have written a little over 300 posts here for the SAP Community. Some articles only reached a few readers. Others attracted quite a few more.

For your reading pleasure and convenience, here is a curated list of posts which somehow managed to pass the 10k-view mile stone and, as sign of current interest, still tickle the counters each month.


/ul>
8 Comments