Overview
Scope
Currently, most downstream systems integrate with EUCLID using the legacy EUGEX database, which has limitations such as specific update times, ongoing maintenance requirements, and susceptibility to failure. Tribal roadmap is to make API (Application Programme Interface), available in the future (next SITS versions) but only to cloud clients. Change-based event integrations with EUCLID have already been implemented for some systems e.g. P&M student fees, Enquiry Management and the new Student Case Management System.
The project will deliver generic students and programmes/courses related API which abstract downstream systems from Tribal technologies. Downstream applications will fetch the most up-to-date student and applicant data from EUCLID.
Out of scope
-
the success of the project is to deliver/make the API available, but it will not deliver the integration to downstream systems (those using EUGEX or StuTalk). This is dependent on resources and requirements available and would require further work outside student systems or require external resources for development and testing.
-
The file generator is used to generate the csv from a number of EUGEX views for different end users. Replacing the file generator integration to these applications/users is out of scope for this project for two reasons: 1) for resource constraints, 2)this project will focus on delivering the API for student records. Once we have a set of APIs available, then we can look at replacing the existing integration/technologies with API. It will require more coordinated effort with the stakeholders to move from file-based integration into API based integration. So, ideally this will be delivered by a separate project.
Objectives and Deliverables
Ref |
Objectives |
Deliverables |
Priority |
Benefits |
O1 |
Analyse generic API |
D1-Articulate the level of access security required
D2-Improve current change-based events to make the triggers of SITS change more generic, incl error handling & notifications
D3- Analyse the CAM requirements for the degree finder, clarify what’s in scope for tuition fees
D4- Analyse the Timetabling requirements D3.1/4.1 Define the data model for each API, i.e. what the properties does a ‘student’ ( and ‘a programme’) have
D5- Analyse the future SITS API
|
Must
Must
Should Should Should
Should |
D1/D2:
D3- replacing the current use of csv files, which are manual steps
D4- replacing the current EUGEX integration built for EventMap
D5-when supplier's SITS API becomes available, this could be used |
O2 |
Build API |
D6-Build API for Programme and Course information incl tuition fees
D7-Build API for Student information and Student Course Enrolment
|
Must
Must |
|
O3 |
Test cases the new built API |
D8-Deliver test case: the generic API can integrate with Degree Finder and Timetabling EventMap. SSP will deliver the platform for other services to integrate to. The success of the test case will be to test the data is available to the end points in EUCLID when fetching data.
D9-Test the change notifications are sent correctly from EUCLID .
D10-Build dashboard to represent the availability of the end points. |
Must
Must
Could |
The expected benefit of this project will be for developers of systems looking to integrate using the API (e.g. Degree Finder, Timetabling) can be confident that the API is robust, and that the integration can be tested/implemented successfully. Noting that future benefits if the Degree Finder delivers a separate project to access new API would be significant:
|
O4 |
Documentation |
D11-Documentation on how downstreams applications can consume the SITS data D12-Articulate the Data Access Protocol |
Must
Must |
Wiki documentation. New API is updated in Abbacus
The Data Access Protocol process is reviewed in light of the new available API for passing sensitive student data |
Success Criteria
The success will be to confirm the data is available to the end points in EUCLID when fetching data, evidenced by test cases working with Timetabling and Degree Finder services.
Project Milestones
Stage | Milestone | Due Date |
---|---|---|
Plan | Project brief sign off | 26-Aug-2024 |
Analyse | Analyse- Engagement, capture requirements, review design | 18-Sep-2024 |
Build | Build API 1st set: course and programme | 07-Oct-2024 |
Build | Build API 2nd set: Students | 28-Oct-2024 |
Integrate | Testing API | 25-Nov-2024 |
Accept | Test case with CAM | 02-Dec-2024 |
Accept | Test case with Timetabling | 16-Dec-2024 |
Accept | Rework API | 15-Jan-2025 |
Deliver | Deploy API | 31-Jan-2025 |
Deliver | Review DSOR | 14-Feb-2025 |
Close | Close | 28-Feb-2025 |