Skip to Content
Technical Articles
Author's profile photo Sabarna Chatterjee

Azure + SCP ==> Automate user ID Creation for SCP Neo DB

There were 18 members to be onboarded to start an SCP HANA Development Project. I thought to create a UI5 App for them to get there userIDs for the SCP Neo DB but it might have taken more time.

Then I thought to use Microsoft Forms and tried to fetch the data from the Microsoft SharePoint. Due to some authorization issues, I was not able to do it.

Just then I found some capabilities of Power Automate which can be used for automating this. So here I present a simple solution to the onboarding of users in SCP Neo DB.

 

Here is what I have developed ->

  • Created a Microsoft Forms
  • Created Automation logics to Validate and get approval from the Manager and create an SCP DB User
  • Then forwarded the Microsoft Forms to my colleagues. ?

Here is the Architecture followed:

Architecture

Architecture

 

Here is the Git Snippet: Automate SCP User ID Creation by Azure Power Automate

Tools Used: 

  • Microsoft Forms
  • Power Automate
  • SCP Neo HANA DB XSJS

 

STEP1: Created Microsoft Forms as below:

Microsoft%20Forms

Microsoft Forms

 

STEP2: Created Flow in Power Automate:

Flow%20in%20Power%20Automate

Flow in Power Automate

 

STEP3: Created XSJS Code in SCP Neo DB. Along with that added some roles and tables to track the userIDs.

 

STEP4: Call the XSJS code from the HTTP Post in Power Automate.

STEP5: Test it..

STEP6: Pass it(the Microsoft Form link to the respective users).

STEP7: That’s it.

 

#staysafe

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.