Business Systems Developer

Maytas / Canvas Integration

Project Duration

March 2016 to May 2016

Project Summary

Developed an interface between QA's existing student record system, Maytas, and the VLE, Canvas. A complex solution involving NET.ASP, C# and database functionality (stored procedures, functions, view, etc.)

Project Details

Student Integration

Stored procedure and trigger created to monitor Maytas database for new students. Trigger would also monitor updates to student first name, surname and email address. Any inserts / updates would be passed onto a temporary audit table storing log of all pending changes. The process reported back on success / failure and would store any errors returned.

Assessor Integration

Similar to the ‘Student Integration’, except that the trigger would fire on a new assessor record being created in Maytas. Again, the trigger would also log any changes to the assessor’s name or email address. The process reported back on success / failure and would store any errors returned.

Enrolment Integration

Maytas and Canvas had a substantially different business model for students, teachers and their enrolments on courses, thereby complicating the integration between the two systems. Additionally, checks were required to ensure that both the student and assessor accounts had already been created in Canvas. Stored procedure and trigger created to monitor Maytas database for new enrolments. This process also had to create new course sections (i.e. a collection of users within a course) and ensure that any student was only ever enrolled onto a single course section within a course at any one time.