Reduced Manual Work and Errors with Azure Hybrid Integration for an Australian Not-for-profit Organization
Industry:
Non-Profit
Region:
Australia
Technology:
Azure Synapse
About the Client
Our client is an Australian not-for-profit organization providing dedicated human and social services. Their vision was to implement an integration solution between HR and IT systems, laying the foundation for future integrations. This system would manage the synchronization of employee profile data between Dayforce, Microsoft Entra (Azure AD), and Active Directory.
Challenges
- Employee profile data was managed across disparate systems
- Data synchronization between the systems was non-automated, leading to frequent data discrepancies and user complaints
- IT and operational overheads were high due to the manual management of operations and security
Solutions
- Evoke developed Custom Azure integration
- Synapse pushed data into databases hosted in a private VNET
- The database design was extendible, supporting reporting and live status monitoring
Results
- Reduced manual work and minimized errors
- Reduced Azure costs (cost based on consumption)
- The solution was aligned with cloud security practices, reducing IT operational overhead
- Secure storage and retrieval of credentials from Key Vault were implemented
- OAuth 2.0 authentication was used between Azure and external systems
- IP address whitelisting was configured for Azure services
- RBAC and managed identity permissions were assigned
