How do I integrate with AD, LDAP & other HRIS tools for centralised user management?

Server version of UpRaise can integrate with 3rd party systems such as AD, LDAP, HRIS, DaaS softwares for centralized user management. Typically, these systems should push reports to a pre-configured SFTP server, from where UpRaise can poll data at a set frequency.

Setting up SFTP connection

Admin/super admin can navigate to company directory under administration & then click on 'HRMS Sync' tab >> Server details tab. This is where the SFTP connection is configured. 

• Auto-sync - on/off, dictates whether UpRaise will connect to the SFTP server daily night 11 o'clock to retrieve the JSON files

• SFTP Server - host name or IP address

• Port - usually SFTP is configured at 22

• username & password - to connect with the SFTP server

• Directory - relative path to the directory where the JSON files will be available

Add the above information & click on 'Save'. On successful connection, the configuration will be saved. Otherwise, a relevant error message will be displayed.

The first time around, it may take a few trial & errors to get the JSON format right. That is why there is a manual trigger. Manual trigger accepts name of the JSON file & searches for it in the SFTP folder. Once you get the format correct, just start dumping these JSONs on a daily basis in the configured folder. Expected naming of the file follows the pattern - UsersDataYYYYMMDD.json

Once completed, UpRaise will generate a file with execution status in the same SFTP (for which it needs Write permissions on the SFTP).

Format & content of these reports should be as explained below: 

Employee data JSON structure

UpRaise expects to receive only the user records in which one or more of the following attributes have been updated - designation, manager, team, UpRaise role. If there are updates to other user attributes in the external system, UpRaise doesn't need to know.

Employee Data JSON Structure

{ 
 "users":[   
      {   
         "id":"11081", 
         "jirausername":"Jane.Doe", 
         "designation":{   
            "id":"94", 
            "name":"Consultant, eLearning & Systems" 
         }, 
         "userrole":"USER", 
         "manager":{   
            "id":"9195", 
            "jirausername":"John.Doe" 
         }, 
         "teams":[   
            {   
               "id":"10017", 
               "name":"HR" 
            } 
         ] 
      } 
   ] 
} 

Parameter details

Team data JSON structure

UpRaise expects to receive team records in which one or more of the following attributes have been updated - team name, team id, team lead id & name, parent team name & id, team type & description. If there are updates to other team attributes in the external system, UpRaise doesn't need to know.

Employee Data JSON Structure

{
  "teams": [
    {
      "id": "741",
      "name": "Sales",
      "teamLead": {
        "id": "1",
        "jirausername": "John.Doe"
      },
      "parentTeam": {
        "id": "249",
        "name": "Business Development"
      },
      "teamType": {
        "name": "Department"
      },
      "description": {
        "name": "Team responsible for bringing in Dollars."
      }
    }
  ]
}

Parameter details