Go Green One tree
One life
Trees
Loading...

Project Overview

The project is for a client who is a popular global design organization located in the USA, with branches all over the globe. They have a team of designers, engineers, teachers, and researchers who look at creating change through design, by building learning platforms and tools to unlock creativity. They create human-centered inventions, services, spaces, and associations that empower groups, cities, and even countries.

The client was keen to store and report contractor information separately amidst data of regular workers and contingent workers. The challenge was to combine users from two applications – Bamboo HR & Okta making sure that the person-wise information exists in any one application only and does not duplicate.  Another challenge was to introduce Okta code in a smarter way so that existing BambooHR logic will work efficiently and the collaboration between the two systems remains smooth.

Looking at the challenges faced by the client, SPEC INDIA followed an automated process that created and deployed custom activities for Okta and executed it along with a regular data processing cycle scheduled at a 4-hour interval. Okta users’ data was populated in Person & Person Job table. All these processes were automated through Azure Data Factory.

Our team introduced Okta for contingent workers. Okta is an enterprise-grade, identity management service, built for the cloud, but compatible with many on-premises applications. Full-time regular workers were managed through the BambooHR application, but contingent workers/contractors were managed through Okta profiles. Another use case for Okta was to use it as a Single Sign On authentication process for all other applications.

Key Components
  • Analysis of Okta profiles and map Okta attributes with BambooHR fields
  • Pull data from Okta through custom activities (.NET API code)
oktaintegration-screen

Core Features

We wrote custom activities in Azure to pull data from Okta and merge both contractors (Okta users) and regular employees (BambooHR users) into common Person & Person Job tables. Reporting team distinguished contractors or regular employees based on the Person Type field.

Key Inclusions

Merge Okta users with BambooHR users while populating Person & Person Job Information

Report on Contractors

Technologies And Platform We Use

.NET-Logo
.NET
Azure-Data-Factory
Azure Data Factory
Azure-Logo
Azure
MS-SQL-Logo
U-SQL
visual studio-cs
Visual Studio

Business Benefits

Our solution enabled the business to achieve the following benefits:

Effective reporting and monitoring of contractor information

Single Sign On authentication for all applications

Improved user experience

Robust, smooth, and effective business process execution

Automated processes and increased returns

Better collaboration with any person on any device

Robust reporting features

Let’s get in touch!