Company
Avon Maitland District School Board
Industry
Education
Target
Automate updates between HR and IT systems by integrating HR/Student data with Active Directory
Challenge
- Current system is manually performed; HR informs IT via email of changes in staffing or students
- No integration existed between HR systems and IT infrastructure
KingswaySoft Solution
SSIS Integration Toolkit for Directory Services
Value Delivered
Eliminated manual effort by automating daily AD updates using HR system data. KingswaySoft’s Upsert functionality simplified development and ensured timely, accurate changes for staff and student access, significantly boosting operational efficiency.
Overview
Avon Maitland District School Board needed a better way to effectively manage the constant changes of staff and students.
The school board was looking to automate this process by implementing a system that would read their HR and Student Management System, a SQL database, to check for any changes or additions and update their Active Directory system automatically through SSIS.
The Challenge
The Avon Maitland School Board did not have any integration system in place between their HR system and Active Directory. In order for changes to incur in Active Directory, the IT Department needed to manually update the system and relied on someone from the HR Department informing them of the necessary changes that needed to be made. This resulted in delays for the staff and students as it could take up to a week for the IT Department to be notified. The School Board needed to set-up a system that would use the data from their HR and Student Management Systems to update Active Directory automatically in order to eliminate these delays.
The Solution
Initially Avon Maitland District School Board was considering hiring a developer to customize an automated solution which would have been a highly costly endeavor and taken several months to implement. When the school board first inquired about the SSIS Integration Toolkit for Directory Services they were unfamiliar with SSIS, by working with KingswaySoft and enrolling in their training course they were able to quickly learn an unfamiliar platform and begin developing their integration project.
One such feature The Center for Health Affairs uses regularly is the ability to execute a CRM workflow. They use this action frequently within their data integration development in order to automate the execution of emails and other CRM processes. With their previous system, a similar set-up required the development team to include the email body within the data integration project which they would need to constantly update for the CRM users. By taking advantage of KingswaySoft’s ExecuteWorkflow feature, the body of the email can exist within CRM allowing the appropriate CRM users to access and modify the email body and workflow as needed without development’s involvement. This gives control back to the CRM users and provides less maintenance for the development team as the data integration jobs do not need to be re-configured when changes are made to the workflow within CRM.
The Results
Avon Maitland District School Board now has an automated system to update their Active Directory when there are student or employee changes made within the board. The board no longer needs to rely on individual notices about changes which eliminates delays for their staff and students and increases overall efficiency. Now when HR makes any changes in their system, those changes are automatically made in Active Directory using SSIS. Due to the great success of this project Avon Maitland District School Board hopes to utilize KingswaySoft tools to automate more processes in the future.
"KingswaySoft continues to offer us excellent service and support for our AD/HRIS integration system. Their knowledge and customer service is top notch. "
Jason Hillier
Manager of Information Technology
Avon Maitland District School Board
DOWNLOAD CASE STUDY
See More Case Studies
Get in Touch
If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!