Transforming business operations using a data-driven approach to create solutions
ActivTrak
ActivTrak is a cloud based user activity monitoring software. It has features like, Productivity tracking, Real-time monitoring feed, Application monitoring, etc.
Goal
Logging tracks for web browsers and applications for all the users across, along with a date and timestamp, and it can be an incredibly useful for tracking accurate user activity.
Working
Built a pipleline on Azure Data Factory to get data from ActivTrak for calculating the productivity of all the active employee. POSTMAN was used to get the Access token using OAuth 2.0 and additional headers. Azure Web Activity was used to pull data from ActivTrak. Writing a Big query to calculate productivity of employee. The copy activity was used to map the tables into sink side i.e. Azure Blob Storage. It gets all your employee details Azure Blob Storage. Dashboards were created using Visualization tool (POWER BI).
Previous
Next
Pipeline in Azure Data Factory
GCP to Azure Blob storage
ULTIPRO
UltiPro is a Human capital management solution. It provides records of HR, Payroll and Talent Management.
Goal
To connect it with ActivTrak employee logs and build a proper hierarchy of employees to track user productivity at different levels in an organization.
Working
A pipeline was built on Azure Data Factory to get data from UltiPro REST API. POSTMAN was used to get the additional headers. Azure Web Activity was used to pull data from UltiPro web API. Then a copy activity was used to map it Azure Synapse Analytics. It gets all your employee details into Azure Synapse.
Previous
Next
WEBEX
Goal
There is an increasing need to pull employee data from various sources into one platform so that this data is then used later for analyzing performance, keeping track of operations and for necessary documentation. Here, we pulled employee data from Webex using REST API into Azure Data Factory.
Working
Web Activity:
Performs an authentication task and get access token.
Copy Activity:
Fetches data from API and load it to a destination linked service.
In the above picture two linked services created: REST and Azure Storage They act just like connection managers in SSIS. The next abstraction is a Dataset. The Dataset is a named view of data that simply points or references the data that has to bed used in activities as inputs and outputs. SSIS has analogs in its dataflow – various sources and destinations. And the final piece – Copy activity. It is a generic task that copies data among various data stores located on-premises and in the cloud. A pipeline was built on Azure Data Factory to get data from Webex. REST API was used to get the authorization (Bearer Token). Azure Web Activity was used to pull data from Webex. Then a copy activity was used to map it Azure Synapse Analytics. Hence the pipeline gets all the employee details into Azure Synapse.
Previous
Next
ENTERPRISE DATA PLATFORM
Track all employee activities from their logs and meetings based on hierarchy within the organization.
Contact us for a quote, help, or to join the team.